[ https://issues.apache.org/jira/browse/HIVE-9792?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jason Dere updated HIVE-9792: ----------------------------- Attachment: HIVE-9792.6.patch As [~pxiong] has pointed out to me (offline), if INTERVAL is meant to be a reserved word it should not be added to sql11ReservedKeywordsUsedAsIdentifier - that is only meant for reserved words that we want to also allow as identifiers. Uploading patch v6. > Support interval type in expressions/predicates > ------------------------------------------------ > > Key: HIVE-9792 > URL: https://issues.apache.org/jira/browse/HIVE-9792 > Project: Hive > Issue Type: Sub-task > Components: Types > Reporter: Jason Dere > Assignee: Jason Dere > Attachments: HIVE-9792.1.patch, HIVE-9792.2.patch, HIVE-9792.3.patch, > HIVE-9792.4.patch, HIVE-9792.5.patch, HIVE-9792.6.patch > > > Provide partial support for the interval year-month/interval day-time types > in Hive. Intervals will be usable in expressions/predicates/joins: > {noformat} > select birthdate + interval '30-0' year to month as thirtieth_birthday > from table > where (current_timestamp - ts1 < interval '3 0:0:0' day to second) > {noformat} > This stops short of adding making the interval types usable as a storable > column type. -- This message was sent by Atlassian JIRA (v6.3.4#6332)