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

Hive Query Produces Wrong Result: PPD

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: 0.14.1
    • Component/s: None
    • Labels:
      None

      Description

      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 getting 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

        Attachments

        1. HIVE-10695.patch
          1 kB
          Laljo John Pullokkaran

          Activity

            People

            • Assignee:
              jpullokkaran Laljo John Pullokkaran
              Reporter:
              jpullokkaran Laljo John Pullokkaran
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: