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

Hari Sankar Sivarama Subramaniyan commented on HIVE-13615:
----------------------------------------------------------

I think this is a much generic issue which got exposed by the recent parser 
changes in HIVE-13290. In general, if we use any of the nonreserved key words 
in IdentifiersParser.g as an alias in the statements like below, we will run 
into an error:

{code}
FROM src rely 
INSERT OVERWRITE TABLE ambiguous SELECT rely.key, rely.value WHERE rely.value < 
'val_100';

FROM src key
INSERT OVERWRITE TABLE ambiguous SELECT key.key, key.value WHERE key.value < 
'val_100';

 FROM src uri
 INSERT OVERWRITE TABLE ambiguous SELECT uri.key, uri.value WHERE uri.value < 
'val_100';
{code}

> nomore_ambiguous_table_col.q is failing on master
> -------------------------------------------------
>
>                 Key: HIVE-13615
>                 URL: https://issues.apache.org/jira/browse/HIVE-13615
>             Project: Hive
>          Issue Type: Test
>          Components: Parser
>    Affects Versions: 2.1.0
>            Reporter: Ashutosh Chauhan
>
> Fails with:
> FAILED: ParseException line 3:9 cannot recognize input near 'src' 'key' 
> 'INSERT' in from source 0



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

Reply via email to