[jira] [Updated] (HIVE-16605) Enforce NOT NULL constraints

2018-02-03 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16605?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-16605: --- Attachment: HIVE-16605.4.patch > Enforce NOT NULL constraints > > >

[jira] [Updated] (HIVE-16605) Enforce NOT NULL constraints

2018-02-03 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16605?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-16605: --- Status: Patch Available (was: Open) > Enforce NOT NULL constraints > >

[jira] [Updated] (HIVE-18598) Disallow NOT NULL constraints to be ENABLED/ENFORCED with EXTERNAL table

2018-02-03 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18598?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18598: --- Attachment: HIVE-18598.2.patch > Disallow NOT NULL constraints to be ENABLED/ENFORCED with EXTERNAL

[jira] [Updated] (HIVE-18598) Disallow NOT NULL constraints to be ENABLED/ENFORCED with EXTERNAL table

2018-02-03 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18598?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18598: --- Status: Open (was: Patch Available) > Disallow NOT NULL constraints to be ENABLED/ENFORCED with

[jira] [Updated] (HIVE-18598) Disallow NOT NULL constraints to be ENABLED/ENFORCED with EXTERNAL table

2018-02-03 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18598?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18598: --- Status: Patch Available (was: Open) > Disallow NOT NULL constraints to be ENABLED/ENFORCED with

[jira] [Updated] (HIVE-18598) Disallow NOT NULL constraints to be ENABLED/ENFORCED with EXTERNAL table

2018-02-03 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18598?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18598: --- Description: HIVE-16605 is enabling/enforcing NOT NULL constraint. But since Hive do not manage the

[jira] [Updated] (HIVE-18598) Disallow NOT NULL constraints to be ENABLED/ENFORCED with EXTERNAL table

2018-02-03 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18598?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18598: --- Attachment: (was: HIVE-18598.2.patch) > Disallow NOT NULL constraints to be ENABLED/ENFORCED with

[jira] [Updated] (HIVE-16605) Enforce NOT NULL constraints

2018-02-03 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16605?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-16605: --- Attachment: (was: HIVE-16605.4.patch) > Enforce NOT NULL constraints >

[jira] [Updated] (HIVE-16605) Enforce NOT NULL constraints

2018-02-03 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16605?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-16605: --- Status: Open (was: Patch Available) > Enforce NOT NULL constraints > >

[jira] [Updated] (HIVE-18598) Disallow NOT NULL constraints to be ENABLED/ENFORCED with EXTERNAL table

2018-02-03 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18598?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18598: --- Status: Open (was: Patch Available) > Disallow NOT NULL constraints to be ENABLED/ENFORCED with

[jira] [Commented] (HIVE-16605) Enforce NOT NULL constraints

2018-02-05 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16605?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16353024#comment-16353024 ] Vineet Garg commented on HIVE-16605: [~ashutoshc] Failures are unrelated. [~ekoifman] This wasn't

[jira] [Updated] (HIVE-18598) Disallow NOT NULL constraints to be ENABLED/ENFORCED with EXTERNAL table

2018-02-12 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18598?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18598: --- Status: Open (was: Patch Available) > Disallow NOT NULL constraints to be ENABLED/ENFORCED with

[jira] [Updated] (HIVE-18598) Disallow NOT NULL constraints to be ENABLED/ENFORCED with EXTERNAL table

2018-02-12 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18598?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18598: --- Status: Patch Available (was: Open) Rebased patch > Disallow NOT NULL constraints to be

[jira] [Updated] (HIVE-18598) Disallow NOT NULL constraints to be ENABLED/ENFORCED with EXTERNAL table

2018-02-12 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18598?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18598: --- Attachment: HIVE-18598.4.patch > Disallow NOT NULL constraints to be ENABLED/ENFORCED with EXTERNAL

[jira] [Updated] (HIVE-18598) Disallow NOT NULL constraints to be ENABLED/ENFORCED with EXTERNAL table

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

[jira] [Commented] (HIVE-18713) Optimize: Transform IN clauses to = when there's only one element

2018-02-14 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18713?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16364712#comment-16364712 ] Vineet Garg commented on HIVE-18713: [~gopalv] Just a minor nitpick - cbo_rp_simple_select contains

[jira] [Updated] (HIVE-16689) Correlated scalar subquery with comparison to constant in predicate fails

2018-02-14 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16689?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-16689: --- Fix Version/s: 3.0.0 > Correlated scalar subquery with comparison to constant in predicate fails >

[jira] [Updated] (HIVE-16605) Enforce NOT NULL constraints

2018-02-14 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16605?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-16605: --- Fix Version/s: 3.0.0 > Enforce NOT NULL constraints > > >

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

2018-02-14 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: --- Fix Version/s: 3.0.0 > CBO wrongly type cast decimal literal to int >

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

2018-02-14 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17726: --- Fix Version/s: 3.0.0 > Using exists may lead to incorrect results >

[jira] [Updated] (HIVE-17400) Estimate stats in absence of stats for complex types

2018-02-14 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17400: --- Fix Version/s: 3.0.0 > Estimate stats in absence of stats for complex types >

[jira] [Updated] (HIVE-18272) Fix check-style violations in subquery code

2018-02-14 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18272: --- Fix Version/s: 3.0.0 > Fix check-style violations in subquery code >

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

2018-02-14 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: --- Fix Version/s: 3.0.0 > CBO looses inner casts on constants of complex type >

[jira] [Updated] (HIVE-18173) Improve plans for correlated subqueries with non-equi predicate

2018-02-14 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18173?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18173: --- Fix Version/s: 3.0.0 > Improve plans for correlated subqueries with non-equi predicate >

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

2018-02-14 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-17767?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-17767: --- Fix Version/s: 3.0.0 > Rewrite correlated EXISTS/IN subqueries into LEFT SEMI JOIN >

[jira] [Commented] (HIVE-18713) Optimize: Transform IN clauses to = when there's only one element

2018-02-14 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18713?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16364593#comment-16364593 ] Vineet Garg commented on HIVE-18713: Can we add a test? Otherwise looks good to me.  +1 pending tests.

[jira] [Updated] (HIVE-18241) Query with LEFT SEMI JOIN producing wrong result

2018-02-14 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18241?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18241: --- Fix Version/s: 3.0.0 > Query with LEFT SEMI JOIN producing wrong result >

[jira] [Updated] (HIVE-18008) Add optimization rule to remove gby from right side of left semi-join

2018-02-14 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18008?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18008: --- Fix Version/s: 3.0.0 > Add optimization rule to remove gby from right side of left semi-join >

[jira] [Updated] (HIVE-18726) Implement DEFAULT constraint

2018-02-18 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18726: --- Status: Patch Available (was: Open) > Implement DEFAULT constraint > >

[jira] [Updated] (HIVE-18726) Implement DEFAULT constraint

2018-02-18 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18726: --- Attachment: HIVE-18726.2.patch > Implement DEFAULT constraint > > >

[jira] [Updated] (HIVE-18726) Implement DEFAULT constraint

2018-02-18 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18726: --- Status: Open (was: Patch Available) > Implement DEFAULT constraint > >

[jira] [Commented] (HIVE-18725) Improve error handling for subqueries if there is wrong column reference

2018-02-22 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16373231#comment-16373231 ] Vineet Garg commented on HIVE-18725: [~vbeshka] This exception is misleading because Hive supports

[jira] [Assigned] (HIVE-18775) HIVE-17983 missed deleting metastore/scripts/upgrade/derby/hive-schema-3.0.0.derby.sql

2018-02-22 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18775?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-18775: -- > HIVE-17983 missed deleting > metastore/scripts/upgrade/derby/hive-schema-3.0.0.derby.sql >

[jira] [Commented] (HIVE-18775) HIVE-17983 missed deleting metastore/scripts/upgrade/derby/hive-schema-3.0.0.derby.sql

2018-02-22 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18775?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16373481#comment-16373481 ] Vineet Garg commented on HIVE-18775: cc [~alangates] > HIVE-17983 missed deleting >

[jira] [Updated] (HIVE-18775) HIVE-17983 missed deleting metastore/scripts/upgrade/derby/hive-schema-3.0.0.derby.sql

2018-02-22 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18775?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18775: --- Description: HIVE-17983 moved hive metastore schema sql files for all databases but derby to

[jira] [Commented] (HIVE-18775) HIVE-17983 missed deleting metastore/scripts/upgrade/derby/hive-schema-3.0.0.derby.sql

2018-02-22 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18775?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16373525#comment-16373525 ] Vineet Garg commented on HIVE-18775: Looks like

[jira] [Commented] (HIVE-18726) Implement DEFAULT constraint

2018-02-23 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18726?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16375048#comment-16375048 ] Vineet Garg commented on HIVE-18726: Thanks [~daijy]. I'll open a separate ticket. > Implement

[jira] [Updated] (HIVE-18775) HIVE-17983 missed deleting metastore/scripts/upgrade/derby/hive-schema-3.0.0.derby.sql

2018-02-23 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18775?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18775: --- Status: Patch Available (was: Open) > HIVE-17983 missed deleting >

[jira] [Updated] (HIVE-18775) HIVE-17983 missed deleting metastore/scripts/upgrade/derby/hive-schema-3.0.0.derby.sql

2018-02-23 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18775?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18775: --- Attachment: HIVE-18775.2.patch > HIVE-17983 missed deleting >

[jira] [Updated] (HIVE-18775) HIVE-17983 missed deleting metastore/scripts/upgrade/derby/hive-schema-3.0.0.derby.sql

2018-02-23 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18775?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18775: --- Status: Open (was: Patch Available) > HIVE-17983 missed deleting >

[jira] [Updated] (HIVE-18726) Implement DEFAULT constraint

2018-02-23 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18726: --- Status: Patch Available (was: Open) Patch(3) adds the following: * Metastore changes for all

[jira] [Comment Edited] (HIVE-18726) Implement DEFAULT constraint

2018-02-23 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18726?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16375000#comment-16375000 ] Vineet Garg edited comment on HIVE-18726 at 2/23/18 9:50 PM: - Patch(3) adds

[jira] [Comment Edited] (HIVE-18726) Implement DEFAULT constraint

2018-02-23 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18726?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16375009#comment-16375009 ] Vineet Garg edited comment on HIVE-18726 at 2/23/18 10:00 PM: -- This patch is

[jira] [Commented] (HIVE-18726) Implement DEFAULT constraint

2018-02-23 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18726?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16375009#comment-16375009 ] Vineet Garg commented on HIVE-18726: This patch is still missing event handling for Replication.

[jira] [Updated] (HIVE-18726) Implement DEFAULT constraint

2018-02-23 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18726: --- Status: Open (was: Patch Available) > Implement DEFAULT constraint > >

[jira] [Updated] (HIVE-18726) Implement DEFAULT constraint

2018-02-23 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18726: --- Attachment: HIVE-18726.3.patch > Implement DEFAULT constraint > > >

[jira] [Updated] (HIVE-18724) Improve error handling for subqueries referencing columns(correlated) of it's grand-parent query

2018-02-15 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18724?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18724: --- Description: Currently Hive doesn't allow correlated subqueries which refer to columns of grand

[jira] [Assigned] (HIVE-18726) Implement DEFAULT constraint

2018-02-15 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-18726: -- > Implement DEFAULT constraint > > > Key: HIVE-18726

[jira] [Updated] (HIVE-18724) Improve error handling for subqueries referencing columns(correlated) of its grand-parent query

2018-02-15 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18724?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18724: --- Summary: Improve error handling for subqueries referencing columns(correlated) of its grand-parent

[jira] [Updated] (HIVE-18775) HIVE-17983 missed deleting metastore/scripts/upgrade/derby/hive-schema-3.0.0.derby.sql

2018-02-22 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18775?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18775: --- Status: Patch Available (was: Open) Ran metastore tests (all plus integration). There are only two

[jira] [Updated] (HIVE-18775) HIVE-17983 missed deleting metastore/scripts/upgrade/derby/hive-schema-3.0.0.derby.sql

