[jira] [Created] (IMPALA-8361) bound predicates optimization doesn't work for InlineView

["Fu Lili (JIRA)" <ji...@apache.org>]

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)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org