[jira] [Created] (IMPALA-8035) Planner estimate incorrect for non-equi-join case

2018-12-31 Thread Paul Rogers (JIRA)
Paul Rogers created IMPALA-8035: --- Summary: Planner estimate incorrect for non-equi-join case Key: IMPALA-8035 URL: https://issues.apache.org/jira/browse/IMPALA-8035 Project: IMPALA Issue Type:

[jira] [Created] (IMPALA-8034) PlannerTest tests are not realistic

2018-12-31 Thread Paul Rogers (JIRA)
Paul Rogers created IMPALA-8034: --- Summary: PlannerTest tests are not realistic Key: IMPALA-8034 URL: https://issues.apache.org/jira/browse/IMPALA-8034 Project: IMPALA Issue Type: Bug

[jira] [Created] (IMPALA-8030) Remove duplicate in-clause values for selectivity calcs

2018-12-31 Thread Paul Rogers (JIRA)
Paul Rogers created IMPALA-8030: --- Summary: Remove duplicate in-clause values for selectivity calcs Key: IMPALA-8030 URL: https://issues.apache.org/jira/browse/IMPALA-8030 Project: IMPALA Issue

[jira] [Created] (IMPALA-8038) Incorrect estimation of selectivity of OR expression

2018-12-31 Thread Paul Rogers (JIRA)
Paul Rogers created IMPALA-8038: --- Summary: Incorrect estimation of selectivity of OR expression Key: IMPALA-8038 URL: https://issues.apache.org/jira/browse/IMPALA-8038 Project: IMPALA Issue

[jira] [Created] (IMPALA-8032) Gather minimum, maximum values to better estimate inequality selectivity

2018-12-31 Thread Paul Rogers (JIRA)
Paul Rogers created IMPALA-8032: --- Summary: Gather minimum, maximum values to better estimate inequality selectivity Key: IMPALA-8032 URL: https://issues.apache.org/jira/browse/IMPALA-8032 Project:

[jira] [Created] (IMPALA-8039) Incorrect selectivity estimate for not-equals predicate

2018-12-31 Thread Paul Rogers (JIRA)
Paul Rogers created IMPALA-8039: --- Summary: Incorrect selectivity estimate for not-equals predicate Key: IMPALA-8039 URL: https://issues.apache.org/jira/browse/IMPALA-8039 Project: IMPALA Issue

[jira] [Created] (IMPALA-8031) Remove redundant inequalities for selectivity calcs

2018-12-31 Thread Paul Rogers (JIRA)
Paul Rogers created IMPALA-8031: --- Summary: Remove redundant inequalities for selectivity calcs Key: IMPALA-8031 URL: https://issues.apache.org/jira/browse/IMPALA-8031 Project: IMPALA Issue

[jira] [Created] (IMPALA-8033) PlanNode getInputCardinality has two conflicting meanings

2018-12-31 Thread Paul Rogers (JIRA)
Paul Rogers created IMPALA-8033: --- Summary: PlanNode getInputCardinality has two conflicting meanings Key: IMPALA-8033 URL: https://issues.apache.org/jira/browse/IMPALA-8033 Project: IMPALA

[jira] [Created] (IMPALA-8040) Incorrect double-accounting for WHERE on join column

2018-12-31 Thread Paul Rogers (JIRA)
Paul Rogers created IMPALA-8040: --- Summary: Incorrect double-accounting for WHERE on join column Key: IMPALA-8040 URL: https://issues.apache.org/jira/browse/IMPALA-8040 Project: IMPALA Issue

[jira] [Created] (IMPALA-8036) Bad join cardinality estimation for missing stats

2018-12-31 Thread Paul Rogers (JIRA)
Paul Rogers created IMPALA-8036: --- Summary: Bad join cardinality estimation for missing stats Key: IMPALA-8036 URL: https://issues.apache.org/jira/browse/IMPALA-8036 Project: IMPALA Issue Type:

[jira] [Created] (IMPALA-8037) Planner makes poor estimations for non-equality predicates

2018-12-31 Thread Paul Rogers (JIRA)
Paul Rogers created IMPALA-8037: --- Summary: Planner makes poor estimations for non-equality predicates Key: IMPALA-8037 URL: https://issues.apache.org/jira/browse/IMPALA-8037 Project: IMPALA

[jira] [Updated] (IMPALA-8014) Incorrect M:1 (FK/PK) cardinality estimation

