[
https://issues.apache.org/jira/browse/TAJO-1741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14704448#comment-14704448
]
Hudson commented on TAJO-1741:
------------------------------
SUCCESS: Integrated in Tajo-master-build #809 (See
[https://builds.apache.org/job/Tajo-master-build/809/])
TAJO-1741: Two tables having same time zone display different timestamps.
(hyunsik: rev 2d2f192d78249d8acc812a1a3d08f5caceee9208)
*
tajo-storage/tajo-storage-hdfs/src/main/java/org/apache/tajo/storage/text/TextFieldSerializerDeserializer.java
* CHANGES
*
tajo-core-tests/src/test/resources/queries/TestSelectQuery/datetime_table_timezoned_ddl2.sql
*
tajo-core-tests/src/test/java/org/apache/tajo/engine/query/TestSelectQuery.java
*
tajo-core-tests/src/test/resources/queries/TestSelectQuery/testLoadIntoTimezonedTable.sql
* tajo-common/src/main/java/org/apache/tajo/datum/TimestampDatum.java
> Two tables having same time zone display different timestamps
> -------------------------------------------------------------
>
> Key: TAJO-1741
> URL: https://issues.apache.org/jira/browse/TAJO-1741
> Project: Tajo
> Issue Type: Bug
> Components: Storage
> Affects Versions: 0.10.1
> Reporter: Jongyoung Park
> Assignee: Jongyoung Park
> Labels: timezone
> Fix For: 0.11.0, 0.12.0
>
> Attachments: TAJO-1741.patch
>
>
> Create two tables with same scheme. Note 'GMT+9'.
> (Table names are *timezone* and *timezone_text*)
> {code:sql}
> CREATE EXTERNAL TABLE timezone
> (t_timestamp TIMESTAMP,
> t_date DATE)
> USING TEXT WITH ('timezone'='GMT+9')
> LOCATION 'hdfs://localhost:8020/timezone';
> {code}
> Timezone table already has data.
> {noformat}
> 1980-4-1 01:50:30.010|1980-04-01
> 80/4/1 1:50:30 AM|80/4/1
> 1980 April 1 1:50:30|1980-04-01
> {noformat}
> Then, copy data to timezone_text.
> {code:sql}
> INSERT INTO timezone_text SELECT * FROM timezone;
> {code}
> Check timezone_text with some editor. It looks ok.
> {noformat}
> 1980-04-01 01:50:30.01+09|1980-04-01
> 1980-04-01 01:50:30+09|1980-04-01
> 1980-04-01 01:50:30+09|1980-04-01
> {noformat}
> But in tsql, two tables show different time values.
> {noformat:title=select * from timezone}
> t_timestamp, t_date
> -------------------------------
> 1980-04-01 01:50:30.01, 1980-04-01
> 1980-04-01 01:50:30, 1980-04-01
> 1980-04-01 01:50:30, 1980-04-01
> {noformat}
> {noformat:title=select * from timezone_text}
> t_timestamp, t_date
> -------------------------------
> 1980-03-31 16:50:30.01, 1980-04-01
> 1980-03-31 16:50:30, 1980-04-01
> 1980-03-31 16:50:30, 1980-04-01
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
