[ https://issues.apache.org/jira/browse/CARBONDATA-4157?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Yahui Liu updated CARBONDATA-4157: ---------------------------------- Summary: load timestamp data didn't consider daylight saving time (was: load data timestamp data didn't consider daylight saving time) > load timestamp data didn't consider daylight saving time > -------------------------------------------------------- > > Key: CARBONDATA-4157 > URL: https://issues.apache.org/jira/browse/CARBONDATA-4157 > Project: CarbonData > Issue Type: Bug > Components: data-load > Affects Versions: 2.1.0 > Reporter: Yahui Liu > Priority: Minor > > # prepare one txt file contains 1 time data in daylight saving time, for > example "1991-08-12 00:00:00" > # upload the file to one hdfs folder, for example /tmp/test_time > # create carbon table: create table test_time(t timestamp) stored as > carbondata; > # create one external txt table with location to the data file folder: > create table test_time_txt(t timestamp) location '/tmp/test_time'; > # insert the data in txt table into carbon table: insert into test_time > select * from test_time_txt; then query carbon table, result is: > # +------------------------+ > | t | > +------------------------+ > | 1991-08-12 01:00:00.0 | > +------------------------+ > # load data directly into carbon table: load data inpath '/tmp/test_time' > into table test_time options('fileheader'='t'); then query carbon table, > result is: > # +------------------------+ > | t | > +------------------------+ > | 1991-08-12 00:00:00.0 | > +------------------------+ > # same data file, insert into and load data give different result, and > because "1991-08-12 00:00:00" is in daylight saving time, so most of the file > format give "1991-08-12 01:00:00" as the result. -- This message was sent by Atlassian Jira (v8.3.4#803005)