Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-1371

Predicate applied incorrectly when FULL OUTER JOIN is present

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Critical
    • Resolution: Fixed
    • Impala 2.0
    • Impala 2.1
    • None

    Description

      The following query should return 0 rows, however 8 rows are returned.

      SELECT 
       *
      FROM
       alltypestiny t1
       INNER JOIN chars_tiny t2 ON t2.vc = t1.string_col
       FULL OUTER JOIN alltypestiny t3 ON t3.string_col = TRIM(t2.cs)
      WHERE
       t1.date_string_col = t2.vc
      

      Attachments

        Issue Links

          Activity

            People

              dtsirogiannis Dimitris Tsirogiannis
              tarasbob Taras Bobrovytsky
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: