[ https://issues.apache.org/jira/browse/DRILL-4226?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Volodymyr Vysotskyi resolved DRILL-4226. ---------------------------------------- Resolution: Fixed Fix Version/s: 1.12.0 Fixed in the scope of DRILL-5717. > TestExtendedTypes#checkReadWriteExtended fails when the time zone is ahead of > UTC > --------------------------------------------------------------------------------- > > Key: DRILL-4226 > URL: https://issues.apache.org/jira/browse/DRILL-4226 > Project: Apache Drill > Issue Type: Bug > Components: Execution - Data Types > Affects Versions: 1.4.0 > Environment: Mac OS X 10.10.5 > Reporter: Akihiko Kusanagi > Priority: Major > Fix For: 1.12.0 > > > Set the time zone to Asia/Tokyo on Mac OS X: > {noformat} > $ sudo systemsetup -gettimezone > Time Zone: Asia/Tokyo > {noformat} > TestExtendedTypes#checkReadWriteExtended fails with the following output: > {noformat} > Running > org.apache.drill.exec.vector.complex.writer.TestExtendedTypes#checkReadWriteExtended > ... > Tests run: 2, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 6.17 sec <<< > FAILURE! - in org.apache.drill.exec.vector.complex.writer.TestExtendedTypes > checkReadWriteExtended(org.apache.drill.exec.vector.complex.writer.TestExtendedTypes) > Time elapsed: 0.403 sec <<< FAILURE! > org.junit.ComparisonFailure: expected:<...ateDay" : "1997-07-1[6" > }, > "drill_timestamp" : { > "$date" : "2009-02-23T08:00:00.000Z" > }, > "time" : { > "$time" : "19:20:30.450Z" > }, > "interval" : { > "$interval" : "PT26.400S" > }, > "integer" : { > "$numberLong" : 4 > }, > "inner" : { > "bin" : { > "$binary" : "ZHJpbGw=" > }, > "drill_date" : { > "$dateDay" : "1997-07-16]" > }, > "drill_...> but was:<...ateDay" : "1997-07-1[5" > }, > "drill_timestamp" : { > "$date" : "2009-02-23T08:00:00.000Z" > }, > "time" : { > "$time" : "19:20:30.450Z" > }, > "interval" : { > "$interval" : "PT26.400S" > }, > "integer" : { > "$numberLong" : 4 > }, > "inner" : { > "bin" : { > "$binary" : "ZHJpbGw=" > }, > "drill_date" : { > "$dateDay" : "1997-07-15]" > }, > "drill_...> > at > org.apache.drill.exec.vector.complex.writer.TestExtendedTypes.checkReadWriteExtended(TestExtendedTypes.java:60) > ... > Failed tests: > TestExtendedTypes.checkReadWriteExtended:60 expected:<...ateDay" : > "1997-07-1[6" > }, > "drill_timestamp" : { > "$date" : "2009-02-23T08:00:00.000Z" > }, > "time" : { > "$time" : "19:20:30.450Z" > }, > "interval" : { > "$interval" : "PT26.400S" > }, > "integer" : { > "$numberLong" : 4 > }, > "inner" : { > "bin" : { > "$binary" : "ZHJpbGw=" > }, > "drill_date" : { > "$dateDay" : "1997-07-16]" > }, > "drill_...> but was:<...ateDay" : "1997-07-1[5" > }, > "drill_timestamp" : { > "$date" : "2009-02-23T08:00:00.000Z" > }, > "time" : { > "$time" : "19:20:30.450Z" > }, > "interval" : { > "$interval" : "PT26.400S" > }, > "integer" : { > "$numberLong" : 4 > }, > "inner" : { > "bin" : { > "$binary" : "ZHJpbGw=" > }, > "drill_date" : { > "$dateDay" : "1997-07-15]" > }, > "drill_...> > {noformat} > Test queries are like this: > {noformat} > ALTER SESSION SET `store.format` = 'json' > ALTER SESSION SET `store.json.extended_types` = true > create table dfs_test.tmp.`TestExtendedTypes/newjson` as select * from > dfs.`${WORKING_PATH}/src/test/resources/vector/complex/extended.json` > {noformat} > It seems that Drill parses '1997-07-16' as a UTC date but writes it as a > local date. If the system time zone is ahead of UTC, it will be changed to > '1997-07-15'. I understand this is the current limitation, but the test code > or configuration should be aware of it. > https://drill.apache.org/docs/data-type-conversion/#time-zone-limitation -- This message was sent by Atlassian JIRA (v7.6.3#76005)