[TAJO-1234] Rearrange timezone in date/time types

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Fix Version/s: 0.10.0
• Component/s: Data Type, Planner/Optimizer
• Assignee: Hyunsik Choi
• Reporter: Hyunsik Choi
• Created: 05/Dec/14 09:04
• Updated: 25/Dec/14 20:33
• Resolved: 10/Dec/14 17:15

Description

Currently, the master branch causes unit test failures. It's because that some inconsistent timezone usages. The main purpose of this issue is to cleanup and rearrange timezone usages.

I discussed this issue with jungjw at

• http://markmail.org/thread/qhsizgp2pnd6swjq
• http://markmail.org/message/3nqecl34l2ayxg2x

I'll fix some parts as I mentioned in above mailing list threads.

In sum,

• Tajo will have only four points which consider timezone:
  • query statement
  • Input table
  • text printout in TajoCli
  • Casting from text to either time or timestamp
• All other parts have to deal with TIME and TIMESTAMP values as UTC value

Issue Links

• contains: TAJO-1003 wrong converting to_timestamp(text, text)
• contains: TAJO-1192 testTimestampConstructor incorrectly compares a local time with a UTC time
• is duplicated by: TAJO-1185 Default timezone should be UTC+0 instead of depending on JVM
• is related to: TAJO-1191 Change DateDatum timezone to UTC
• is related to: TAJO-1186 Table should have timezone as an table property
• is related to: TAJO-1187 TajoCli should print time/timestamp values with timezone
• relates to: TAJO-1241 Change default client and table time zone behavior