[HIVE-21095] 'Show create table' should not display a time zone for timestamp with local time zone

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 4.0.0-alpha-1
• Assignee: Karen Coppage
• Reporter: Karen Coppage
• Created: 07/Jan/19 14:53
• Updated: 27/Feb/24 22:24
• Resolved: 16/Jan/19 11:29

Description

SHOW CREATE TABLE shows the time zone that the table was created in (if it contains a TIMESTAMPTZ column). This is also misleading, since it has nothing to do with the actual data or server or user time zone.
e.g.

hive> set time zone America/Los_Angeles;
hive> create table text_local (ts timestamp with local time zone) stored as textfile;
hive> show create table text_local;
CREATE TABLE `text_local`(
  `ts` timestamp with local time zone('America/Los_Angeles'))

should be:

hive> show create table text_local;
CREATE TABLE `text_local`(
  `ts` timestamp with local time zone)

This was discussed in the community doc Consistent timestamp types in Hadoop SQL engines

Issue Links

• links to: Review Board Link