Navis created HIVE-4295:
---------------------------

             Summary: Lateral view makes invalid result if CP is disabled
                 Key: HIVE-4295
                 URL: https://issues.apache.org/jira/browse/HIVE-4295
             Project: Hive
          Issue Type: Bug
          Components: Query Processor
            Reporter: Navis
            Assignee: Navis
            Priority: Minor


For example,
{noformat}
>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
{noformat}

After CP disabled,

{noformat}
>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
{noformat}


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Reply via email to