[
https://issues.apache.org/jira/browse/HIVE-7646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14105874#comment-14105874
]
Lefty Leverenz commented on HIVE-7646:
--------------------------------------
Doc note: This doesn't need a TODOC14 label because HIVE-7802 covers the
documentation.
> 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
> Fix For: 0.14.0
>
> Attachments: HIVE-7646.1.patch, HIVE-7646.2.patch, HIVE-7646.3.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.
> Some references:
> http://dev.mysql.com/doc/refman/5.6/en/insert.html
> http://msdn.microsoft.com/en-us/library/dd776382.aspx
> http://www.postgresql.org/docs/9.1/static/sql-values.html
--
This message was sent by Atlassian JIRA
(v6.2#6252)
