[
https://issues.apache.org/jira/browse/HIVE-7646?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Eugene Koifman updated HIVE-7646:
---------------------------------
Description:
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
was:
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.
> 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.
> 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)
