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

Lateral view makes invalid result if CP is disabled

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.12.0
    • Component/s: Query Processor
    • Labels:
      None

      Description

      For example,

      >SELECT src.key, myKey, myVal FROM src lateral view explode(map(1,'one',2,'two',3,'three')) x AS myKey,myVal LIMIT 3;
      
      238	1	one
      238	2	two
      238	3	three
      

      After CP disabled,

      >SELECT src.key, myKey, myVal FROM src lateral view explode(map(1,'one',2,'two',3,'three')) x AS myKey,myVal LIMIT 3;
      
      238	0	hdfs://localhost:9000/user/hive/warehouse/src/kv1.txt
      238	0	hdfs://localhost:9000/user/hive/warehouse/src/kv1.txt
      238	0	hdfs://localhost:9000/user/hive/warehouse/src/kv1.txt
      

        Attachments

        1. HIVE-4295.D9963.1.patch
          42 kB
          Phabricator
        2. HIVE-4295.2.patch.txt
          47 kB
          Navis Ryu

          Issue Links

            Activity

              People

              • Assignee:
                navis Navis Ryu
                Reporter:
                navis Navis Ryu
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: