페이지 이력

CREATEcreate EXTERNALexternal TABLEtable spectrum.sales(
 salesid INTEGERinteger,
 listid INTEGERinteger,
 sellerid INTEGERinteger,
 buyerid INTEGERinteger,
 eventid INTEGERinteger,
 dateid SMALLINTsmallint,
 qtysold SMALLINTsmallint,
 pricepaid DECIMALdecimal(8,2),
 commission DECIMALdecimal(8,2),
 saletime TIMESTAMP
timestamp)
ROWrow FORMATformat DELIMITEDdelimited
FIELDSfields TERMINATEDterminated BYby '\t'
STOREDstored ASas TEXTFILEtextfile
LOCATIONlocation 's3://awssampledbuswest2/tickit/spectrum/sales/'
TABLEtable PROPERTIESproperties ('numRows'='172000');