[TAJO-1741] Two tables having same time zone display different timestamps

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.10.1
• Fix Version/s: 0.11.0, 0.12.0
• Component/s: Storage
• Labels: timezone
• Assignee: Jongyoung Park
• Reporter: Jongyoung Park
• Created: 04/Aug/15 07:58
• Updated: 20/Aug/15 07:48
• Resolved: 20/Aug/15 06:12

Description

Create two tables with same scheme. Note 'GMT+9'.
(Table names are timezone and timezone_text)

CREATE EXTERNAL TABLE timezone 
(t_timestamp TIMESTAMP, 
t_date DATE) 
USING TEXT WITH ('timezone'='GMT+9') 
LOCATION 'hdfs://localhost:8020/timezone';

Timezone table already has data.

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

Then, copy data to timezone_text.

INSERT INTO timezone_text SELECT * FROM timezone;

Check timezone_text with some editor. It looks ok.

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

But in tsql, two tables show different time values.

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

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

Issue Links

• blocks: TAJO-1465 Add ORCFileAppender to write into ORCFile table