[jira] [Commented] (HIVE-21634) Materialized view rewriting over aggregate operators containing with grouping sets

[ https://issues.apache.org/jira/browse/HIVE-21634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16824427#comment-16824427 ] Vineet Garg commented on HIVE-21634: +1 pending tests > Materialized view rewriting over aggregate

[jira] [Commented] (HIVE-21629) Monitor qtest progress realtime on console

[ https://issues.apache.org/jira/browse/HIVE-21629?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16822113#comment-16822113 ] Vineet Garg commented on HIVE-21629: I usually tail hive.log to see the progress. I agree that adding

[jira] [Commented] (HIVE-21632) Hive should not push partition columns to the Parquet predicate, even if the data file contains the partition column

[ https://issues.apache.org/jira/browse/HIVE-21632?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16822110#comment-16822110 ] Vineet Garg commented on HIVE-21632: Duplicate of HIVE-21599? > Hive should not push partition

[jira] [Commented] (HIVE-21574) return wrong result when execute left join sql

[ https://issues.apache.org/jira/browse/HIVE-21574?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16818458#comment-16818458 ] Vineet Garg commented on HIVE-21574: [~Panda Song] Can you provide data to help reproduce this? >

[jira] [Updated] (HIVE-21572) HiveRemoveSqCountCheck rule could be enhanced to capture more patterns

[ https://issues.apache.org/jira/browse/HIVE-21572?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21572: --- Status: Open (was: Patch Available) > HiveRemoveSqCountCheck rule could be enhanced to capture more

[jira] [Updated] (HIVE-21599) Remove predicate on partition columns from Table Scan operator

[ https://issues.apache.org/jira/browse/HIVE-21599?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21599: --- Status: Patch Available (was: Open) > Remove predicate on partition columns from Table Scan

[jira] [Updated] (HIVE-21572) HiveRemoveSqCountCheck rule could be enhanced to capture more patterns

[ https://issues.apache.org/jira/browse/HIVE-21572?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21572: --- Description: HIVE-21231 caused the pattern of scalar subqueries to change a bit causing

[jira] [Commented] (HIVE-21600) GenTezUtils.removeSemiJoinOperator may throw out of bounds exception for TS with multiple children

[ https://issues.apache.org/jira/browse/HIVE-21600?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16816724#comment-16816724 ] Vineet Garg commented on HIVE-21600: +1 > GenTezUtils.removeSemiJoinOperator may throw out of bounds

[jira] [Updated] (HIVE-13582) E061-07 and E061-12: Quantified Comparison Predicates

[ https://issues.apache.org/jira/browse/HIVE-13582?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-13582: --- Status: Patch Available (was: Open) > E061-07 and E061-12: Quantified Comparison Predicates >

[jira] [Updated] (HIVE-13582) E061-07 and E061-12: Quantified Comparison Predicates

[ https://issues.apache.org/jira/browse/HIVE-13582?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-13582: --- Attachment: HIVE-13582.3.patch > E061-07 and E061-12: Quantified Comparison Predicates >

[jira] [Updated] (HIVE-13582) E061-07 and E061-12: Quantified Comparison Predicates

[ https://issues.apache.org/jira/browse/HIVE-13582?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-13582: --- Status: Open (was: Patch Available) > E061-07 and E061-12: Quantified Comparison Predicates >

[jira] [Updated] (HIVE-13582) E061-07 and E061-12: Quantified Comparison Predicates

[ https://issues.apache.org/jira/browse/HIVE-13582?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-13582: --- Status: Patch Available (was: Open) > E061-07 and E061-12: Quantified Comparison Predicates >

[jira] [Updated] (HIVE-13582) E061-07 and E061-12: Quantified Comparison Predicates

[ https://issues.apache.org/jira/browse/HIVE-13582?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-13582: --- Status: Open (was: Patch Available) > E061-07 and E061-12: Quantified Comparison Predicates >

[jira] [Updated] (HIVE-13582) E061-07 and E061-12: Quantified Comparison Predicates

[ https://issues.apache.org/jira/browse/HIVE-13582?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-13582: --- Attachment: HIVE-13582.2.patch > E061-07 and E061-12: Quantified Comparison Predicates >

[jira] [Updated] (HIVE-21572) HiveRemoveSqCountCheck rule could be enhanced to capture more patterns

[ https://issues.apache.org/jira/browse/HIVE-21572?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21572: --- Description: HIVE-21231 caused the pattern of scalar subqueries to change a bit causing

[jira] [Commented] (HIVE-21533) Nested CTE's with join does not return any data.

[ https://issues.apache.org/jira/browse/HIVE-21533?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16814952#comment-16814952 ] Vineet Garg commented on HIVE-21533: [~ngangam] Is this only reproducible with 2.1? On upstream I am

[jira] [Comment Edited] (HIVE-21599) Remove predicate on partition columns from Table Scan operator

[ https://issues.apache.org/jira/browse/HIVE-21599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16814751#comment-16814751 ] Vineet Garg edited comment on HIVE-21599 at 4/10/19 8:20 PM: - cc

[jira] [Comment Edited] (HIVE-21599) Remove predicate on partition columns from Table Scan operator

[ https://issues.apache.org/jira/browse/HIVE-21599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16814751#comment-16814751 ] Vineet Garg edited comment on HIVE-21599 at 4/10/19 8:20 PM: - cc @gopal

[jira] [Updated] (HIVE-21599) Remove predicate on partition columns from Table Scan operator

[ https://issues.apache.org/jira/browse/HIVE-21599?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21599: --- Attachment: HIVE-21599.1.patch > Remove predicate on partition columns from Table Scan operator >

[jira] [Commented] (HIVE-21599) Remove predicate on partition columns from Table Scan operator

[ https://issues.apache.org/jira/browse/HIVE-21599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16814751#comment-16814751 ] Vineet Garg commented on HIVE-21599: cc [~gopal] [~prasanth_j] > Remove predicate on partition

[jira] [Assigned] (HIVE-21599) Remove predicate on partition columns from Table Scan operator

[ https://issues.apache.org/jira/browse/HIVE-21599?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-21599: -- > Remove predicate on partition columns from Table Scan operator >

[jira] [Updated] (HIVE-21572) HiveRemoveSqCountCheck rule could be enhanced to capture more patterns

[ https://issues.apache.org/jira/browse/HIVE-21572?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21572: --- Status: Patch Available (was: Open) > HiveRemoveSqCountCheck rule could be enhanced to capture more

[jira] [Updated] (HIVE-21572) HiveRemoveSqCountCheck rule could be enhanced to capture more patterns

[ https://issues.apache.org/jira/browse/HIVE-21572?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21572: --- Status: Open (was: Patch Available) > HiveRemoveSqCountCheck rule could be enhanced to capture more

[jira] [Updated] (HIVE-21572) HiveRemoveSqCountCheck rule could be enhanced to capture more patterns

[ https://issues.apache.org/jira/browse/HIVE-21572?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21572: --- Attachment: HIVE-21572.3.patch > HiveRemoveSqCountCheck rule could be enhanced to capture more

[jira] [Assigned] (HIVE-13582) E061-07 and E061-12: Quantified Comparison Predicates

[ https://issues.apache.org/jira/browse/HIVE-13582?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-13582: -- Assignee: Vineet Garg > E061-07 and E061-12: Quantified Comparison Predicates >

[jira] [Commented] (HIVE-13582) E061-07 and E061-12: Quantified Comparison Predicates

[ https://issues.apache.org/jira/browse/HIVE-13582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16813863#comment-16813863 ] Vineet Garg commented on HIVE-13582: Attaching initial patch to support ALL and SOME/ANY for

[jira] [Updated] (HIVE-13582) E061-07 and E061-12: Quantified Comparison Predicates

[ https://issues.apache.org/jira/browse/HIVE-13582?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-13582: --- Status: Patch Available (was: Open) > E061-07 and E061-12: Quantified Comparison Predicates >

[jira] [Updated] (HIVE-13582) E061-07 and E061-12: Quantified Comparison Predicates

[ https://issues.apache.org/jira/browse/HIVE-13582?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-13582: --- Attachment: HIVE-13582.1.patch > E061-07 and E061-12: Quantified Comparison Predicates >

[jira] [Resolved] (HIVE-9532) add support for quantified predicates

[ https://issues.apache.org/jira/browse/HIVE-9532?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg resolved HIVE-9532. --- Resolution: Duplicate > add support for quantified predicates >

[jira] [Commented] (HIVE-21568) HiveRelOptUtil.isRowFilteringPlan should skip Project

[ https://issues.apache.org/jira/browse/HIVE-21568?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812770#comment-16812770 ] Vineet Garg commented on HIVE-21568: Got it. +1 pending tests > HiveRelOptUtil.isRowFilteringPlan

[jira] [Updated] (HIVE-20265) PTF operator has an extra reducer in CBO

[ https://issues.apache.org/jira/browse/HIVE-20265?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-20265: --- Affects Version/s: 4.0.0 > PTF operator has an extra reducer in CBO >

[jira] [Commented] (HIVE-21568) HiveRelOptUtil.isRowFilteringPlan should skip Project

[ https://issues.apache.org/jira/browse/HIVE-21568?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812691#comment-16812691 ] Vineet Garg commented on HIVE-21568: Disregard my comment. It is not possible to have SET operator at

[jira] [Comment Edited] (HIVE-21568) HiveRelOptUtil.isRowFilteringPlan should skip Project

[ https://issues.apache.org/jira/browse/HIVE-21568?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812691#comment-16812691 ] Vineet Garg edited comment on HIVE-21568 at 4/8/19 6:31 PM: Disregard my

[jira] [Commented] (HIVE-21568) HiveRelOptUtil.isRowFilteringPlan should skip Project

[ https://issues.apache.org/jira/browse/HIVE-21568?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812687#comment-16812687 ] Vineet Garg commented on HIVE-21568: Also how would LIMIT alter the cardinality? >

[jira] [Commented] (HIVE-21568) HiveRelOptUtil.isRowFilteringPlan should skip Project

[ https://issues.apache.org/jira/browse/HIVE-21568?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812685#comment-16812685 ] Vineet Garg commented on HIVE-21568: [~jcamachorodriguez] What if project is projecting

[jira] [Updated] (HIVE-21572) HiveRemoveSqCountCheck rule could be enhanced to capture more patterns

[ https://issues.apache.org/jira/browse/HIVE-21572?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21572: --- Status: Patch Available (was: Open) > HiveRemoveSqCountCheck rule could be enhanced to capture more

[jira] [Updated] (HIVE-21572) HiveRemoveSqCountCheck rule could be enhanced to capture more patterns

[ https://issues.apache.org/jira/browse/HIVE-21572?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21572: --- Attachment: HIVE-21572.2.patch > HiveRemoveSqCountCheck rule could be enhanced to capture more

[jira] [Updated] (HIVE-21539) GroupBy + where clause on same column results in incorrect query rewrite

[ https://issues.apache.org/jira/browse/HIVE-21539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21539: --- Resolution: Fixed Fix Version/s: 4.0.0 Status: Resolved (was: Patch Available) >

[jira] [Updated] (HIVE-21539) GroupBy + where clause on same column results in incorrect query rewrite

[ https://issues.apache.org/jira/browse/HIVE-21539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21539: --- Status: Open (was: Patch Available) > GroupBy + where clause on same column results in incorrect

[jira] [Updated] (HIVE-21539) GroupBy + where clause on same column results in incorrect query rewrite

[ https://issues.apache.org/jira/browse/HIVE-21539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21539: --- Attachment: (was: HIVE-21539.4.patch) > GroupBy + where clause on same column results in

[jira] [Updated] (HIVE-21539) GroupBy + where clause on same column results in incorrect query rewrite

[ https://issues.apache.org/jira/browse/HIVE-21539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21539: --- Attachment: HIVE-21539.4.patch > GroupBy + where clause on same column results in incorrect query

[jira] [Updated] (HIVE-21539) GroupBy + where clause on same column results in incorrect query rewrite

[ https://issues.apache.org/jira/browse/HIVE-21539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21539: --- Status: Patch Available (was: Open) > GroupBy + where clause on same column results in incorrect

[jira] [Updated] (HIVE-21231) HiveJoinAddNotNullRule support for range predicates

[ https://issues.apache.org/jira/browse/HIVE-21231?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21231: --- Resolution: Fixed Fix Version/s: 4.0.0 Status: Resolved (was: Patch Available)

[jira] [Updated] (HIVE-21539) GroupBy + where clause on same column results in incorrect query rewrite

[ https://issues.apache.org/jira/browse/HIVE-21539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21539: --- Status: Open (was: Patch Available) > GroupBy + where clause on same column results in incorrect

[jira] [Updated] (HIVE-21539) GroupBy + where clause on same column results in incorrect query rewrite

[ https://issues.apache.org/jira/browse/HIVE-21539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21539: --- Status: Patch Available (was: Open) > GroupBy + where clause on same column results in incorrect

[jira] [Commented] (HIVE-21231) HiveJoinAddNotNullRule support for range predicates

[ https://issues.apache.org/jira/browse/HIVE-21231?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16809346#comment-16809346 ] Vineet Garg commented on HIVE-21231: HIVE-21572 has a patch to fix these regressions. Once this patch

[jira] [Updated] (HIVE-21572) HiveRemoveSqCountCheck rule could be enhanced to capture more patterns

[ https://issues.apache.org/jira/browse/HIVE-21572?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21572: --- Attachment: HIVE-21572.1.patch > HiveRemoveSqCountCheck rule could be enhanced to capture more

[jira] [Assigned] (HIVE-21572) HiveRemoveSqCountCheck rule could be enhanced to capture more patterns

[ https://issues.apache.org/jira/browse/HIVE-21572?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-21572: -- > HiveRemoveSqCountCheck rule could be enhanced to capture more patterns >

[jira] [Commented] (HIVE-21231) HiveJoinAddNotNullRule support for range predicates

[ https://issues.apache.org/jira/browse/HIVE-21231?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16809315#comment-16809315 ] Vineet Garg commented on HIVE-21231: There are still some queries which are still regressing (queries

[jira] [Updated] (HIVE-21386) Extend the fetch task enhancement done in HIVE-21279 to make it work with query result cache

[ https://issues.apache.org/jira/browse/HIVE-21386?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21386: --- Resolution: Fixed Fix Version/s: 4.0.0 Status: Resolved (was: Patch Available)

[jira] [Updated] (HIVE-21539) GroupBy + where clause on same column results in incorrect query rewrite

[ https://issues.apache.org/jira/browse/HIVE-21539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21539: --- Status: Open (was: Patch Available) > GroupBy + where clause on same column results in incorrect

[jira] [Updated] (HIVE-21539) GroupBy + where clause on same column results in incorrect query rewrite

[ https://issues.apache.org/jira/browse/HIVE-21539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21539: --- Status: Patch Available (was: Open) > GroupBy + where clause on same column results in incorrect

[jira] [Updated] (HIVE-21539) GroupBy + where clause on same column results in incorrect query rewrite

[ https://issues.apache.org/jira/browse/HIVE-21539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21539: --- Attachment: HIVE-21539.3.patch > GroupBy + where clause on same column results in incorrect query

[jira] [Commented] (HIVE-21231) HiveJoinAddNotNullRule support for range predicates

[ https://issues.apache.org/jira/browse/HIVE-21231?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808105#comment-16808105 ] Vineet Garg commented on HIVE-21231: [~mgergely] Can you update the pull request as well? >

[jira] [Commented] (HIVE-21539) GroupBy + where clause on same column results in incorrect query rewrite

[ https://issues.apache.org/jira/browse/HIVE-21539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807971#comment-16807971 ] Vineet Garg commented on HIVE-21539: [~jcamachorodriguez] Can you take a look? This bug was

[jira] [Updated] (HIVE-21539) GroupBy + where clause on same column results in incorrect query rewrite

[ https://issues.apache.org/jira/browse/HIVE-21539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21539: --- Attachment: HIVE-21539.2.patch > GroupBy + where clause on same column results in incorrect query

[jira] [Updated] (HIVE-21539) GroupBy + where clause on same column results in incorrect query rewrite

[ https://issues.apache.org/jira/browse/HIVE-21539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21539: --- Status: Patch Available (was: Open) > GroupBy + where clause on same column results in incorrect

[jira] [Updated] (HIVE-21539) GroupBy + where clause on same column results in incorrect query rewrite

[ https://issues.apache.org/jira/browse/HIVE-21539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21539: --- Status: Open (was: Patch Available) > GroupBy + where clause on same column results in incorrect

[jira] [Updated] (HIVE-21537) Scalar query rewrite could be improved to not generate an extra join if subquery is guaranteed to produce atmost one row

[ https://issues.apache.org/jira/browse/HIVE-21537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21537: --- Resolution: Fixed Fix Version/s: 4.0.0 Status: Resolved (was: Patch Available)

[jira] [Updated] (HIVE-21386) Extend the fetch task enhancement done in HIVE-21279 to make it work with query result cache

[ https://issues.apache.org/jira/browse/HIVE-21386?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21386: --- Attachment: HIVE-21386.5.patch > Extend the fetch task enhancement done in HIVE-21279 to make it

[jira] [Updated] (HIVE-21386) Extend the fetch task enhancement done in HIVE-21279 to make it work with query result cache

[ https://issues.apache.org/jira/browse/HIVE-21386?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21386: --- Status: Patch Available (was: Open) > Extend the fetch task enhancement done in HIVE-21279 to make

[jira] [Updated] (HIVE-21386) Extend the fetch task enhancement done in HIVE-21279 to make it work with query result cache

[ https://issues.apache.org/jira/browse/HIVE-21386?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21386: --- Status: Open (was: Patch Available) > Extend the fetch task enhancement done in HIVE-21279 to make

[jira] [Updated] (HIVE-21539) GroupBy + where clause on same column results in incorrect query rewrite

[ https://issues.apache.org/jira/browse/HIVE-21539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21539: --- Status: Patch Available (was: Open) > GroupBy + where clause on same column results in incorrect

[jira] [Updated] (HIVE-21539) GroupBy + where clause on same column results in incorrect query rewrite

[ https://issues.apache.org/jira/browse/HIVE-21539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21539: --- Attachment: HIVE-21539.1.patch > GroupBy + where clause on same column results in incorrect query

[jira] [Updated] (HIVE-21537) Scalar query rewrite could be improved to not generate an extra join if subquery is guaranteed to produce atmost one row

[ https://issues.apache.org/jira/browse/HIVE-21537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21537: --- Status: Open (was: Patch Available) > Scalar query rewrite could be improved to not generate an

[jira] [Updated] (HIVE-21537) Scalar query rewrite could be improved to not generate an extra join if subquery is guaranteed to produce atmost one row

[ https://issues.apache.org/jira/browse/HIVE-21537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21537: --- Attachment: HIVE-21537.5.patch > Scalar query rewrite could be improved to not generate an extra

[jira] [Updated] (HIVE-21537) Scalar query rewrite could be improved to not generate an extra join if subquery is guaranteed to produce atmost one row

[ https://issues.apache.org/jira/browse/HIVE-21537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21537: --- Status: Patch Available (was: Open) > Scalar query rewrite could be improved to not generate an

[jira] [Updated] (HIVE-21230) LEFT OUTER JOIN does not generate transitive IS NOT NULL filter on right side (HiveJoinAddNotNullRule bails out for outer joins)

[ https://issues.apache.org/jira/browse/HIVE-21230?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21230: --- Status: Open (was: Patch Available) > LEFT OUTER JOIN does not generate transitive IS NOT NULL

[jira] [Updated] (HIVE-21230) LEFT OUTER JOIN does not generate transitive IS NOT NULL filter on right side (HiveJoinAddNotNullRule bails out for outer joins)

[ https://issues.apache.org/jira/browse/HIVE-21230?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21230: --- Attachment: HIVE-21230.8.patch > LEFT OUTER JOIN does not generate transitive IS NOT NULL filter on

[jira] [Updated] (HIVE-21230) LEFT OUTER JOIN does not generate transitive IS NOT NULL filter on right side (HiveJoinAddNotNullRule bails out for outer joins)

[ https://issues.apache.org/jira/browse/HIVE-21230?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21230: --- Status: Patch Available (was: Open) > LEFT OUTER JOIN does not generate transitive IS NOT NULL

[jira] [Updated] (HIVE-21537) Scalar query rewrite could be improved to not generate an extra join if subquery is guaranteed to produce atmost one row

[ https://issues.apache.org/jira/browse/HIVE-21537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21537: --- Status: Open (was: Patch Available) > Scalar query rewrite could be improved to not generate an

[jira] [Updated] (HIVE-21537) Scalar query rewrite could be improved to not generate an extra join if subquery is guaranteed to produce atmost one row

[ https://issues.apache.org/jira/browse/HIVE-21537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21537: --- Status: Patch Available (was: Open) > Scalar query rewrite could be improved to not generate an

[jira] [Updated] (HIVE-21537) Scalar query rewrite could be improved to not generate an extra join if subquery is guaranteed to produce atmost one row

[ https://issues.apache.org/jira/browse/HIVE-21537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21537: --- Attachment: HIVE-21537.4.patch > Scalar query rewrite could be improved to not generate an extra

[jira] [Updated] (HIVE-21230) LEFT OUTER JOIN does not generate transitive IS NOT NULL filter on right side (HiveJoinAddNotNullRule bails out for outer joins)

[ https://issues.apache.org/jira/browse/HIVE-21230?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21230: --- Attachment: HIVE-21230.7.patch > LEFT OUTER JOIN does not generate transitive IS NOT NULL filter on

[jira] [Updated] (HIVE-21230) LEFT OUTER JOIN does not generate transitive IS NOT NULL filter on right side (HiveJoinAddNotNullRule bails out for outer joins)

[ https://issues.apache.org/jira/browse/HIVE-21230?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21230: --- Status: Patch Available (was: Open) > LEFT OUTER JOIN does not generate transitive IS NOT NULL

[jira] [Updated] (HIVE-21230) LEFT OUTER JOIN does not generate transitive IS NOT NULL filter on right side (HiveJoinAddNotNullRule bails out for outer joins)

[ https://issues.apache.org/jira/browse/HIVE-21230?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21230: --- Status: Open (was: Patch Available) > LEFT OUTER JOIN does not generate transitive IS NOT NULL

[jira] [Updated] (HIVE-21537) Scalar query rewrite could be improved to not generate an extra join if subquery is guaranteed to produce atmost one row

[ https://issues.apache.org/jira/browse/HIVE-21537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21537: --- Attachment: HIVE-21537.3.patch > Scalar query rewrite could be improved to not generate an extra

[jira] [Updated] (HIVE-21537) Scalar query rewrite could be improved to not generate an extra join if subquery is guaranteed to produce atmost one row

[ https://issues.apache.org/jira/browse/HIVE-21537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21537: --- Status: Open (was: Patch Available) > Scalar query rewrite could be improved to not generate an

[jira] [Updated] (HIVE-21537) Scalar query rewrite could be improved to not generate an extra join if subquery is guaranteed to produce atmost one row

[ https://issues.apache.org/jira/browse/HIVE-21537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21537: --- Status: Patch Available (was: Open) > Scalar query rewrite could be improved to not generate an

[jira] [Updated] (HIVE-21230) LEFT OUTER JOIN does not generate transitive IS NOT NULL filter on right side (HiveJoinAddNotNullRule bails out for outer joins)

[ https://issues.apache.org/jira/browse/HIVE-21230?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21230: --- Status: Patch Available (was: Open) > LEFT OUTER JOIN does not generate transitive IS NOT NULL

[jira] [Updated] (HIVE-21230) LEFT OUTER JOIN does not generate transitive IS NOT NULL filter on right side (HiveJoinAddNotNullRule bails out for outer joins)

[ https://issues.apache.org/jira/browse/HIVE-21230?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21230: --- Attachment: HIVE-21230.6.patch > LEFT OUTER JOIN does not generate transitive IS NOT NULL filter on

[jira] [Updated] (HIVE-21230) LEFT OUTER JOIN does not generate transitive IS NOT NULL filter on right side (HiveJoinAddNotNullRule bails out for outer joins)

[ https://issues.apache.org/jira/browse/HIVE-21230?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21230: --- Status: Open (was: Patch Available) > LEFT OUTER JOIN does not generate transitive IS NOT NULL

[jira] [Commented] (HIVE-21537) Scalar query rewrite could be improved to not generate an extra join if subquery is guaranteed to produce atmost one row

[ https://issues.apache.org/jira/browse/HIVE-21537?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16805429#comment-16805429 ] Vineet Garg commented on HIVE-21537: [~jcamachorodriguez] Can you take a look?

[jira] [Updated] (HIVE-21537) Scalar query rewrite could be improved to not generate an extra join if subquery is guaranteed to produce atmost one row

[ https://issues.apache.org/jira/browse/HIVE-21537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21537: --- Attachment: HIVE-21537.2.patch > Scalar query rewrite could be improved to not generate an extra

[jira] [Updated] (HIVE-21537) Scalar query rewrite could be improved to not generate an extra join if subquery is guaranteed to produce atmost one row

[ https://issues.apache.org/jira/browse/HIVE-21537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21537: --- Status: Patch Available (was: Open) > Scalar query rewrite could be improved to not generate an

[jira] [Updated] (HIVE-21537) Scalar query rewrite could be improved to not generate an extra join if subquery is guaranteed to produce atmost one row

[ https://issues.apache.org/jira/browse/HIVE-21537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21537: --- Attachment: (was: HIVE-21537.2.patch) > Scalar query rewrite could be improved to not generate

[jira] [Updated] (HIVE-21537) Scalar query rewrite could be improved to not generate an extra join if subquery is guaranteed to produce atmost one row

[ https://issues.apache.org/jira/browse/HIVE-21537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21537: --- Status: Open (was: Patch Available) > Scalar query rewrite could be improved to not generate an

[jira] [Updated] (HIVE-21537) Scalar query rewrite could be improved to not generate an extra join if subquery is guaranteed to produce atmost one row

[ https://issues.apache.org/jira/browse/HIVE-21537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21537: --- Status: Open (was: Patch Available) > Scalar query rewrite could be improved to not generate an

[jira] [Updated] (HIVE-21537) Scalar query rewrite could be improved to not generate an extra join if subquery is guaranteed to produce atmost one row

[ https://issues.apache.org/jira/browse/HIVE-21537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21537: --- Attachment: HIVE-21537.2.patch > Scalar query rewrite could be improved to not generate an extra

[jira] [Updated] (HIVE-21537) Scalar query rewrite could be improved to not generate an extra join if subquery is guaranteed to produce atmost one row

[ https://issues.apache.org/jira/browse/HIVE-21537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21537: --- Status: Patch Available (was: Open) > Scalar query rewrite could be improved to not generate an

[jira] [Commented] (HIVE-21386) Extend the fetch task enhancement done in HIVE-21279 to make it work with query result cache

[ https://issues.apache.org/jira/browse/HIVE-21386?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16805253#comment-16805253 ] Vineet Garg commented on HIVE-21386: Pull request: [https://github.com/apache/hive/pull/582] >

[jira] [Commented] (HIVE-21443) Better usability for SHOW COMPACTIONS

[ https://issues.apache.org/jira/browse/HIVE-21443?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16805248#comment-16805248 ] Vineet Garg commented on HIVE-21443: No problem. I reverted the commit because it was blocking other

[jira] [Reopened] (HIVE-21443) Better usability for SHOW COMPACTIONS

[ https://issues.apache.org/jira/browse/HIVE-21443?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reopened HIVE-21443: Reverted the commit since it is causing test failures. Please make sure to get clean run (green)

[jira] [Assigned] (HIVE-21539) GroupBy + where clause on same column results in incorrect query rewrite

[ https://issues.apache.org/jira/browse/HIVE-21539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-21539: -- Assignee: Vineet Garg > GroupBy + where clause on same column results in incorrect query

[jira] [Updated] (HIVE-21537) Scalar query rewrite could be improved to not generate an extra join if subquery is guaranteed to produce atmost one row

[ https://issues.apache.org/jira/browse/HIVE-21537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21537: --- Status: Patch Available (was: Open) > Scalar query rewrite could be improved to not generate an

[jira] [Updated] (HIVE-21537) Scalar query rewrite could be improved to not generate an extra join if subquery is guaranteed to produce atmost one row

[ https://issues.apache.org/jira/browse/HIVE-21537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21537: --- Attachment: HIVE-21537.1.patch > Scalar query rewrite could be improved to not generate an extra

[jira] [Commented] (HIVE-21231) HiveJoinAddNotNullRule support for range predicates

[ https://issues.apache.org/jira/browse/HIVE-21231?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16804381#comment-16804381 ] Vineet Garg commented on HIVE-21231: There is a query in subquery_scalar (and query44) which has an

[jira] [Assigned] (HIVE-21537) Scalar query rewrite could be improved to not generate an extra join if subquery is guaranteed to produce atmost one row

[ https://issues.apache.org/jira/browse/HIVE-21537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-21537: -- > Scalar query rewrite could be improved to not generate an extra join if > subquery is

[jira] [Updated] (HIVE-21537) Scalar query rewrite could be improved to not generate an extra join if subquery is guaranteed to produce atmost one row

[ https://issues.apache.org/jira/browse/HIVE-21537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-21537: --- Labels: sub-query (was: ) > Scalar query rewrite could be improved to not generate an extra join if

[jira] [Commented] (HIVE-21231) HiveJoinAddNotNullRule support for range predicates

[ https://issues.apache.org/jira/browse/HIVE-21231?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16804282#comment-16804282 ] Vineet Garg commented on HIVE-21231: Code changes look good to me but I notice plan changes in

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