LOAD TABLE lineitem
(
l_orderkey BINARY WITH NULL BYTE,l_partkey BINARY WITH NULL BYTE,
l_suppkey BINARY WITH NULL BYTE,l_linenumber BINARY WITH NULL BYTE,
l_quantity BINARY WITH NULL BYTE,l_extendedprice BINARY WITH NULL BYTE,
l_discount BINARY WITH NULL BYTE,l_tax BINARY WITH NULL BYTE,
l_returnflag BINARY WITH NULL BYTE,l_linestatus BINARY WITH NULL BYTE,
l_shipdate BINARY WITH NULL BYTE,l_commitdate BINARY WITH NULL BYTE,
l_receiptdate BINARY WITH NULL BYTE,l_shipinstruct BINARY WITH NULL BYTE,
l_shipmode BINARY WITH NULL BYTE,l_comment BINARY WITH NULL BYTE
)
FROM 'C:\\mydata\\lineitem_binary.inp'
FORMAT BINARY
STRIP OFF
QUOTES OFF
ESCAPES OFF
PREVIEW ON
BYTE ORDER HIGH;
COMMIT
This comment has been removed by the author.
ReplyDelete