impala-reviews mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Shant Hovsepian (Code Review)" <>
Subject [Impala-ASF-CR] IMPALA-8954: Uncorrelated scalar subqueries in the select list
Date Sat, 04 Jul 2020 19:33:29 GMT
Shant Hovsepian has posted comments on this change. (

Change subject: IMPALA-8954: Uncorrelated scalar subqueries in the select list

Patch Set 8:


Addressed some comments.
File fe/src/main/java/org/apache/impala/analysis/
PS3, Line 1113: 
> nit: implemented
PS3, Line 1117:      *
> Is this comment applicable for this patch ? Looks like this patch is suppor
PS3, Line 1135:      *
> nit: spelling 'gaurantee'
PS3, Line 1230:           // rewrite to a LOJ.
> If the outer query has 2 tables joined in the FROM clause, then we add this
File fe/src/main/java/org/apache/impala/analysis/
PS5, Line 1114: implemeted
> nit: implemented
PS5, Line 1126: flatten
> nit: flattened
PS5, Line 1136: gaurantee
> nit: guarantee
File testdata/workloads/functional-planner/queries/PlannerTest/tpcds-all.test:
> On a related note, we probably *should* be doing a broadcast when the right
File testdata/workloads/functional-query/queries/QueryTest/subquery.test:
PS3, Line 1044: select id, 1+(select min(id) from functional.alltypessmall)
> Would be useful to also add the Explain plan for some of these tests either
PS3, Line 1086: 
> Not sure what this means - without grouping?
Meant that the parent query had aggregation, and the outer and inner aggregations weren't
interfering. This is a good case for subquery coalescing / merging down the line.
File testdata/workloads/tpcds/queries/tpcds-decimal_v2-q9.test:
PS3, Line 3: select case when (select count(*)
> Cool that  this query is now supported. Can we also add the plan for this u

To view, visit
To unsubscribe, visit

Gerrit-Project: Impala-ASF
Gerrit-Branch: master
Gerrit-MessageType: comment
Gerrit-Change-Id: Ibcf55d26889aa01d69bb85f18c9241dda095fb66
Gerrit-Change-Number: 16007
Gerrit-PatchSet: 8
Gerrit-Owner: Shant Hovsepian <>
Gerrit-Reviewer: Aman Sinha <>
Gerrit-Reviewer: Fang-Yu Rao <>
Gerrit-Reviewer: Impala Public Jenkins <>
Gerrit-Reviewer: Shant Hovsepian <>
Gerrit-Reviewer: Tim Armstrong <>
Gerrit-Comment-Date: Sat, 04 Jul 2020 19:33:29 +0000
Gerrit-HasComments: Yes

  • Unnamed multipart/alternative (inline, 8-Bit, 0 bytes)
View raw message