[
https://issues.apache.org/jira/browse/TAJO-1741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14702557#comment-14702557
]
Tajo QA commented on TAJO-1741:
-------------------------------
{color:red}*-1 overall.*{color} Here are the results of testing the latest
attachment
http://issues.apache.org/jira/secure/attachment/12751192/TAJO-1741.patch
against master revision release-0.9.0-rc0-416-g6f28fa5.
{color:green}+1 @author.{color} The patch does not contain any @author
tags.
{color:red}-1 tests included.{color} The patch doesn't appear to include
any new or modified tests.
Please justify why no new tests are needed for this
patch.
Also please list what manual steps were performed to
verify this patch.
{color:green}+1 javac.{color} The applied patch does not increase the
total number of javac compiler warnings.
{color:green}+1 javadoc.{color} The applied patch does not increase the
total number of javadoc warnings.
{color:green}+1 checkstyle.{color} The patch generated 0 code style errors.
{color:red}-1 findbugs.{color} The patch appears to introduce 3 new
Findbugs (version 2.0.3) warnings.
{color:green}+1 release audit.{color} The applied patch does not increase
the total number of release audit warnings.
{color:green}+1 core tests.{color} The patch passed unit tests in
tajo-storage/tajo-storage-hdfs.
Test results:
https://builds.apache.org/job/PreCommit-TAJO-Build/827//testReport/
Findbugs warnings:
https://builds.apache.org/job/PreCommit-TAJO-Build/827//artifact/incubator-tajo/patchprocess/newPatchFindbugsWarningstajo-storage-hdfs.html
Console output: https://builds.apache.org/job/PreCommit-TAJO-Build/827//console
This message is automatically generated.
> 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)
