Chetan Bhat created CARBONDATA-3853:
---------------------------------------

             Summary: Dataload fails for date column configured as 
BUCKET_COLUMNS
                 Key: CARBONDATA-3853
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-3853
             Project: CarbonData
          Issue Type: Bug
          Components: data-load
    Affects Versions: 2.0.0
            Reporter: Chetan Bhat


Steps and Issue

0: jdbc:hive2://10.20.255.171:23040/> create table if not exists 
all_data_types1(bool_1 boolean,bool_2 boolean,chinese string,Number 
int,smallNumber smallint,BigNumber bigint,LargeDecimal double,smalldecimal 
float,customdecimal decimal(38,15),words string,smallwords char(8),varwords 
varchar(20),time timestamp,day date,emptyNumber int,emptysmallNumber 
smallint,emptyBigNumber bigint,emptyLargeDecimal double,emptysmalldecimal 
float,emptycustomdecimal decimal(38,38),emptywords string,emptysmallwords 
char(8),emptyvarwords varchar(20)) stored as carbondata TBLPROPERTIES 
('BUCKET_NUMBER'='2', *'BUCKET_COLUMNS'='day'*);
+---------+--+
| Result |
+---------+--+
+---------+--+
No rows selected (0.494 seconds)
0: jdbc:hive2://10.20.255.171:23040/> LOAD DATA INPATH 
'hdfs://hacluster/chetan/datafile_0.csv' into table all_data_types1 
OPTIONS('DELIMITER'=',' , 
'QUOTECHAR'='"','BAD_RECORDS_ACTION'='FORCE','FILEHEADER'='bool_1 ,bool_2 
,chinese ,Number ,smallNumber ,BigNumber ,LargeDecimal ,smalldecimal 
,customdecimal,words ,smallwords ,varwords ,time ,day ,emptyNumber 
,emptysmallNumber ,emptyBigNumber ,emptyLargeDecimal 
,emptysmalldecimal,emptycustomdecimal ,emptywords ,emptysmallwords 
,emptyvarwords');
*Error: java.lang.Exception: DataLoad failure (state=,code=0)*

 

*Log-*



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to