[ https://issues.apache.org/jira/browse/IMPALA-8361?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
hexianqing updated IMPALA-8361: ------------------------------- Fix Version/s: Impala 3.4.0 > 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 3.0, Impala 2.12.0, Impala 3.1.0, Impala 3.2.0, > Impala 3.3.0 > Reporter: Fu Lili > Assignee: hexianqing > Priority: Major > Fix For: Impala 3.4.0 > > 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 (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org