[
https://issues.apache.org/jira/browse/HIVE-7646?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Eugene Koifman updated HIVE-7646:
---------------------------------
Attachment: HIVE-7646.2.patch
HIVE-7646.2.patch - make sure 'values' is still a valid identifier, even though
it's a keyword (following previous practice to maintain backwards compat). Fix
multirow values clause grammar wrt parenthesis.
> Modify parser to support new grammar for Insert,Update,Delete
> -------------------------------------------------------------
>
> Key: HIVE-7646
> URL: https://issues.apache.org/jira/browse/HIVE-7646
> Project: Hive
> Issue Type: Sub-task
> Components: Query Processor
> Affects Versions: 0.13.1
> Reporter: Eugene Koifman
> Assignee: Eugene Koifman
> Attachments: HIVE-7646.1.patch, HIVE-7646.2.patch, HIVE-7646.patch
>
>
> need parser to recognize constructs such as :
> {code:sql}
> INSERT INTO Cust (Customer_Number, Balance, Address)
> VALUES (101, 50.00, '123 Main Street'), (102, 75.00, '123 Pine Ave');
> {code}
> {code:sql}
> DELETE FROM Cust WHERE Balance > 5.0
> {code}
> {code:sql}
> UPDATE Cust
> SET column1=value1,column2=value2,...
> WHERE some_column=some_value
> {code}
> also useful
> {code:sql}
> select a,b from values((1,2),(3,4)) as FOO(a,b)
> {code}
> This makes writing tests easier.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
