[
https://issues.apache.org/jira/browse/HIVE-7646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14103356#comment-14103356
]
Eugene Koifman commented on HIVE-7646:
--------------------------------------
TestCliDriver.testCliDriver_auto_sortmerge_join_8 failed with
< FAILED: Execution Error, return code 3 from
org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask
< ATTEMPT: Execute BackupTask: org.apache.hadoop.hive.ql.exec.mr.MapRedTask
which can't be caused by parser changes, I don't think.
In any case it passes locally with the same patch so it's not related to the
patch.
> 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.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
--
This message was sent by Atlassian JIRA
(v6.2#6252)
