Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-5317 Implement insert, update, and delete in Hive with full ACID support
  3. HIVE-7646

Modify parser to support new grammar for Insert,Update,Delete

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 0.13.1
    • 0.14.0
    • Query Processor
    • None

    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

      Attachments

        1. HIVE-7646.1.patch
          16 kB
          Eugene Koifman
        2. HIVE-7646.2.patch
          51 kB
          Eugene Koifman
        3. HIVE-7646.3.patch
          22 kB
          Eugene Koifman
        4. HIVE-7646.patch
          8 kB
          Eugene Koifman

        Issue Links

          Activity

            People

              ekoifman Eugene Koifman
              ekoifman Eugene Koifman
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: