[jira] [Updated] (HIVE-17538) Enhance estimation of stats to estimate even if only one column is missing stats

2017-09-16 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17538?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17538: --- Status: Patch Available (was: Open) > Enhance estimation of stats to estimate even if only one

[jira] [Updated] (HIVE-17493) Improve PKFK cardinality estimation in Physical planning

2017-09-16 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17493?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17493: --- Attachment: HIVE-17493.4.patch Uploading rebased patch to trigger qtests. > Improve PKFK cardinality

[jira] [Updated] (HIVE-17493) Improve PKFK cardinality estimation in Physical planning

2017-09-16 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17493?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17493: --- Status: Patch Available (was: Open) > Improve PKFK cardinality estimation in Physical planning >

[jira] [Updated] (HIVE-17493) Improve PKFK cardinality estimation in Physical planning

2017-09-16 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17493?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17493: --- Status: Open (was: Patch Available) > Improve PKFK cardinality estimation in Physical planning >

[jira] [Updated] (HIVE-17536) StatsUtil::getBasicStatForTable doesn't distinguish b/w absence of statistics or zero stats

2017-09-16 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17536?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17536: --- Status: Open (was: Patch Available) > StatsUtil::getBasicStatForTable doesn't distinguish b/w

[jira] [Updated] (HIVE-17465) Statistics: Drill-down filters don't reduce row-counts progressively

2017-09-16 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17465?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17465: --- Attachment: HIVE-17465.6.patch For some reason ptests are not being scheduled for this issue, so

[jira] [Updated] (HIVE-17465) Statistics: Drill-down filters don't reduce row-counts progressively

2017-09-16 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17465?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17465: --- Status: Patch Available (was: Open) > Statistics: Drill-down filters don't reduce row-counts

[jira] [Updated] (HIVE-17535) Select 1 EXCEPT Select 1 fails with NPE

2017-09-18 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17535: --- Status: Patch Available (was: Open) > Select 1 EXCEPT Select 1 fails with NPE >

[jira] [Updated] (HIVE-17535) Select 1 EXCEPT Select 1 fails with NPE

2017-09-18 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17535: --- Attachment: HIVE-17535.3.patch > Select 1 EXCEPT Select 1 fails with NPE >

[jira] [Updated] (HIVE-17535) Select 1 EXCEPT Select 1 fails with NPE

2017-09-18 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17535: --- Status: Open (was: Patch Available) > Select 1 EXCEPT Select 1 fails with NPE >

[jira] [Updated] (HIVE-17465) Statistics: Drill-down filters don't reduce row-counts progressively

2017-09-18 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17465?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17465: --- Fix Version/s: 3.0.0 > Statistics: Drill-down filters don't reduce row-counts progressively >

[jira] [Commented] (HIVE-17535) Select 1 EXCEPT Select 1 fails with NPE

2017-09-18 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16170749#comment-16170749 ] Vineet Garg commented on HIVE-17535: Latest patch(3) has known failure {{min_structvalue}} which is a

[jira] [Commented] (HIVE-17535) Select 1 EXCEPT Select 1 fails with NPE

2017-09-18 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16170764#comment-16170764 ] Vineet Garg commented on HIVE-17535: Good to know. I'll disable the test for now and will udpate

[jira] [Updated] (HIVE-17535) Select 1 EXCEPT Select 1 fails with NPE

2017-09-18 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17535: --- Attachment: HIVE-17535.3.patch > Select 1 EXCEPT Select 1 fails with NPE >

[jira] [Updated] (HIVE-17535) Select 1 EXCEPT Select 1 fails with NPE

2017-09-18 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17535: --- Attachment: (was: HIVE-17535.3.patch) > Select 1 EXCEPT Select 1 fails with NPE >

[jira] [Commented] (HIVE-16511) CBO looses inner casts on constants of complex type

2017-09-18 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16511?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16170770#comment-16170770 ] Vineet Garg commented on HIVE-16511: Test {{min_structvalue.q}} needs to be enabled once this issue is

[jira] [Updated] (HIVE-17535) Select 1 EXCEPT Select 1 fails with NPE

2017-09-18 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17535: --- Status: Open (was: Patch Available) > Select 1 EXCEPT Select 1 fails with NPE >

[jira] [Updated] (HIVE-17535) Select 1 EXCEPT Select 1 fails with NPE

2017-09-18 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17535: --- Status: Patch Available (was: Open) > Select 1 EXCEPT Select 1 fails with NPE >

[jira] [Updated] (HIVE-17535) Select 1 EXCEPT Select 1 fails with NPE

2017-09-19 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17535: --- Status: Open (was: Patch Available) > Select 1 EXCEPT Select 1 fails with NPE >

[jira] [Updated] (HIVE-17535) Select 1 EXCEPT Select 1 fails with NPE

2017-09-19 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17535: --- Attachment: HIVE-17535.5.patch > Select 1 EXCEPT Select 1 fails with NPE >

[jira] [Commented] (HIVE-17538) Enhance estimation of stats to estimate even if only one column is missing stats

2017-09-19 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16172535#comment-16172535 ] Vineet Garg commented on HIVE-17538: Unfortunately the test report is not available anymore so will

[jira] [Updated] (HIVE-17536) StatsUtil::getBasicStatForTable doesn't distinguish b/w absence of statistics or zero stats

2017-09-19 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17536?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17536: --- Status: Patch Available (was: Open) > StatsUtil::getBasicStatForTable doesn't distinguish b/w

[jira] [Updated] (HIVE-17536) StatsUtil::getBasicStatForTable doesn't distinguish b/w absence of statistics or zero stats

2017-09-19 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17536?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17536: --- Attachment: HIVE-17536.4.patch > StatsUtil::getBasicStatForTable doesn't distinguish b/w absence of

[jira] [Updated] (HIVE-17536) StatsUtil::getBasicStatForTable doesn't distinguish b/w absence of statistics or zero stats

2017-09-19 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17536?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17536: --- Status: Open (was: Patch Available) > StatsUtil::getBasicStatForTable doesn't distinguish b/w

[jira] [Updated] (HIVE-17535) Select 1 EXCEPT Select 1 fails with NPE

2017-09-19 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17535: --- Status: Patch Available (was: Open) Latest patch(5) should fix test failures > Select 1 EXCEPT

[jira] [Updated] (HIVE-17536) StatsUtil::getBasicStatForTable doesn't distinguish b/w absence of statistics or zero stats

2017-09-21 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17536?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17536: --- Attachment: HIVE-17536.6.patch > StatsUtil::getBasicStatForTable doesn't distinguish b/w absence of

[jira] [Updated] (HIVE-17536) StatsUtil::getBasicStatForTable doesn't distinguish b/w absence of statistics or zero stats

2017-09-21 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17536?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17536: --- Status: Open (was: Patch Available) > StatsUtil::getBasicStatForTable doesn't distinguish b/w

[jira] [Updated] (HIVE-17536) StatsUtil::getBasicStatForTable doesn't distinguish b/w absence of statistics or zero stats

2017-09-21 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17536?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17536: --- Status: Patch Available (was: Open) > StatsUtil::getBasicStatForTable doesn't distinguish b/w

[jira] [Updated] (HIVE-17538) Enhance estimation of stats to estimate even if only one column is missing stats

2017-09-23 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17538?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17538: --- Status: Open (was: Patch Available) > Enhance estimation of stats to estimate even if only one

[jira] [Updated] (HIVE-17538) Enhance estimation of stats to estimate even if only one column is missing stats

2017-09-23 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17538?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17538: --- Attachment: HIVE-17538.3.patch > Enhance estimation of stats to estimate even if only one column is

[jira] [Commented] (HIVE-17538) Enhance estimation of stats to estimate even if only one column is missing stats

2017-09-23 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16177976#comment-16177976 ] Vineet Garg commented on HIVE-17538: Review board link attached > Enhance estimation of stats to

[jira] [Updated] (HIVE-17538) Enhance estimation of stats to estimate even if only one column is missing stats

2017-09-23 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17538?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17538: --- Status: Patch Available (was: Open) > Enhance estimation of stats to estimate even if only one

[jira] [Updated] (HIVE-17536) StatsUtil::getBasicStatForTable doesn't distinguish b/w absence of statistics or zero stats

2017-09-20 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17536?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17536: --- Attachment: HIVE-17536.5.patch > StatsUtil::getBasicStatForTable doesn't distinguish b/w absence of

[jira] [Updated] (HIVE-17536) StatsUtil::getBasicStatForTable doesn't distinguish b/w absence of statistics or zero stats

2017-09-20 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17536?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17536: --- Status: Open (was: Patch Available) > StatsUtil::getBasicStatForTable doesn't distinguish b/w

[jira] [Updated] (HIVE-17536) StatsUtil::getBasicStatForTable doesn't distinguish b/w absence of statistics or zero stats

2017-09-20 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17536?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17536: --- Status: Patch Available (was: Open) > StatsUtil::getBasicStatForTable doesn't distinguish b/w

[jira] [Updated] (HIVE-17535) Select 1 EXCEPT Select 1 fails with NPE

2017-09-20 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17535: --- Resolution: Fixed Status: Resolved (was: Patch Available) Pushed to master. Thanks for

[jira] [Updated] (HIVE-17308) Improvement in join cardinality estimation

2017-09-20 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17308?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17308: --- Fix Version/s: 3.0.0 > Improvement in join cardinality estimation >

[jira] [Commented] (HIVE-17308) Improvement in join cardinality estimation

2017-09-20 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17308?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16174206#comment-16174206 ] Vineet Garg commented on HIVE-17308: [~leftylev] Done. > Improvement in join cardinality estimation >

[jira] [Updated] (HIVE-17535) Select 1 EXCEPT Select 1 fails with NPE

2017-09-20 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17535: --- Fix Version/s: 3.0.0 > Select 1 EXCEPT Select 1 fails with NPE >

[jira] [Commented] (HIVE-17465) Statistics: Drill-down filters don't reduce row-counts progressively

2017-09-13 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17465?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16165300#comment-16165300 ] Vineet Garg commented on HIVE-17465: [~ashutoshc] I am investigating few suspicious test failures.

[jira] [Commented] (HIVE-17493) Improve PKFK cardinality estimation in Physical planning

2017-09-13 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17493?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16165298#comment-16165298 ] Vineet Garg commented on HIVE-17493: Yeah looks like it. I'll rebase and re-upload the patch. >

[jira] [Updated] (HIVE-17536) StatsUtil::getBasicStatForTable doesn't distinguish b/w absence of statistics or zero stats

2017-09-15 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17536?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17536: --- Attachment: HIVE-17536.2.patch > StatsUtil::getBasicStatForTable doesn't distinguish b/w absence of

[jira] [Updated] (HIVE-17536) StatsUtil::getBasicStatForTable doesn't distinguish b/w absence of statistics or zero stats

2017-09-15 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17536?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17536: --- Status: Open (was: Patch Available) > StatsUtil::getBasicStatForTable doesn't distinguish b/w

[jira] [Updated] (HIVE-17465) Statistics: Drill-down filters don't reduce row-counts progressively

2017-09-15 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17465?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17465: --- Status: Patch Available (was: Open) > Statistics: Drill-down filters don't reduce row-counts

[jira] [Commented] (HIVE-17536) StatsUtil::getBasicStatForTable doesn't distinguish b/w absence of statistics or zero stats

2017-09-15 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17536?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16168219#comment-16168219 ] Vineet Garg commented on HIVE-17536: [~ashutoshc] if stat key is missing following code will throw

[jira] [Updated] (HIVE-17536) StatsUtil::getBasicStatForTable doesn't distinguish b/w absence of statistics or zero stats

2017-09-15 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17536?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17536: --- Status: Patch Available (was: Open) > StatsUtil::getBasicStatForTable doesn't distinguish b/w

[jira] [Updated] (HIVE-17535) Select 1 EXCEPT Select 1 fails with NPE

2017-09-16 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17535: --- Status: Open (was: Patch Available) > Select 1 EXCEPT Select 1 fails with NPE >

[jira] [Updated] (HIVE-17535) Select 1 EXCEPT Select 1 fails with NPE

2017-09-16 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17535: --- Status: Patch Available (was: Open) > Select 1 EXCEPT Select 1 fails with NPE >

[jira] [Updated] (HIVE-17535) Select 1 EXCEPT Select 1 fails with NPE

2017-09-16 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17535: --- Attachment: HIVE-17535.2.patch > Select 1 EXCEPT Select 1 fails with NPE >

[jira] [Commented] (HIVE-17465) Statistics: Drill-down filters don't reduce row-counts progressively

2017-09-17 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17465?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16169469#comment-16169469 ] Vineet Garg commented on HIVE-17465: [~ashutoshc] can you take a look at updated review? >

[jira] [Updated] (HIVE-17465) Statistics: Drill-down filters don't reduce row-counts progressively

2017-09-17 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17465?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17465: --- Status: Patch Available (was: Open) > Statistics: Drill-down filters don't reduce row-counts

[jira] [Updated] (HIVE-17465) Statistics: Drill-down filters don't reduce row-counts progressively

2017-09-17 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17465?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17465: --- Status: Open (was: Patch Available) > Statistics: Drill-down filters don't reduce row-counts

[jira] [Updated] (HIVE-17465) Statistics: Drill-down filters don't reduce row-counts progressively

2017-09-17 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17465?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17465: --- Attachment: HIVE-17465.7.patch > Statistics: Drill-down filters don't reduce row-counts progressively

[jira] [Updated] (HIVE-17493) Improve PKFK cardinality estimation in Physical planning

2017-09-17 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17493?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17493: --- Resolution: Fixed Status: Resolved (was: Patch Available) Pushed to master > Improve PKFK

[jira] [Updated] (HIVE-17465) Statistics: Drill-down filters don't reduce row-counts progressively

2017-09-13 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17465?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17465: --- Status: Patch Available (was: Open) > Statistics: Drill-down filters don't reduce row-counts

[jira] [Updated] (HIVE-17465) Statistics: Drill-down filters don't reduce row-counts progressively

2017-09-13 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17465?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17465: --- Status: Open (was: Patch Available) > Statistics: Drill-down filters don't reduce row-counts

[jira] [Updated] (HIVE-17465) Statistics: Drill-down filters don't reduce row-counts progressively

2017-09-13 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17465?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17465: --- Attachment: HIVE-17465.4.patch > Statistics: Drill-down filters don't reduce row-counts progressively

[jira] [Commented] (HIVE-17465) Statistics: Drill-down filters don't reduce row-counts progressively

2017-09-13 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17465?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16165381#comment-16165381 ] Vineet Garg commented on HIVE-17465: [~ashutoshc] New patch is uploaded and review board link is

[jira] [Updated] (HIVE-17493) Improve PKFK cardinality estimation in Physical planning

2017-09-13 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17493?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17493: --- Status: Patch Available (was: Open) > Improve PKFK cardinality estimation in Physical planning >

[jira] [Updated] (HIVE-17493) Improve PKFK cardinality estimation in Physical planning

2017-09-13 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17493?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17493: --- Status: Open (was: Patch Available) > Improve PKFK cardinality estimation in Physical planning >

[jira] [Updated] (HIVE-17493) Improve PKFK cardinality estimation in Physical planning

2017-09-13 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17493?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17493: --- Attachment: HIVE-17493.3.patch > Improve PKFK cardinality estimation in Physical planning >

[jira] [Updated] (HIVE-17465) Statistics: Drill-down filters don't reduce row-counts progressively

2017-09-13 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17465?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17465: --- Status: Open (was: Patch Available) > Statistics: Drill-down filters don't reduce row-counts

[jira] [Updated] (HIVE-17465) Statistics: Drill-down filters don't reduce row-counts progressively

2017-09-13 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17465?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17465: --- Status: Patch Available (was: Open) > Statistics: Drill-down filters don't reduce row-counts

[jira] [Updated] (HIVE-17465) Statistics: Drill-down filters don't reduce row-counts progressively

2017-09-13 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17465?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17465: --- Attachment: HIVE-17465.5.patch Latest patch(5) addresses review comments. > Statistics: Drill-down

[jira] [Updated] (HIVE-17535) Select 1 EXCEPT Select 1 fails with NPE

2017-09-14 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17535: --- Attachment: HIVE-17535.1.patch > Select 1 EXCEPT Select 1 fails with NPE >

[jira] [Updated] (HIVE-17535) Select 1 EXCEPT Select 1 fails with NPE

2017-09-14 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17535: --- Status: Patch Available (was: Open) > Select 1 EXCEPT Select 1 fails with NPE >

[jira] [Assigned] (HIVE-17535) Select 1 EXCEPT Select 1 fails with NPE

2017-09-14 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-17535: -- > Select 1 EXCEPT Select 1 fails with NPE > --- > >

[jira] [Assigned] (HIVE-17536) StatsUtil::getBasicStatForTable doesn't distinguish b/w absence of statistics or zero stats

2017-09-14 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17536?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-17536: -- > StatsUtil::getBasicStatForTable doesn't distinguish b/w absence of statistics > or zero stats >

[jira] [Updated] (HIVE-17536) StatsUtil::getBasicStatForTable doesn't distinguish b/w absence of statistics or zero stats

2017-09-14 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17536?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17536: --- Status: Patch Available (was: Open) > StatsUtil::getBasicStatForTable doesn't distinguish b/w

[jira] [Updated] (HIVE-17536) StatsUtil::getBasicStatForTable doesn't distinguish b/w absence of statistics or zero stats

2017-09-14 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17536?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17536: --- Component/s: Statistics > StatsUtil::getBasicStatForTable doesn't distinguish b/w absence of

[jira] [Updated] (HIVE-17536) StatsUtil::getBasicStatForTable doesn't distinguish b/w absence of statistics or zero stats

2017-09-14 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17536?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17536: --- Attachment: HIVE-17536.1.patch > StatsUtil::getBasicStatForTable doesn't distinguish b/w absence of

[jira] [Updated] (HIVE-17538) Enhance estimation of stats to estimate even if only one column is missing stats

2017-09-14 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17538?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17538: --- Attachment: HIVE-17538.1.patch > Enhance estimation of stats to estimate even if only one column is

[jira] [Assigned] (HIVE-17538) Enhance estimation of stats to estimate even if only one column is missing stats

2017-09-14 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17538?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-17538: -- > Enhance estimation of stats to estimate even if only one column is missing > stats >

[jira] [Updated] (HIVE-17538) Enhance estimation of stats to estimate even if only one column is missing stats

2017-09-21 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17538?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17538: --- Status: Patch Available (was: Open) Updated the logic in latest patch(2). Running it to get

[jira] [Updated] (HIVE-17538) Enhance estimation of stats to estimate even if only one column is missing stats

2017-09-21 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17538?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17538: --- Status: Open (was: Patch Available) > Enhance estimation of stats to estimate even if only one

[jira] [Updated] (HIVE-17538) Enhance estimation of stats to estimate even if only one column is missing stats

2017-09-21 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17538?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17538: --- Attachment: HIVE-17538.2.patch > Enhance estimation of stats to estimate even if only one column is

[jira] [Commented] (HIVE-17536) StatsUtil::getBasicStatForTable doesn't distinguish b/w absence of statistics or zero stats

2017-09-22 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17536?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16176734#comment-16176734 ] Vineet Garg commented on HIVE-17536: Test failures are unrelated. > StatsUtil::getBasicStatForTable

[jira] [Updated] (HIVE-17465) Statistics: Drill-down filters don't reduce row-counts progressively

2017-09-18 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17465?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17465: --- Resolution: Fixed Status: Resolved (was: Patch Available) Pushed to master. Thanks for

[jira] [Updated] (HIVE-17535) Select 1 EXCEPT Select 1 fails with NPE

2017-09-18 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17535: --- Attachment: HIVE-17535.4.patch > Select 1 EXCEPT Select 1 fails with NPE >

[jira] [Updated] (HIVE-17535) Select 1 EXCEPT Select 1 fails with NPE

2017-09-18 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17535: --- Status: Open (was: Patch Available) > Select 1 EXCEPT Select 1 fails with NPE >

[jira] [Updated] (HIVE-17535) Select 1 EXCEPT Select 1 fails with NPE

2017-09-18 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17535: --- Status: Patch Available (was: Open) > Select 1 EXCEPT Select 1 fails with NPE >

[jira] [Commented] (HIVE-17536) StatsUtil::getBasicStatForTable doesn't distinguish b/w absence of statistics or zero stats

2017-09-15 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17536?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16168751#comment-16168751 ] Vineet Garg commented on HIVE-17536: This is for queries without from e.g. {{select 1}}. getBasicStats

[jira] [Updated] (HIVE-17553) CBO wrongly type cast decimal literal to int

2017-10-06 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17553?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17553: --- Attachment: HIVE-17553.2.patch > CBO wrongly type cast decimal literal to int >

[jira] [Updated] (HIVE-17553) CBO wrongly type cast decimal literal to int

2017-10-06 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17553?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17553: --- Status: Open (was: Patch Available) > CBO wrongly type cast decimal literal to int >

[jira] [Updated] (HIVE-17553) CBO wrongly type cast decimal literal to int

2017-10-06 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17553?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17553: --- Status: Patch Available (was: Open) > CBO wrongly type cast decimal literal to int >

[jira] [Updated] (HIVE-17602) Explain plan not working

2017-10-02 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17602?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17602: --- Attachment: HIVE-17602.3.patch > Explain plan not working > > >

[jira] [Updated] (HIVE-17602) Explain plan not working

2017-10-02 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17602?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17602: --- Status: Patch Available (was: Open) > Explain plan not working > > >

[jira] [Updated] (HIVE-17602) Explain plan not working

2017-10-02 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17602?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17602: --- Status: Open (was: Patch Available) > Explain plan not working > > >

[jira] [Updated] (HIVE-16511) CBO looses inner casts on constants of complex type

2017-10-03 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16511?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-16511: --- Attachment: HIVE-16511.2.patch > CBO looses inner casts on constants of complex type >

[jira] [Updated] (HIVE-16511) CBO looses inner casts on constants of complex type

2017-10-03 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16511?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-16511: --- Status: Open (was: Patch Available) > CBO looses inner casts on constants of complex type >

[jira] [Updated] (HIVE-16511) CBO looses inner casts on constants of complex type

2017-10-03 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16511?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-16511: --- Status: Patch Available (was: Open) > CBO looses inner casts on constants of complex type >

[jira] [Assigned] (HIVE-17726) Using exists may lead to incorrect results

2017-10-09 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-17726: -- Assignee: Vineet Garg > Using exists may lead to incorrect results >

[jira] [Assigned] (HIVE-17767) Rewrite correlated EXISTS/IN subqueries into LEFT SEMI JOIN

2017-10-10 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17767?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-17767: -- > Rewrite correlated EXISTS/IN subqueries into LEFT SEMI JOIN >

[jira] [Commented] (HIVE-17553) CBO wrongly type cast decimal literal to int

2017-10-05 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17553?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16193898#comment-16193898 ] Vineet Garg commented on HIVE-17553: This happens due to RexBuilder::makeExactLiteral creating

[jira] [Updated] (HIVE-17553) CBO wrongly type cast decimal literal to int

2017-10-05 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17553?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17553: --- Status: Patch Available (was: Open) > CBO wrongly type cast decimal literal to int >

[jira] [Updated] (HIVE-17553) CBO wrongly type cast decimal literal to int

2017-10-05 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17553?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17553: --- Attachment: HIVE-17553.1.patch > CBO wrongly type cast decimal literal to int >

[jira] [Assigned] (HIVE-17553) CBO wrongly type cast decimal literal to int

2017-10-05 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17553?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-17553: -- Assignee: Vineet Garg > CBO wrongly type cast decimal literal to int >

[jira] [Comment Edited] (HIVE-17553) CBO wrongly type cast decimal literal to int

2017-10-05 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17553?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16193898#comment-16193898 ] Vineet Garg edited comment on HIVE-17553 at 10/5/17 11:24 PM: -- This happens

[jira] [Commented] (HIVE-17726) Using exists may lead to incorrect results

2017-10-16 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17726?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16206298#comment-16206298 ] Vineet Garg commented on HIVE-17726: Hi [~pvary]. This does look like caused by HIVE-17726. Is there

[jira] [Commented] (HIVE-17756) Enable subquery related Qtests for Hive on Spark

2017-10-16 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17756?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16206531#comment-16206531 ] Vineet Garg commented on HIVE-17756: [~dapengsun] Can you open a jira and regenerate failing tests? I

<    3   4   5   6   7   8   9   10   11   12   >