[IMPALA-2946] Query generator flattening algorithm bug (correlated array references in Join clause are not rewritten as subqueries)

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 2.5.0
• Component/s: Infrastructure
• Labels: query_generator_development
• Assignee: Taras Bobrovytsky
• Reporter: Taras Bobrovytsky
• Created: 04/Feb/16 02:48
• Updated: 08/Feb/16 23:41
• Resolved: 08/Feb/16 23:41

Description

For the following nested query, the flattened equivalent query should have a subquery for both a4 and a5. However a5 is not replaced with a subquery. The query generator incorrectly reports incorrect results for these kind of nested queries.

SELECT
 ...
FROM 
  table_1.field_19.value a1
WHERE
  123 IN (
    SELECT
      a5.item
    FROM
      a1.item.field_48.value.item a4
      INNER JOIN a1.item.field_22.item.field_36.field_38 a5
   )