Hello All,
I have this table CREATE TABLE DBCLOC( BLwhse int COMMENT 'DECIMAL(5,0) Whse', BLsdat string COMMENT 'DATE Sales Date', BLreg_num smallint COMMENT 'DECIMAL(3,0) Reg#', BLtrn_num int COMMENT 'DECIMAL(5,0) Trn#', BLscnr string COMMENT 'CHAR(1) Scenario', BLareq string COMMENT 'CHAR(1) Act Requested', BLatak string COMMENT 'CHAR(1) Act Taken', BLmsgc string COMMENT 'CHAR(3) Msg Code') PARTITIONED BY (FSCAL_YEAR smallint, FSCAL_PERIOD smallint) STORED AS PARQUET; have to load from hdfs location /extract/DBCLOC/DBCL0301P.csv.gz to the table above Can any one tell me what is the most efficient way of doing it. Thanks Jay