You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Laljo John Pullokkaran (JIRA)" <ji...@apache.org> on 2015/05/13 00:54:04 UTC

[jira] [Created] (HIVE-10695) Hive Query Produces Wrong Result: PPD

Laljo John Pullokkaran created HIVE-10695:
---------------------------------------------

             Summary: Hive Query Produces Wrong Result: PPD
                 Key: HIVE-10695
                 URL: https://issues.apache.org/jira/browse/HIVE-10695
             Project: Hive
          Issue Type: Bug
            Reporter: Laljo John Pullokkaran
            Assignee: Laljo John Pullokkaran
            Priority: Critical
             Fix For: 0.14.1


Following query produces wrong result:
select * from t1 s left outer join  (select key, value from t1) f on s.key=f.key and s.value=f.value   left outer join  (select key, value from t1) c on s.key=c.key where f.key is null;

This is due to PPD gets confused between qualified col name & non qualified.
In many places in code column info doesn't include table alias which leads to PPD problem.

This is fixed in trunk as part of HIVE-9327 https://issues.apache.org/jira/browse/HIVE-9327



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)