[jira] [Commented] (IMPALA-7560) Better selectivity estimate for != (not equals) binary predicate

2021-09-27 Thread ASF subversion and git services (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-7560?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17420630#comment-17420630 ] ASF subversion and git services commented on IMPALA-7560: - Commit

[jira] [Commented] (IMPALA-7560) Better selectivity estimate for != (not equals) binary predicate

2021-06-24 Thread ASF subversion and git services (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-7560?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17368908#comment-17368908 ] ASF subversion and git services commented on IMPALA-7560: - Commit

[jira] [Commented] (IMPALA-7560) Better selectivity estimate for != (not equals) binary predicate

2021-06-22 Thread liuyao (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-7560?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17367827#comment-17367827 ] liuyao commented on IMPALA-7560:   Calculation formula: ( 1 - 1 / ndv ) * "non-null values caridinality"

[jira] [Commented] (IMPALA-7560) Better selectivity estimate for != (not equals) binary predicate

2021-06-11 Thread liuyao (Jira)
[ https://issues.apache.org/jira/browse/IMPALA-7560?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17361434#comment-17361434 ] liuyao commented on IMPALA-7560: https://gerrit.cloudera.org/#/c/17344/ > Better selectivity estimate

[jira] [Commented] (IMPALA-7560) Better selectivity estimate for != (not equals) binary predicate

2018-09-21 Thread Paul Rogers (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-7560?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16624019#comment-16624019 ] Paul Rogers commented on IMPALA-7560: - Created a unit test for this. {noformat} runTest("SELECT

[jira] [Commented] (IMPALA-7560) Better selectivity estimate for != (not equals) binary predicate

2018-09-19 Thread Paul Rogers (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-7560?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16620946#comment-16620946 ] Paul Rogers commented on IMPALA-7560: - The table in DRILL-5254 suggests how to use the NDV value to

[jira] [Commented] (IMPALA-7560) Better selectivity estimate for != (not equals) binary predicate

2018-09-18 Thread bharath v (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-7560?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16620017#comment-16620017 ] bharath v commented on IMPALA-7560: --- Agreed [~Paul.Rogers]. Impala tables can include stats (NDVs

[jira] [Commented] (IMPALA-7560) Better selectivity estimate for != (not equals) binary predicate

2018-09-18 Thread Paul Rogers (JIRA)
[ https://issues.apache.org/jira/browse/IMPALA-7560?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16619827#comment-16619827 ] Paul Rogers commented on IMPALA-7560: - Turns out that Apache Drill did a similar analysis to work