Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-26872

INSERT UNION with LATERAL VIEW does not produce data

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Duplicate
    • 2.3.9, 3.1.2
    • None
    • Tez
    • None

    Description

      // code placeholder
      
      DROP TABLE union_test;
      CREATE TABLE union_test(id INT) PARTITIONED BY (`dt` STRING);
      
      DROP TABLE json_src;
      CREATE TABLE json_src(message STRING) PARTITIONED BY (`dt` STRING);
      
      INSERT OVERWRITE TABLE json_src PARTITION(dt='1219') VALUES('{"id":1}');
      INSERT OVERWRITE TABLE json_src PARTITION(dt='1220') VALUES('{"id":2}');
      
      
      INSERT OVERWRITE TABLE union_test PARTITION (dt='1221')
      SELECT id FROM json_src LATERAL  VIEW json_tuple(message, 'id') b AS id WHERE dt='1219'
      UNION ALL
      SELECT id FROM json_src LATERAL  VIEW json_tuple(message, 'id') b AS id WHERE dt='1220'
      ; 

      The script above does not produce data in partition dt='1221'

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              fangbo_worker FangBO
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: