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

Error in left outer join if the right side is a subquery with complex types

    XMLWordPrintableJSON

Details

    • ghx-label-13

    Description

      repro in Impala dev env:

      use functional_parquet;
      
      select a.id, a.int_1d, b.int_1d from (select id, unnest(int_1d) as int_1d from array_tbl) a left outer join (select id, int_1d from array_tbl) b on a.id = b.id;
      
      ERROR: IllegalStateException: Should not evaluate on complex type: SlotRef{label=int_1d, path=int_1d, type=ARRAY<INT>, id=6}
      

      The error comes from here:
      https://github.com/apache/impala/blob/37f44a58f3f9d515e9c74455037c654542ac6566/fe/src/main/java/org/apache/impala/analysis/TupleIsNullPredicate.java#L165

      Attachments

        Activity

          People

            csringhofer Csaba Ringhofer
            csringhofer Csaba Ringhofer
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: