hadoop-common-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kumar Jayapal <kjayapa...@gmail.com>
Subject how to load data
Date Wed, 29 Apr 2015 22:26:33 GMT
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

Mime
View raw message