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

Lateral view makes invalid result if CP is disabled

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • None
    • 0.12.0
    • Query Processor
    • 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

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

              Dates

                Created:
                Updated:
                Resolved: