Paul Rogers created IMPALA-7955:
-----------------------------------
Summary: Confusing, nonsensical predicates in DESCRIBE output
Key: IMPALA-7955
URL: https://issues.apache.org/jira/browse/IMPALA-7955
Project: IMPALA
Issue Type: Bug
Components: Frontend
Affects Versions: Impala 3.1.0
Reporter: Paul Rogers
Consider {{PlannerTest.testTpcds()}} with the TPCDS-Q47 query. Peruse the plan.
Notice the following:
{noformat}
33:HASH JOIN [INNER JOIN]
| hash predicates: rank() + 1 = rank(), s_store_name = s_store_name,
i_category = i_category, s_company_name = s_company_name, i_brand = i_brand
{noformat}
What does {{rank() + 1 = rank()}} mean? Is it always false? What about
{{s_store_name = s_store_name}}, is that always true?
Probably this means {{tx.s_store_name = ty.s_store_name}} for some tables
{{tx}} and {{ty}}. Expected the predicate to make that clear so I don't have to
guess. Especially for that {{rank() + 1 = rank()}} expression, which table's
{{rank()}} are we comparing to which other table's {{rank() + 1}}?
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
