[jira] [Assigned] (HIVE-24638) Redundant filter in scalar subquery

2021-01-14 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24638?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-24638: -- Assignee: Vineet Garg > Redundant filter in scalar subquery >

[jira] [Commented] (HIVE-24638) Redundant filter in scalar subquery

2021-01-14 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24638?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17265608#comment-17265608 ] Vineet Garg commented on HIVE-24638: [~jcamachorodriguez] Other idea was to replace this filter with

[jira] [Commented] (HIVE-23684) Large underestimation in NDV stats when input and join cardinality ratio is big

2021-01-13 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23684?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17264247#comment-17264247 ] Vineet Garg commented on HIVE-23684: Merged the pull request into master. > Large underestimation in

[jira] [Resolved] (HIVE-23684) Large underestimation in NDV stats when input and join cardinality ratio is big

2021-01-13 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23684?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg resolved HIVE-23684. Fix Version/s: 4.0.0 Resolution: Fixed > Large underestimation in NDV stats when input and

[jira] [Assigned] (HIVE-23684) Large underestimation in NDV stats when input and join cardinality ratio is big

2021-01-13 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23684?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-23684: -- Assignee: Vineet Garg (was: Stamatis Zampetakis) > Large underestimation in NDV stats when

[jira] [Commented] (HIVE-24296) NDV adjusted twice causing reducer task underestimation

2020-11-09 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24296?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17228804#comment-17228804 ] Vineet Garg commented on HIVE-24296: bq. It would be good to remove static readjustment in

[jira] [Resolved] (HIVE-24304) Query containing UNION fails with OOM

2020-10-23 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24304?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg resolved HIVE-24304. Fix Version/s: 4.0.0 Resolution: Fixed Pushed to master. > Query containing UNION fails

[jira] [Assigned] (HIVE-24304) Query containing UNION fails with OOM

2020-10-22 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24304?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-24304: -- > Query containing UNION fails with OOM > - > >

[jira] [Commented] (HIVE-24255) StorageHandler with select-limit query is returning 0 rows

2020-10-13 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24255?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17213209#comment-17213209 ] Vineet Garg commented on HIVE-24255: Merged the pull request to upstream master. Thanks [~nareshpr]

[jira] [Resolved] (HIVE-24255) StorageHandler with select-limit query is returning 0 rows

2020-10-13 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24255?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg resolved HIVE-24255. Fix Version/s: 4.0.0 Resolution: Fixed > StorageHandler with select-limit query is

[jira] [Resolved] (HIVE-24210) PartitionManagementTask fails if one of tables dropped after fetching TableMeta

2020-10-02 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24210?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg resolved HIVE-24210. Fix Version/s: 4.0.0 Resolution: Fixed Pushed to master. Thanks [~nareshpr] >

[jira] [Commented] (HIVE-24210) PartitionManagementTask fails if one of tables dropped after fetching TableMeta

2020-10-02 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24210?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17206302#comment-17206302 ] Vineet Garg commented on HIVE-24210: +1. LGTM > PartitionManagementTask fails if one of tables

[jira] [Commented] (HIVE-24183) Clean up local HS2 HMS cache code

2020-09-23 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24183?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17201020#comment-17201020 ] Vineet Garg commented on HIVE-24183: +1 > Clean up local HS2 HMS cache code >

[jira] [Resolved] (HIVE-24009) Support partition pruning and other physical transformations for EXECUTE statement

2020-09-23 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24009?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg resolved HIVE-24009. Fix Version/s: 4.0.0 Resolution: Fixed > Support partition pruning and other physical

[jira] [Updated] (HIVE-24005) Reduce memory footprint of cached plan

2020-09-23 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-24005: --- Description: Currently whole {{SemanticAnalyzer}} object is cached. It is not necessary to cache

[jira] [Commented] (HIVE-24147) Table column names are not extracted correctly in Hive JDBC storage handler

2020-09-18 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24147?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17198564#comment-17198564 ] Vineet Garg commented on HIVE-24147: +1 > Table column names are not extracted correctly in Hive

[jira] [Commented] (HIVE-24144) getIdentifierQuoteString in HiveDatabaseMetaData returns incorrect value

2020-09-18 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17198565#comment-17198565 ] Vineet Garg commented on HIVE-24144: +1 > getIdentifierQuoteString in HiveDatabaseMetaData returns

[jira] [Resolved] (HIVE-23454) Querying hive table which has Materialized view fails with HiveAccessControlException

2020-09-15 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg resolved HIVE-23454. Fix Version/s: 4.0.0 Resolution: Fixed > Querying hive table which has Materialized view

[jira] [Assigned] (HIVE-24164) Throw error for parameterized query containing parameters in group by

2020-09-14 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24164?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-24164: -- > Throw error for parameterized query containing parameters in group by >

[jira] [Updated] (HIVE-24009) Support partition pruning and other physical transformations for EXECUTE statement

2020-09-14 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24009?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-24009: --- Summary: Support partition pruning and other physical transformations for EXECUTE statement (was:

[jira] [Commented] (HIVE-24143) Include convention in JDBC converter operator in Calcite plan

2020-09-11 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24143?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17194550#comment-17194550 ] Vineet Garg commented on HIVE-24143: +1 > Include convention in JDBC converter operator in Calcite

[jira] [Assigned] (HIVE-23454) Querying hive table which has Materialized view fails with HiveAccessControlException

2020-09-04 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-23454: -- Assignee: Vineet Garg (was: Nishant Goel) > Querying hive table which has Materialized view

[jira] [Commented] (HIVE-23454) Querying hive table which has Materialized view fails with HiveAccessControlException

2020-09-02 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17189573#comment-17189573 ] Vineet Garg commented on HIVE-23454: [~nisgoel] Are you working on this? If you aren't I would like

[jira] [Resolved] (HIVE-24087) FK side join elimination in presence of PK-FK constraint

2020-09-01 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24087?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg resolved HIVE-24087. Fix Version/s: 4.0.0 Resolution: Fixed > FK side join elimination in presence of PK-FK

[jira] [Assigned] (HIVE-24087) FK side join elimination in presence of PK-FK constraint

2020-08-27 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24087?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-24087: -- > FK side join elimination in presence of PK-FK constraint >

[jira] [Commented] (HIVE-24012) Support for rewriting with materialized views containing grouping sets

2020-08-07 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17173468#comment-17173468 ] Vineet Garg commented on HIVE-24012: Left a minor comment. +1. > Support for rewriting with

[jira] [Updated] (HIVE-24002) Allow 'expressions' instead of 'constant literal' for EXECUTE

2020-08-06 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-24002: --- Labels: (was: pull-request-available) > Allow 'expressions' instead of 'constant literal' for

[jira] [Resolved] (HIVE-23951) Support parameterized queries in WHERE/HAVING clause

2020-08-06 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23951?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg resolved HIVE-23951. Resolution: Fixed Merged the pull request. Thanks for reviewing [~jcamachorodriguez] > Support

[jira] [Assigned] (HIVE-24010) Support physical transformations for EXECUTE statement

2020-08-06 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24010?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-24010: -- > Support physical transformations for EXECUTE statement >

[jira] [Assigned] (HIVE-24009) Support partition pruning for EXECUTE statement

2020-08-06 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24009?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-24009: -- > Support partition pruning for EXECUTE statement >

[jira] [Assigned] (HIVE-24008) Improve Explain plan output for EXECUTE queries

2020-08-06 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24008?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-24008: -- > Improve Explain plan output for EXECUTE queries >

[jira] [Assigned] (HIVE-24007) Support for EXECUTE/PREPARE operation authorization

2020-08-06 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24007?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-24007: -- > Support for EXECUTE/PREPARE operation authorization >

[jira] [Updated] (HIVE-24006) Support dynamic expressions/params in SELECT clause

2020-08-06 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24006?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-24006: --- Description: Currently it is only supported in WHERE/HAVING clause (HIVE-23951)   One of the

[jira] [Assigned] (HIVE-24006) Support dynamic expressions/params in SELECT clause

2020-08-06 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24006?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-24006: -- > Support dynamic expressions/params in SELECT clause >

[jira] [Assigned] (HIVE-24005) Reduce memory footprint of cached plan

2020-08-06 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-24005: -- > Reduce memory footprint of cached plan > -- > >

[jira] [Assigned] (HIVE-24003) Stats annotation/collection for EXECUTE statements

2020-08-06 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24003?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-24003: -- > Stats annotation/collection for EXECUTE statements >

[jira] [Assigned] (HIVE-24002) Allow 'expressions' instead of 'constant literal' for EXECUTE

2020-08-06 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-24002: -- > Allow 'expressions' instead of 'constant literal' for EXECUTE >

[jira] [Updated] (HIVE-23978) Enable logging with PerfLogger in HMS client

2020-08-03 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23978?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-23978: --- Issue Type: Improvement (was: New Feature) > Enable logging with PerfLogger in HMS client >

[jira] [Updated] (HIVE-23950) [Umbrella] Support PREPARE and EXECUTE statements

2020-07-29 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23950?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-23950: --- Description: PREPARE and EXECUTE statements provide an ability to create a parameterized query and

[jira] [Updated] (HIVE-23950) [Umbrella]Support PREPARE and EXECUTE statements

2020-07-29 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23950?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-23950: --- Summary: [Umbrella]Support PREPARE and EXECUTE statements (was: Support PREPARE and EXECUTE

[jira] [Updated] (HIVE-23950) [Umbrella] Support PREPARE and EXECUTE statements

2020-07-29 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23950?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-23950: --- Summary: [Umbrella] Support PREPARE and EXECUTE statements (was: [Umbrella]Support PREPARE and

[jira] [Updated] (HIVE-23950) Support PREPARE and EXECUTE statements

2020-07-29 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23950?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-23950: --- Description: PREPARE and EXECUTE statements provide an ability to create a parameterized query and

[jira] [Updated] (HIVE-23950) Support PREPARE and EXECUTE statements

2020-07-29 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23950?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-23950: --- Description: PREPARE and EXECUTE statements provide an ability to create a parameterized query and

[jira] [Assigned] (HIVE-23951) Support parameterized queries in WHERE/HAVING clause

2020-07-29 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23951?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-23951: -- > Support parameterized queries in WHERE/HAVING clause >

[jira] [Assigned] (HIVE-23950) Support PREPARE and EXECUTE statements

2020-07-29 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23950?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-23950: -- > Support PREPARE and EXECUTE statements > -- > >

[jira] [Commented] (HIVE-23878) Aggregate after join throws off MV rewrite

2020-07-23 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23878?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17163955#comment-17163955 ] Vineet Garg commented on HIVE-23878: +1. Super creative solution (y) > Aggregate after join throws

[jira] [Updated] (HIVE-23807) Wrong results with vectorization enabled

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

[jira] [Resolved] (HIVE-23822) Sorted dynamic partition optimization could remove auto stat task

2020-07-14 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23822?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg resolved HIVE-23822. Fix Version/s: 4.0.0 Resolution: Fixed > Sorted dynamic partition optimization could remove

[jira] [Updated] (HIVE-23807) Wrong results with vectorization enabled

2020-07-14 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23807?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-23807: --- Status: Patch Available (was: Open) Pushed to branch-2, Thanks for taking a look

[jira] [Commented] (HIVE-23807) Wrong results with vectorization enabled

2020-07-13 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23807?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17156960#comment-17156960 ] Vineet Garg commented on HIVE-23807: [~jcamachorodriguez] Can you take a look at the request (#1234).

[jira] [Commented] (HIVE-22782) Consolidate metastore call to fetch constraints

2020-07-13 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17156806#comment-17156806 ] Vineet Garg commented on HIVE-22782: [~ashish-kumar-sharma] Thanks for volunteering. I have assigned

[jira] [Assigned] (HIVE-22782) Consolidate metastore call to fetch constraints

2020-07-13 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-22782: -- Assignee: Ashish Sharma (was: Vineet Garg) > Consolidate metastore call to fetch constraints

[jira] [Assigned] (HIVE-23822) Sorted dynamic partition optimization could remove auto stat task

2020-07-08 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23822?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-23822: -- > Sorted dynamic partition optimization could remove auto stat task >

[jira] [Updated] (HIVE-23807) Wrong results with vectorization enabled

2020-07-06 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23807?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-23807: --- Description: *Repro* {code:sql} CREATE TABLE `test13`( `portfolio_valuation_date` string,

[jira] [Assigned] (HIVE-23807) Wrong results with vectorization enabled

2020-07-06 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23807?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-23807: -- > Wrong results with vectorization enabled > > >

[jira] [Assigned] (HIVE-19545) Enable TestCliDriver#fouter_join_ppr.q

2020-06-10 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-19545?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-19545: -- Assignee: Vineet Garg > Enable TestCliDriver#fouter_join_ppr.q >

[jira] [Commented] (HIVE-14594) CBO: Calcite Operator To Hive Operator(Calcite Return Path): Fix wrong result in join_filters_overlap

2020-05-04 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-14594?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17099296#comment-17099296 ] Vineet Garg commented on HIVE-14594: Actually CALCITE issue is added as related so I guess we can

[jira] [Commented] (HIVE-14594) CBO: Calcite Operator To Hive Operator(Calcite Return Path): Fix wrong result in join_filters_overlap

2020-05-04 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-14594?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17099295#comment-17099295 ] Vineet Garg commented on HIVE-14594: [~zabetak] I just re-ran this test and I see the the query is

[jira] [Commented] (HIVE-22256) Rewriting fails when `IN` clause has items in different order in MV and query.

2020-05-04 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22256?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17099291#comment-17099291 ] Vineet Garg commented on HIVE-22256: +1 > Rewriting fails when `IN` clause has items in different

[jira] [Updated] (HIVE-23206) Project not defined correctly after reordering a join

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

[jira] [Commented] (HIVE-23206) Project not defined correctly after reordering a join

2020-05-04 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23206?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17099276#comment-17099276 ] Vineet Garg commented on HIVE-23206: +1 > Project not defined correctly after reordering a join >

[jira] [Commented] (HIVE-23206) Project not defined correctly after reordering a join

2020-05-01 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23206?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17097565#comment-17097565 ] Vineet Garg commented on HIVE-23206: [~kkasa] So only concern left to address is why shared optimizer

[jira] [Updated] (HIVE-23319) multi_insert_partitioned is flaky

2020-04-30 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23319?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-23319: --- Fix Version/s: 4.0.0 Assignee: Vineet Garg Resolution: Fixed Status:

[jira] [Commented] (HIVE-23319) multi_insert_partitioned is flaky

2020-04-30 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23319?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17096999#comment-17096999 ] Vineet Garg commented on HIVE-23319: [~kgyrtkirk] [~jcamachorodriguez] can you take a look? >

[jira] [Commented] (HIVE-23319) multi_insert_partitioned is flaky

2020-04-29 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23319?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17095578#comment-17095578 ] Vineet Garg commented on HIVE-23319: [~kgyrtkirk] I have added the SORT_QUERY_RESULTS to the test

[jira] [Updated] (HIVE-23319) multi_insert_partitioned is flaky

2020-04-29 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23319?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-23319: --- Attachment: HIVE-23319.1.patch > multi_insert_partitioned is flaky >

[jira] [Updated] (HIVE-23319) multi_insert_partitioned is flaky

2020-04-29 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23319?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-23319: --- Status: Patch Available (was: Open) > multi_insert_partitioned is flaky >

[jira] [Commented] (HIVE-23319) multi_insert_partitioned is flaky

2020-04-29 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23319?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17095495#comment-17095495 ] Vineet Garg commented on HIVE-23319: [~kgyrtkirk] It could be due to HIVE-23216. Will the fix for

[jira] [Commented] (HIVE-23216) Add new api as replacement of get_partitions_by_expr to return PartitionSpec instead of Partitions

2020-04-29 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23216?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17095492#comment-17095492 ] Vineet Garg commented on HIVE-23216: [~kgyrtkirk] I apologize for causing tests to be flaky. I was

[jira] [Updated] (HIVE-23216) Add new api as replacement of get_partitions_by_expr to return PartitionSpec instead of Partitions

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

[jira] [Commented] (HIVE-23206) Project not defined correctly after reordering a join

2020-04-27 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23206?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17093784#comment-17093784 ] Vineet Garg commented on HIVE-23206: Left comments on the review board. > Project not defined

[jira] [Updated] (HIVE-23216) Add new api as replacement of get_partitions_by_expr to return PartitionSpec instead of Partitions

2020-04-27 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-23216: --- Status: Patch Available (was: Open) > Add new api as replacement of get_partitions_by_expr to

[jira] [Commented] (HIVE-23291) Add Hive to DatabaseType in JDBC storage handler

2020-04-26 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23291?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17092827#comment-17092827 ] Vineet Garg commented on HIVE-23291: [~jcamachorodriguez] Makes sense. +1. > Add Hive to

[jira] [Updated] (HIVE-23216) Add new api as replacement of get_partitions_by_expr to return PartitionSpec instead of Partitions

2020-04-26 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-23216: --- Status: Open (was: Patch Available) > Add new api as replacement of get_partitions_by_expr to

[jira] [Updated] (HIVE-23216) Add new api as replacement of get_partitions_by_expr to return PartitionSpec instead of Partitions

2020-04-26 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-23216: --- Attachment: HIVE-23216.9.patch > Add new api as replacement of get_partitions_by_expr to return

[jira] [Commented] (HIVE-23216) Add new api as replacement of get_partitions_by_expr to return PartitionSpec instead of Partitions

2020-04-26 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23216?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17092813#comment-17092813 ] Vineet Garg commented on HIVE-23216: Latest patch (#8) address review comment to enable client side

[jira] [Updated] (HIVE-23216) Add new api as replacement of get_partitions_by_expr to return PartitionSpec instead of Partitions

2020-04-26 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-23216: --- Attachment: HIVE-23216.8.patch > Add new api as replacement of get_partitions_by_expr to return

[jira] [Updated] (HIVE-23216) Add new api as replacement of get_partitions_by_expr to return PartitionSpec instead of Partitions

2020-04-26 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-23216: --- Status: Open (was: Patch Available) > Add new api as replacement of get_partitions_by_expr to

[jira] [Updated] (HIVE-23216) Add new api as replacement of get_partitions_by_expr to return PartitionSpec instead of Partitions

2020-04-26 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-23216: --- Status: Patch Available (was: Open) > Add new api as replacement of get_partitions_by_expr to

[jira] [Commented] (HIVE-23291) Add Hive to DatabaseType in JDBC storage handler

2020-04-26 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23291?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17092812#comment-17092812 ] Vineet Garg commented on HIVE-23291: One question regarding this change - with this change Hive will

[jira] [Updated] (HIVE-23216) Add new api as replacement of get_partitions_by_expr to return PartitionSpec instead of Partitions

2020-04-24 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-23216: --- Attachment: HIVE-23216.7.patch > Add new api as replacement of get_partitions_by_expr to return

[jira] [Updated] (HIVE-23216) Add new api as replacement of get_partitions_by_expr to return PartitionSpec instead of Partitions

2020-04-24 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-23216: --- Status: Patch Available (was: Open) > Add new api as replacement of get_partitions_by_expr to

[jira] [Updated] (HIVE-23216) Add new api as replacement of get_partitions_by_expr to return PartitionSpec instead of Partitions

2020-04-24 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-23216: --- Status: Open (was: Patch Available) > Add new api as replacement of get_partitions_by_expr to

[jira] [Updated] (HIVE-23216) Add new api as replacement of get_partitions_by_expr to return PartitionSpec instead of Partitions

2020-04-23 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-23216: --- Status: Patch Available (was: Open) > Add new api as replacement of get_partitions_by_expr to

[jira] [Updated] (HIVE-23216) Add new api as replacement of get_partitions_by_expr to return PartitionSpec instead of Partitions

2020-04-23 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-23216: --- Status: Open (was: Patch Available) > Add new api as replacement of get_partitions_by_expr to

[jira] [Updated] (HIVE-23216) Add new api as replacement of get_partitions_by_expr to return PartitionSpec instead of Partitions

2020-04-23 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-23216: --- Attachment: HIVE-23216.6.patch > Add new api as replacement of get_partitions_by_expr to return

[jira] [Commented] (HIVE-23216) Add new api as replacement of get_partitions_by_expr to return PartitionSpec instead of Partitions

2020-04-22 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23216?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17089998#comment-17089998 ] Vineet Garg commented on HIVE-23216: bq. Under what circumstances is hasUnknownPartitions=true ?

[jira] [Commented] (HIVE-23264) Make partition_wise_fileformat12.q deterministic with order by clauses

2020-04-22 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23264?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17089927#comment-17089927 ] Vineet Garg commented on HIVE-23264: SORT_QUERY_RESULTS doesn't sort globally, it sorts result per

[jira] [Commented] (HIVE-23264) Make partition_wise_fileformat12.q deterministic with order by clauses

2020-04-22 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23264?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17089894#comment-17089894 ] Vineet Garg commented on HIVE-23264: bq. I see your point, on the other hand a {{--

[jira] [Commented] (HIVE-23216) Add new api as replacement of get_partitions_by_expr to return PartitionSpec instead of Partitions

2020-04-22 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23216?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17089879#comment-17089879 ] Vineet Garg commented on HIVE-23216: Pull request -> https://github.com/apache/hive/pull/990 > Add

[jira] [Commented] (HIVE-23216) Add new api as replacement of get_partitions_by_expr to return PartitionSpec instead of Partitions

2020-04-22 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23216?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17089878#comment-17089878 ] Vineet Garg commented on HIVE-23216: [~jcamachorodriguez] [~thejas] can you take a look? > Add new

[jira] [Updated] (HIVE-23216) Add new api as replacement of get_partitions_by_expr to return PartitionSpec instead of Partitions

2020-04-22 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-23216: --- Status: Patch Available (was: Open) > Add new api as replacement of get_partitions_by_expr to

[jira] [Updated] (HIVE-23216) Add new api as replacement of get_partitions_by_expr to return PartitionSpec instead of Partitions

2020-04-22 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-23216: --- Status: Open (was: Patch Available) > Add new api as replacement of get_partitions_by_expr to

[jira] [Updated] (HIVE-23216) Add new api as replacement of get_partitions_by_expr to return PartitionSpec instead of Partitions

2020-04-22 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-23216: --- Attachment: HIVE-23216.5.patch > Add new api as replacement of get_partitions_by_expr to return

[jira] [Commented] (HIVE-23264) Make partition_wise_fileformat12.q deterministic with order by clauses

2020-04-22 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23264?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17089847#comment-17089847 ] Vineet Garg commented on HIVE-23264: Depending upon the test ORDER BY (or any change in the query)

[jira] [Commented] (HIVE-23264) Make partition_wise_fileformat12.q deterministic with order by clauses

2020-04-22 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23264?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17089790#comment-17089790 ] Vineet Garg commented on HIVE-23264: I think adding {{-- SORT_QUERY_RESULTS}} in q file is better

[jira] [Updated] (HIVE-23216) Add new api as replacement of get_partitions_by_expr to return PartitionSpec instead of Partitions

2020-04-21 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-23216: --- Status: Patch Available (was: Open) > Add new api as replacement of get_partitions_by_expr to

[jira] [Updated] (HIVE-23216) Add new api as replacement of get_partitions_by_expr to return PartitionSpec instead of Partitions

2020-04-21 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-23216: --- Attachment: HIVE-23216.4.patch > Add new api as replacement of get_partitions_by_expr to return

[jira] [Updated] (HIVE-23216) Add new api as replacement of get_partitions_by_expr to return PartitionSpec instead of Partitions

2020-04-21 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-23216: --- Status: Open (was: Patch Available) > Add new api as replacement of get_partitions_by_expr to

[jira] [Updated] (HIVE-23216) Add new api as replacement of get_partitions_by_expr to return PartitionSpec instead of Partitions

2020-04-20 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/HIVE-23216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-23216: --- Status: Patch Available (was: Open) > Add new api as replacement of get_partitions_by_expr to

  1   2   3   4   5   6   7   8   9   10   >