[ 
https://issues.apache.org/jira/browse/HIVE-12707?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15070298#comment-15070298
 ] 

Pengcheng Xiong commented on HIVE-12707:
----------------------------------------

[~rajsaha], here is the story with timeline: Hive 0.14 was released based on 
commits on Wed Nov 12 20:35:15 2014 (Since INTERVAL was not introduced yet, you 
are free to use it as identifier). The flag 
"hive.support.sql11.reserved.keywords" was introduced on Tue Mar 10 22:00:41 
2015. (Since INTERVAL was not introduced yet, you are free to use it as 
identifier whether you set the flag or not). "INTERVAL" was introduced on Thu 
Mar 19 19:05:28 2015 (see HIVE-9792 : Support interval type in 
expressions/predicates ), and they reserved it.... Sounds like the people who 
checked in HIVE-9792 did not consider the backward compatibility of "interval". 
So, if it really makes trouble for you, i can add it back to the list. But as 
you know, we are planning to deprecate the flag in the next release or two.

> ParseException for column name  'INTERVAL', even set 
> hive.support.sql11.reserved.keywords = false
> -------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-12707
>                 URL: https://issues.apache.org/jira/browse/HIVE-12707
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 1.2.1
>            Reporter: Rajit Saha
>            Assignee: Pengcheng Xiong
>             Fix For: 1.2.1
>
>
> Any column name INTERVAL is causing ParseException , even we set 
> hive.support.sql11.reserved.keywords = false



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to