I loaded the data with the timestamp field unsuccessful,and timestamp field
is null.
my sql:
carbon.sql("create TABLE IF NOT EXISTS test1 (date timestamp,id string)
STORED BY 'carbondata' TBLPROPERTIES
('DICTIONARY_INCLUDE'='date','DATEFORMAT'='date:yyyy/MM/dd')")
carbon.sql("LOAD DATA inpath 'hdfs://myha/user/carbon/testdata/test4.csv'
INTO TABLE test1 options('FILEHEADER'='date,id')")
my data test4.csv:
2017/3/23,2
2017/1/11,1
2017/9/17,3
when i select:
+----+---+
|date| id|
+----+---+
|null| 1|
|null| 2|
|null| 3|
+----+---+
i print time format is correct:
println(CarbonProperties.getInstance().getProperty(CarbonCommonConstants.CARBON_TIMESTAMP_FORMAT))
yyyy/MM/dd
What could be the reason for it?
thx.
--
View this message in context:
http://apache-carbondata-mailing-list-archive.1130556.n5.nabble.com/I-loaded-the-data-with-the-timestamp-field-unsuccessful-tp8417.html
Sent from the Apache CarbonData Mailing List archive mailing list archive at
Nabble.com.
