Fu Lili created IMPALA-8361:
-------------------------------
Summary: bound predicates optimization doesn't work for InlineView
Key: IMPALA-8361
URL: https://issues.apache.org/jira/browse/IMPALA-8361
Project: IMPALA
Issue Type: Improvement
Components: Frontend
Affects Versions: Impala 2.12.0
Reporter: Fu Lili
Attachments: image-2019-03-26-23-11-49-483.png,
image-2019-03-26-23-12-05-276.png
Tables for test:
{code:java}
CREATE TABLE test_a (
id STRING,
val STRING
);
CREATE TABLE test_b (
id STRING,
val STRING
);
{code}
Bound predicates optimization (implement in Analyzer::getBoundPredicates) works
for this sql:
{code:java}
EXPLAIN
SELECT count(*) FROM test_a a
LEFT JOIN
(SELECT * FROM test_b) b
ON a.id=b.id
WHERE upper(b.val)='123';{code}
!image-2019-03-26-23-11-49-483.png!
But does't work for this one:
{code:java}
EXPLAIN
SELECT count(*) FROM test_a a
LEFT JOIN
(SELECT *, upper(val) AS upper_val FROM test_b) b
ON a.id=b.id
WHERE upper_val='123';
{code}
!image-2019-03-26-23-12-05-276.png!
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