2018-12-31 Thread Paul Rogers (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-8014?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Paul Rogers updated IMPALA-8014: Description: The math is wrong when we estimate the cardinality of a join we've labeled as

[jira] [Created] (IMPALA-8035) Planner estimate incorrect for non-equi-join case

2018-12-31 Thread Paul Rogers (JIRA)
Paul Rogers created IMPALA-8035: --- Summary: Planner estimate incorrect for non-equi-join case Key: IMPALA-8035 URL: https://issues.apache.org/jira/browse/IMPALA-8035 Project: IMPALA Issue Type:

[jira] [Created] (IMPALA-8034) PlannerTest tests are not realistic

2018-12-31 Thread Paul Rogers (JIRA)
Paul Rogers created IMPALA-8034: --- Summary: PlannerTest tests are not realistic Key: IMPALA-8034 URL: https://issues.apache.org/jira/browse/IMPALA-8034 Project: IMPALA Issue Type: Bug

[jira] [Commented] (IMPALA-8014) Incorrect M:1 (FK/PK) cardinality estimation

2018-12-31 Thread Paul Rogers (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-8014?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16731478#comment-16731478 ] Paul Rogers commented on IMPALA-8014: - Example incorrect calculation: {code:sql} select

[jira] [Created] (IMPALA-8040) Incorrect double-accounting for WHERE on join column

2018-12-31 Thread Paul Rogers (JIRA)
Paul Rogers created IMPALA-8040: --- Summary: Incorrect double-accounting for WHERE on join column Key: IMPALA-8040 URL: https://issues.apache.org/jira/browse/IMPALA-8040 Project: IMPALA Issue

[jira] [Created] (IMPALA-8030) Remove duplicate in-clause values for selectivity calcs

2018-12-31 Thread Paul Rogers (JIRA)
Paul Rogers created IMPALA-8030: --- Summary: Remove duplicate in-clause values for selectivity calcs Key: IMPALA-8030 URL: https://issues.apache.org/jira/browse/IMPALA-8030 Project: IMPALA Issue

[jira] [Created] (IMPALA-8032) Gather minimum, maximum values to better estimate inequality selectivity

2018-12-31 Thread Paul Rogers (JIRA)
Paul Rogers created IMPALA-8032: --- Summary: Gather minimum, maximum values to better estimate inequality selectivity Key: IMPALA-8032 URL: https://issues.apache.org/jira/browse/IMPALA-8032 Project:

[jira] [Created] (IMPALA-8039) Incorrect selectivity estimate for not-equals predicate

2018-12-31 Thread Paul Rogers (JIRA)
Paul Rogers created IMPALA-8039: --- Summary: Incorrect selectivity estimate for not-equals predicate Key: IMPALA-8039 URL: https://issues.apache.org/jira/browse/IMPALA-8039 Project: IMPALA Issue

[jira] [Updated] (IMPALA-8031) Remove redundant inequalities for selectivity calcs

2018-12-31 Thread Paul Rogers (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-8031?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Paul Rogers updated IMPALA-8031: Description: IMPALA-8035 describes how Impala currently estimates inequality: lump all

[jira] [Updated] (IMPALA-8015) Incorrect cardinality calculation for the generic case

2018-12-31 Thread Paul Rogers (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-8015?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Paul Rogers updated IMPALA-8015: Description: IMPALA-8015 TL;DR: the expression used to calculate the cardinality for a M:N

[jira] [Created] (IMPALA-8038) Incorrect estimation of selectivity of OR expression

2018-12-31 Thread Paul Rogers (JIRA)
Paul Rogers created IMPALA-8038: --- Summary: Incorrect estimation of selectivity of OR expression Key: IMPALA-8038 URL: https://issues.apache.org/jira/browse/IMPALA-8038 Project: IMPALA Issue

[jira] [Updated] (IMPALA-8034) PlannerTest tests are not realistic

2018-12-31 Thread Paul Rogers (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-8034?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Paul Rogers updated IMPALA-8034: Issue Type: Improvement (was: Bug) > PlannerTest tests are not realistic >

[jira] [Updated] (IMPALA-8014) Incorrect M:1 (FK/PK) cardinality estimation

2018-12-31 Thread Paul Rogers (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-8014?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Paul Rogers updated IMPALA-8014: Description: The math is wrong when we estimate the cardinality of a join we've labeled as

[jira] [Created] (IMPALA-8033) PlanNode getInputCardinality has two conflicting meanings

2018-12-31 Thread Paul Rogers (JIRA)
Paul Rogers created IMPALA-8033: --- Summary: PlanNode getInputCardinality has two conflicting meanings Key: IMPALA-8033 URL: https://issues.apache.org/jira/browse/IMPALA-8033 Project: IMPALA

[jira] [Created] (IMPALA-8031) Remove redundant inequalities for selectivity calcs

2018-12-31 Thread Paul Rogers (JIRA)
Paul Rogers created IMPALA-8031: --- Summary: Remove redundant inequalities for selectivity calcs Key: IMPALA-8031 URL: https://issues.apache.org/jira/browse/IMPALA-8031 Project: IMPALA Issue

[jira] [Created] (IMPALA-8036) Bad join cardinality estimation for missing stats

2018-12-31 Thread Paul Rogers (JIRA)
Paul Rogers created IMPALA-8036: --- Summary: Bad join cardinality estimation for missing stats Key: IMPALA-8036 URL: https://issues.apache.org/jira/browse/IMPALA-8036 Project: IMPALA Issue Type:

[jira] [Commented] (IMPALA-8026) Actual row counts for nested loop join are meaningless

2018-12-31 Thread Tim Armstrong (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-8026?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16731462#comment-16731462 ] Tim Armstrong commented on IMPALA-8026: --- [~Paul.Rogers] can you include the full plan or at least

[jira] [Created] (IMPALA-8037) Planner makes poor estimations for non-equality predicates

2018-12-31 Thread Paul Rogers (JIRA)
Paul Rogers created IMPALA-8037: --- Summary: Planner makes poor estimations for non-equality predicates Key: IMPALA-8037 URL: https://issues.apache.org/jira/browse/IMPALA-8037 Project: IMPALA