Details

    • 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
    • Labels:
      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.patch
          8 kB
          Eugene Koifman
        2. HIVE-7646.1.patch
          16 kB
          Eugene Koifman
        3. HIVE-7646.2.patch
          51 kB
          Eugene Koifman
        4. HIVE-7646.3.patch
          22 kB
          Eugene Koifman

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: