[ https://issues.apache.org/jira/browse/IMPALA-10634?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Zoltán Borók-Nagy resolved IMPALA-10634. ---------------------------------------- Resolution: Duplicate > Removes outer join if it only has DISTINCT on streamed side > ----------------------------------------------------------- > > Key: IMPALA-10634 > URL: https://issues.apache.org/jira/browse/IMPALA-10634 > Project: IMPALA > Issue Type: Improvement > Components: Backend > Reporter: Yuming Wang > Priority: Major > > Removes outer join if it only has DISTINCT on streamed side: > {code:sql} > CREATE TABLE t1(a int, b int); > CREATE TABLE t2(a int, b int); > SELECT DISTINCT t1.b FROM t1 LEFT JOIN t2 ON t1.a = t2.a; > {code} > We can rewrite {{SELECT DISTINCT b FROM t1 LEFT JOIN t2 ON t1.a = t2.a}} to > {{SELECT DISTINCT t1.b FROM t1}}. -- 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