[jira] [Updated] (IMPALA-2581) Push down LIMIT past DISTINCT
[ https://issues.apache.org/jira/browse/IMPALA-2581?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liuyao updated IMPALA-2581: --- Labels: backend frontend performance (was: performance) > Push down LIMIT past DISTINCT > -- > > Key: IMPALA-2581 > URL: https://issues.apache.org/jira/browse/IMPALA-2581 > Project: IMPALA > Issue Type: Improvement > Components: Frontend >Affects Versions: Impala 2.5.0 >Reporter: Jim Apple >Assignee: liuyao >Priority: Minor > Labels: backend, frontend, performance > Fix For: Impala 4.1.0 > > > In a table t with a column x with no null values, "SELECT DISTINCT x FROM t > LIMIT 1" should be roughly instant. Instead, it finds *all* the distinct > values, then returns one of them. -- 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
[jira] [Updated] (IMPALA-2581) Push down LIMIT past DISTINCT
[ https://issues.apache.org/jira/browse/IMPALA-2581?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] liuyao updated IMPALA-2581: --- Fix Version/s: Impala 4.1.0 > Push down LIMIT past DISTINCT > -- > > Key: IMPALA-2581 > URL: https://issues.apache.org/jira/browse/IMPALA-2581 > Project: IMPALA > Issue Type: Improvement > Components: Frontend >Affects Versions: Impala 2.5.0 >Reporter: Jim Apple >Assignee: liuyao >Priority: Minor > Labels: performance > Fix For: Impala 4.1.0 > > > In a table t with a column x with no null values, "SELECT DISTINCT x FROM t > LIMIT 1" should be roughly instant. Instead, it finds *all* the distinct > values, then returns one of them. -- 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
[jira] [Updated] (IMPALA-2581) Push down LIMIT past DISTINCT
[ https://issues.apache.org/jira/browse/IMPALA-2581?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jim Apple updated IMPALA-2581: -- Summary: Push down LIMIT past DISTINCT (was: Push down "LIMIT" when possible) > Push down LIMIT past DISTINCT > -- > > Key: IMPALA-2581 > URL: https://issues.apache.org/jira/browse/IMPALA-2581 > Project: IMPALA > Issue Type: Improvement > Components: Frontend >Affects Versions: Impala 2.5.0 >Reporter: Jim Apple >Priority: Minor > Labels: performance > > In a table t with a column x with no null values, "SELECT DISTINCT x FROM t > LIMIT 1" should be roughly instant. Instead, it finds *all* the distinct > values, then returns one of them. -- This message was sent by Atlassian JIRA (v7.6.3#76005) - To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org