[
https://issues.apache.org/jira/browse/TAJO-1741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14702505#comment-14702505
]
ASF GitHub Bot commented on TAJO-1741:
--------------------------------------
Github user hyunsik commented on the pull request:
https://github.com/apache/tajo/pull/699#issuecomment-132450837
+1
The change looks straightforward. I'll change your comments into a java doc
format before committing.
> 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
>
> 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)