2018-02-22 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18775?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18775: --- Attachment: HIVE-18775.1.patch > HIVE-17983 missed deleting >

[jira] [Commented] (HIVE-18775) HIVE-17983 missed deleting metastore/scripts/upgrade/derby/hive-schema-3.0.0.derby.sql

2018-02-22 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18775?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16373898#comment-16373898 ] Vineet Garg commented on HIVE-18775: [~alangates] Can you take a look at the patch? > HIVE-17983

[jira] [Commented] (HIVE-18713) Optimize: Transform IN clauses to = when there's only one element

2018-02-16 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18713?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16368002#comment-16368002 ] Vineet Garg commented on HIVE-18713: Just curious about your latest change in the patch - this

[jira] [Assigned] (HIVE-18727) Update GenericUDFEnforceNotNullConstraint to throw an ERROR instead of Exception on failure

2018-02-15 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18727?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-18727: -- > Update GenericUDFEnforceNotNullConstraint to throw an ERROR instead of > Exception on failure >

[jira] [Updated] (HIVE-18726) Implement DEFAULT constraint

2018-02-15 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18726: --- Attachment: HIVE-18726.1.patch > Implement DEFAULT constraint > > >

[jira] [Commented] (HIVE-18726) Implement DEFAULT constraint

2018-02-15 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18726?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16366445#comment-16366445 ] Vineet Garg commented on HIVE-18726: Attached is initial patch which adds support for DEFAULT

[jira] [Updated] (HIVE-18726) Implement DEFAULT constraint

2018-02-15 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18726: --- Status: Patch Available (was: Open) > Implement DEFAULT constraint > >

[jira] [Commented] (HIVE-6905) Implement Auto increment, primary-foreign Key, not null constraints and default value in Hive Table columns

2018-02-15 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-6905?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16366449#comment-16366449 ] Vineet Garg commented on HIVE-6905: --- [~grw], [~patelmanjun...@gmail.com] [~ppm] [~richardlloyd] FYI I

[jira] [Updated] (HIVE-18797) ExprConstNodeDesc's getExprString should put appropriate qualifier with literals

2018-02-25 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18797?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18797: --- Status: Patch Available (was: Open) > ExprConstNodeDesc's getExprString should put appropriate

[jira] [Updated] (HIVE-18797) ExprConstNodeDesc's getExprString should put appropriate qualifier with literals

2018-02-25 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18797?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18797: --- Status: Open (was: Patch Available) > ExprConstNodeDesc's getExprString should put appropriate

[jira] [Updated] (HIVE-18797) ExprConstNodeDesc's getExprString should put appropriate qualifier with literals

2018-02-25 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18797?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18797: --- Attachment: HIVE-18797.2.patch > ExprConstNodeDesc's getExprString should put appropriate qualifier

[jira] [Commented] (HIVE-18797) ExprConstNodeDesc's getExprString should put appropriate qualifier with literals

2018-02-25 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18797?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16376394#comment-16376394 ] Vineet Garg commented on HIVE-18797: Test looks unrelated. [~ashutoshc] can you take a look? >

[jira] [Commented] (HIVE-18775) HIVE-17983 missed deleting metastore/scripts/upgrade/derby/hive-schema-3.0.0.derby.sql

2018-02-24 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18775?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16375892#comment-16375892 ] Vineet Garg commented on HIVE-18775: Investigation into test failure reveals that schemaTool expects

[jira] [Updated] (HIVE-18797) ExprConstNodeDesc's getExprString should put appropriate qualifier with literals

2018-02-24 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18797?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18797: --- Attachment: HIVE-18797.1.patch > ExprConstNodeDesc's getExprString should put appropriate qualifier

[jira] [Updated] (HIVE-18797) ExprConstNodeDesc's getExprString should put appropriate qualifier with literals

2018-02-24 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18797?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18797: --- Status: Patch Available (was: Open) > ExprConstNodeDesc's getExprString should put appropriate

[jira] [Assigned] (HIVE-18797) ExprConstNodeDesc's getExprString should put appropriate qualifier with literals

2018-02-24 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18797?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-18797: -- > ExprConstNodeDesc's getExprString should put appropriate qualifier with > literals >

[jira] [Comment Edited] (HIVE-18792) Allow standard compliant syntax for insert on partitioned tables

2018-02-26 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-18792?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16378101#comment-16378101 ] Vineet Garg edited comment on HIVE-18792 at 2/27/18 6:17 AM: - First patch

[jira] [Resolved] (HIVE-20215) Hive unable to plan/compile query containing subquery with multiple same name columns

2018-07-27 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20215?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg resolved HIVE-20215. Resolution: Duplicate > Hive unable to plan/compile query containing subquery with multiple same

[jira] [Updated] (HIVE-19770) Support for CBO for queries with multiple same columns in select

2018-07-27 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-19770?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-19770: --- Attachment: HIVE-19770.7.patch > Support for CBO for queries with multiple same columns in select >

[jira] [Commented] (HIVE-20215) Hive unable to plan/compile query containing subquery with multiple same name columns

2018-07-27 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20215?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16560460#comment-16560460 ] Vineet Garg commented on HIVE-20215: This will be fixe in HIVE-19770 > Hive unable to plan/compile

[jira] [Updated] (HIVE-19770) Support for CBO for queries with multiple same columns in select

2018-07-27 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-19770?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-19770: --- Status: Patch Available (was: Open) > Support for CBO for queries with multiple same columns in

[jira] [Updated] (HIVE-19770) Support for CBO for queries with multiple same columns in select

2018-07-27 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-19770?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-19770: --- Status: Open (was: Patch Available) > Support for CBO for queries with multiple same columns in

[jira] [Updated] (HIVE-20292) Bad join ordering in tpcds query93 with primary constraint defined

2018-08-02 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-20292: --- Status: Open (was: Patch Available) > Bad join ordering in tpcds query93 with primary constraint

[jira] [Updated] (HIVE-20292) Bad join ordering in tpcds query93 with primary constraint defined

2018-08-02 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-20292: --- Status: Patch Available (was: Open) > Bad join ordering in tpcds query93 with primary constraint

[jira] [Updated] (HIVE-20292) Bad join ordering in tpcds query93 with primary constraint defined

2018-08-02 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-20292: --- Attachment: HIVE-20292.2.patch > Bad join ordering in tpcds query93 with primary constraint defined

[jira] [Updated] (HIVE-20292) Bad join ordering in tpcds query93 with primary constraint defined

2018-08-02 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-20292: --- Attachment: HIVE-20292.3.patch > Bad join ordering in tpcds query93 with primary constraint defined

[jira] [Updated] (HIVE-20292) Bad join ordering in tpcds query93 with primary constraint defined

2018-08-02 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-20292: --- Status: Open (was: Patch Available) > Bad join ordering in tpcds query93 with primary constraint

[jira] [Updated] (HIVE-20292) Bad join ordering in tpcds query93 with primary constraint defined

2018-08-02 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-20292: --- Status: Patch Available (was: Open) > Bad join ordering in tpcds query93 with primary constraint

[jira] [Updated] (HIVE-20255) Review LevelOrderWalker.java

2018-07-30 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20255?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-20255: --- Fix Version/s: (was: 3.1.0) > Review LevelOrderWalker.java > > >

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

2018-07-29 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20265?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-20265: -- > PTF operator has an extra reducer in CBO > > >

[jira] [Assigned] (HIVE-20266) Extra column is being shuffled in cbo as compared to non-cbo

2018-07-29 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20266?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-20266: -- > Extra column is being shuffled in cbo as compared to non-cbo >

[jira] [Updated] (HIVE-19770) Support for CBO for queries with multiple same columns in select

2018-07-29 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-19770?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-19770: --- Resolution: Fixed Fix Version/s: 4.0.0 Target Version/s: 4.0.0 (was: 3.1.0)

[jira] [Updated] (HIVE-20266) Extra column is being shuffled in cbo as compared to non-cbo

2018-07-29 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20266?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-20266: --- Description: {code:sql} CREATE TABLE tablePartitioned (a STRING NOT NULL ENFORCED, b STRING, c

[jira] [Updated] (HIVE-19770) Support for CBO for queries with multiple same columns in select

2018-07-29 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-19770?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-19770: --- Attachment: HIVE-19770.8.patch > Support for CBO for queries with multiple same columns in select >

[jira] [Updated] (HIVE-19770) Support for CBO for queries with multiple same columns in select

2018-07-29 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-19770?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-19770: --- Status: Open (was: Patch Available) > Support for CBO for queries with multiple same columns in

[jira] [Updated] (HIVE-20215) Hive unable to plan/compile query containing subquery with multiple same name columns

2018-07-29 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20215?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-20215: --- Attachment: (was: HIVE-19770.8.patch) > Hive unable to plan/compile query containing subquery

[jira] [Updated] (HIVE-19770) Support for CBO for queries with multiple same columns in select

2018-07-29 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-19770?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-19770: --- Status: Patch Available (was: Open) > Support for CBO for queries with multiple same columns in

[jira] [Updated] (HIVE-20215) Hive unable to plan/compile query containing subquery with multiple same name columns

2018-07-29 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20215?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-20215: --- Attachment: HIVE-19770.8.patch > Hive unable to plan/compile query containing subquery with multiple

[jira] [Updated] (HIVE-20292) Bad join ordering in tpcds query93 with primary constraint defined

2018-08-03 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-20292: --- Status: Open (was: Patch Available) > Bad join ordering in tpcds query93 with primary constraint

[jira] [Commented] (HIVE-20292) Bad join ordering in tpcds query93 with primary constraint defined

2018-08-03 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20292?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16568971#comment-16568971 ] Vineet Garg commented on HIVE-20292: Review request is at: https://reviews.apache.org/r/68202/ > Bad

[jira] [Updated] (HIVE-20310) Scalar subquery throws error when hive.optimize.remove.sq_count_check is on

2018-08-03 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20310?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-20310: --- Description: *Reproducer* {code:sql} > set hive.optimize.remove.sq_count_check=true; > create table

[jira] [Assigned] (HIVE-20310) Scalar subquery throws error when hive.optimize.remove.sq_count_check is on

2018-08-03 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20310?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-20310: -- > Scalar subquery throws error when hive.optimize.remove.sq_count_check is on >

[jira] [Updated] (HIVE-20292) Bad join ordering in tpcds query93 with primary constraint defined

2018-08-04 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-20292: --- Attachment: HIVE-20292.6.patch > Bad join ordering in tpcds query93 with primary constraint defined

[jira] [Updated] (HIVE-20292) Bad join ordering in tpcds query93 with primary constraint defined

2018-08-04 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-20292: --- Status: Open (was: Patch Available) > Bad join ordering in tpcds query93 with primary constraint

[jira] [Updated] (HIVE-20292) Bad join ordering in tpcds query93 with primary constraint defined

2018-08-04 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-20292: --- Status: Patch Available (was: Open) > Bad join ordering in tpcds query93 with primary constraint

[jira] [Updated] (HIVE-20292) Bad join ordering in tpcds query93 with primary constraint defined

2018-08-01 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-20292: --- Summary: Bad join ordering in tpcds query93 with primary constraint defined (was: Bad join ordering

[jira] [Updated] (HIVE-20292) Bad join ordering in query93 with primary constraint defined

2018-08-01 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-20292: --- Status: Patch Available (was: Open) > Bad join ordering in query93 with primary constraint defined

[jira] [Updated] (HIVE-20292) Bad join ordering in query93 with primary constraint defined

2018-08-01 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-20292: --- Attachment: HIVE-20292.1.patch > Bad join ordering in query93 with primary constraint defined >

[jira] [Assigned] (HIVE-20292) Bad join ordering in query93 with primary constraint defined

2018-08-01 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg reassigned HIVE-20292: -- > Bad join ordering in query93 with primary constraint defined >

[jira] [Commented] (HIVE-20256) Remove unused classes from Hive QL

2018-07-27 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-20256?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16560285#comment-16560285 ] Vineet Garg commented on HIVE-20256: [~mgergely] Any particular reason this is being fixed for 3.0.1?

<    13   14   15   16   17   18   19   20   21   22   >