[HIVE-7646] Modify parser to support new grammar for Insert,Update,Delete

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.13.1
• Fix Version/s: 0.14.0
• Component/s: Query Processor
• Assignee: Eugene Koifman
• Reporter: Eugene Koifman
• Created: 07/Aug/14 18:27
• Updated: 28/Jan/15 02:50
• Resolved: 21/Aug/14 17:17

Description

need parser to recognize constructs such as :

INSERT INTO Cust (Customer_Number, Balance, Address)
VALUES (101, 50.00, '123 Main Street'), (102, 75.00, '123 Pine Ave');

DELETE FROM Cust WHERE Balance > 5.0

UPDATE Cust
SET column1=value1,column2=value2,...
WHERE some_column=some_value

also useful

select a,b from values((1,2),(3,4)) as FOO(a,b)

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

Issue Links

• is depended upon by: HIVE-7788 Generate plans for insert, update, and delete
• is depended upon by: HIVE-7790 Update privileges to check for update and delete
• is related to: HIVE-7802 Update language manual for insert, update, and delete
• is related to: HIVE-7877 Inserting negative values causes a parse exception
• is related to: HIVE-8152 Update with expression in set fails
• is related to: HIVE-9481 allow column list specification in INSERT statement