Uploaded image for project: 'Flink'
  1. Flink
  2. FLINK-21026

Align column list specification with Hive in INSERT statement

    XMLWordPrintableJSON

    Details

      Description

      HIVE-9481 allows column list specification in INSERT statement. The syntax is:

      INSERT INTO TABLE table_name 
      [PARTITION (partcol1[=val1], partcol2[=val2] ...)] 
      [(column list)] 
      select_statement FROM from_statement
      

      In the MeanWhile, flink introduces PARTITION syntax that the PARTITION clause appears after the COLUMN LIST clause. It looks weird and luckily we don't support COLUMN LIST clause now.  I think it'a good chance to align this with Hive now.

       
       
       

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                docete Zhenghua Gao
                Reporter:
                docete Zhenghua Gao
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: