[TAJO-1186] Table should have timezone as an table property

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.10.0
• Labels: timezone
• Assignee: Hyunsik Choi
• Reporter: Hyunsik Choi
• Created: 17/Nov/14 10:39
• Updated: 08/Dec/14 07:50
• Resolved: 08/Dec/14 07:50

Description

Currently, Tajo allows only a single global timezone. But, different tables can have different timezones, especially in external tables. Current design does not support this case. So, I propose the timezone table property. We will set the property as follows:

CREATE EXTERNAL TABLE T1 (col1 TEXT, col2 TIMESTAMP) WITH ('timezone' = 'Asia/Seoul');

Issue Links

• relates to: TAJO-1234 Rearrange timezone in date/time types