[jira] [Updated] (HIVE-16002) Correlated IN subquery with aggregate asserts in sq_count_check UDF
[ https://issues.apache.org/jira/browse/HIVE-16002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-16002: Resolution: Fixed Fix Version/s: 2.2.0 Status: Resolved (was: Patch Available) Pushed to master. Thanks, Vineet! > Correlated IN subquery with aggregate asserts in sq_count_check UDF > --- > > Key: HIVE-16002 > URL: https://issues.apache.org/jira/browse/HIVE-16002 > Project: Hive > Issue Type: Bug >Reporter: Vineet Garg >Assignee: Vineet Garg > Fix For: 2.2.0 > > Attachments: HIVE-16002.1.patch, HIVE-16002.2.patch, > HIVE-16002.3.patch > > > Reproducer > {code:SQL} > create table t(i int, j int); > insert into t values(0,1), (0,2); > create table tt(i int, j int); > insert into tt values(0,3); > select * from t where i IN (select count(i) from tt where tt.j = t.j); > {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Updated] (HIVE-16002) Correlated IN subquery with aggregate asserts in sq_count_check UDF
[ https://issues.apache.org/jira/browse/HIVE-16002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-16002: --- Attachment: HIVE-16002.3.patch > Correlated IN subquery with aggregate asserts in sq_count_check UDF > --- > > Key: HIVE-16002 > URL: https://issues.apache.org/jira/browse/HIVE-16002 > Project: Hive > Issue Type: Bug >Reporter: Vineet Garg >Assignee: Vineet Garg > Attachments: HIVE-16002.1.patch, HIVE-16002.2.patch, > HIVE-16002.3.patch > > > Reproducer > {code:SQL} > create table t(i int, j int); > insert into t values(0,1), (0,2); > create table tt(i int, j int); > insert into tt values(0,3); > select * from t where i IN (select count(i) from tt where tt.j = t.j); > {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Updated] (HIVE-16002) Correlated IN subquery with aggregate asserts in sq_count_check UDF
[ https://issues.apache.org/jira/browse/HIVE-16002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-16002: --- Status: Open (was: Patch Available) > Correlated IN subquery with aggregate asserts in sq_count_check UDF > --- > > Key: HIVE-16002 > URL: https://issues.apache.org/jira/browse/HIVE-16002 > Project: Hive > Issue Type: Bug >Reporter: Vineet Garg >Assignee: Vineet Garg > Attachments: HIVE-16002.1.patch, HIVE-16002.2.patch, > HIVE-16002.3.patch > > > Reproducer > {code:SQL} > create table t(i int, j int); > insert into t values(0,1), (0,2); > create table tt(i int, j int); > insert into tt values(0,3); > select * from t where i IN (select count(i) from tt where tt.j = t.j); > {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Updated] (HIVE-16002) Correlated IN subquery with aggregate asserts in sq_count_check UDF
[ https://issues.apache.org/jira/browse/HIVE-16002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-16002: --- Status: Patch Available (was: Open) > Correlated IN subquery with aggregate asserts in sq_count_check UDF > --- > > Key: HIVE-16002 > URL: https://issues.apache.org/jira/browse/HIVE-16002 > Project: Hive > Issue Type: Bug >Reporter: Vineet Garg >Assignee: Vineet Garg > Attachments: HIVE-16002.1.patch, HIVE-16002.2.patch, > HIVE-16002.3.patch > > > Reproducer > {code:SQL} > create table t(i int, j int); > insert into t values(0,1), (0,2); > create table tt(i int, j int); > insert into tt values(0,3); > select * from t where i IN (select count(i) from tt where tt.j = t.j); > {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Updated] (HIVE-16002) Correlated IN subquery with aggregate asserts in sq_count_check UDF
[ https://issues.apache.org/jira/browse/HIVE-16002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-16002: --- Status: Patch Available (was: Open) > Correlated IN subquery with aggregate asserts in sq_count_check UDF > --- > > Key: HIVE-16002 > URL: https://issues.apache.org/jira/browse/HIVE-16002 > Project: Hive > Issue Type: Bug >Reporter: Vineet Garg >Assignee: Vineet Garg > Attachments: HIVE-16002.1.patch, HIVE-16002.2.patch > > > Reproducer > {code:SQL} > create table t(i int, j int); > insert into t values(0,1), (0,2); > create table tt(i int, j int); > insert into tt values(0,3); > select * from t where i IN (select count(i) from tt where tt.j = t.j); > {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Updated] (HIVE-16002) Correlated IN subquery with aggregate asserts in sq_count_check UDF
[ https://issues.apache.org/jira/browse/HIVE-16002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-16002: --- Attachment: HIVE-16002.2.patch > Correlated IN subquery with aggregate asserts in sq_count_check UDF > --- > > Key: HIVE-16002 > URL: https://issues.apache.org/jira/browse/HIVE-16002 > Project: Hive > Issue Type: Bug >Reporter: Vineet Garg >Assignee: Vineet Garg > Attachments: HIVE-16002.1.patch, HIVE-16002.2.patch > > > Reproducer > {code:SQL} > create table t(i int, j int); > insert into t values(0,1), (0,2); > create table tt(i int, j int); > insert into tt values(0,3); > select * from t where i IN (select count(i) from tt where tt.j = t.j); > {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Updated] (HIVE-16002) Correlated IN subquery with aggregate asserts in sq_count_check UDF
[ https://issues.apache.org/jira/browse/HIVE-16002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-16002: --- Attachment: (was: HIVE-16002.2.patch) > Correlated IN subquery with aggregate asserts in sq_count_check UDF > --- > > Key: HIVE-16002 > URL: https://issues.apache.org/jira/browse/HIVE-16002 > Project: Hive > Issue Type: Bug >Reporter: Vineet Garg >Assignee: Vineet Garg > Attachments: HIVE-16002.1.patch, HIVE-16002.2.patch > > > Reproducer > {code:SQL} > create table t(i int, j int); > insert into t values(0,1), (0,2); > create table tt(i int, j int); > insert into tt values(0,3); > select * from t where i IN (select count(i) from tt where tt.j = t.j); > {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Updated] (HIVE-16002) Correlated IN subquery with aggregate asserts in sq_count_check UDF
[ https://issues.apache.org/jira/browse/HIVE-16002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-16002: --- Status: Open (was: Patch Available) > Correlated IN subquery with aggregate asserts in sq_count_check UDF > --- > > Key: HIVE-16002 > URL: https://issues.apache.org/jira/browse/HIVE-16002 > Project: Hive > Issue Type: Bug >Reporter: Vineet Garg >Assignee: Vineet Garg > Attachments: HIVE-16002.1.patch, HIVE-16002.2.patch > > > Reproducer > {code:SQL} > create table t(i int, j int); > insert into t values(0,1), (0,2); > create table tt(i int, j int); > insert into tt values(0,3); > select * from t where i IN (select count(i) from tt where tt.j = t.j); > {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Updated] (HIVE-16002) Correlated IN subquery with aggregate asserts in sq_count_check UDF
[ https://issues.apache.org/jira/browse/HIVE-16002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-16002: --- Status: Patch Available (was: Open) > Correlated IN subquery with aggregate asserts in sq_count_check UDF > --- > > Key: HIVE-16002 > URL: https://issues.apache.org/jira/browse/HIVE-16002 > Project: Hive > Issue Type: Bug >Reporter: Vineet Garg >Assignee: Vineet Garg > Attachments: HIVE-16002.1.patch, HIVE-16002.2.patch > > > Reproducer > {code:SQL} > create table t(i int, j int); > insert into t values(0,1), (0,2); > create table tt(i int, j int); > insert into tt values(0,3); > select * from t where i IN (select count(i) from tt where tt.j = t.j); > {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Updated] (HIVE-16002) Correlated IN subquery with aggregate asserts in sq_count_check UDF
[ https://issues.apache.org/jira/browse/HIVE-16002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-16002: --- Status: Open (was: Patch Available) > Correlated IN subquery with aggregate asserts in sq_count_check UDF > --- > > Key: HIVE-16002 > URL: https://issues.apache.org/jira/browse/HIVE-16002 > Project: Hive > Issue Type: Bug >Reporter: Vineet Garg >Assignee: Vineet Garg > Attachments: HIVE-16002.1.patch, HIVE-16002.2.patch > > > Reproducer > {code:SQL} > create table t(i int, j int); > insert into t values(0,1), (0,2); > create table tt(i int, j int); > insert into tt values(0,3); > select * from t where i IN (select count(i) from tt where tt.j = t.j); > {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Updated] (HIVE-16002) Correlated IN subquery with aggregate asserts in sq_count_check UDF
[ https://issues.apache.org/jira/browse/HIVE-16002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-16002: --- Attachment: HIVE-16002.2.patch > Correlated IN subquery with aggregate asserts in sq_count_check UDF > --- > > Key: HIVE-16002 > URL: https://issues.apache.org/jira/browse/HIVE-16002 > Project: Hive > Issue Type: Bug >Reporter: Vineet Garg >Assignee: Vineet Garg > Attachments: HIVE-16002.1.patch, HIVE-16002.2.patch > > > Reproducer > {code:SQL} > create table t(i int, j int); > insert into t values(0,1), (0,2); > create table tt(i int, j int); > insert into tt values(0,3); > select * from t where i IN (select count(i) from tt where tt.j = t.j); > {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Updated] (HIVE-16002) Correlated IN subquery with aggregate asserts in sq_count_check UDF
[ https://issues.apache.org/jira/browse/HIVE-16002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-16002: Status: Patch Available (was: Open) > Correlated IN subquery with aggregate asserts in sq_count_check UDF > --- > > Key: HIVE-16002 > URL: https://issues.apache.org/jira/browse/HIVE-16002 > Project: Hive > Issue Type: Bug >Reporter: Vineet Garg >Assignee: Vineet Garg > Attachments: HIVE-16002.1.patch > > > Reproducer > {code:SQL} > create table t(i int, j int); > insert into t values(0,1), (0,2); > create table tt(i int, j int); > insert into tt values(0,3); > select * from t where i IN (select count(i) from tt where tt.j = t.j); > {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Updated] (HIVE-16002) Correlated IN subquery with aggregate asserts in sq_count_check UDF
[ https://issues.apache.org/jira/browse/HIVE-16002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-16002: --- Attachment: HIVE-16002.1.patch > Correlated IN subquery with aggregate asserts in sq_count_check UDF > --- > > Key: HIVE-16002 > URL: https://issues.apache.org/jira/browse/HIVE-16002 > Project: Hive > Issue Type: Bug >Reporter: Vineet Garg >Assignee: Vineet Garg > Attachments: HIVE-16002.1.patch > > > Reproducer > {code:SQL} > create table t(i int, j int); > insert into t values(0,1), (0,2); > create table tt(i int, j int); > insert into tt values(0,3); > select * from t where i IN (select count(i) from tt where tt.j = t.j); > {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Updated] (HIVE-16002) Correlated IN subquery with aggregate asserts in sq_count_check UDF
[ https://issues.apache.org/jira/browse/HIVE-16002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-16002: --- Description: Reproducer {code:SQL} create table t(i int, j int); insert into t values(0,1), (0,2); create table tt(i int, j int); insert into tt values(0,3); select * from t where i IN (select count(i) from tt where tt.j = t.j); {code} was: ==Reproducer== {code:SQL} create table t(i int, j int); insert into t values(0,1), (0,2); create table tt(i int, j int); insert into tt values(0,3); select * from t where i IN (select count(i) from tt where tt.j = t.j); {code} > Correlated IN subquery with aggregate asserts in sq_count_check UDF > --- > > Key: HIVE-16002 > URL: https://issues.apache.org/jira/browse/HIVE-16002 > Project: Hive > Issue Type: Bug >Reporter: Vineet Garg >Assignee: Vineet Garg > > Reproducer > {code:SQL} > create table t(i int, j int); > insert into t values(0,1), (0,2); > create table tt(i int, j int); > insert into tt values(0,3); > select * from t where i IN (select count(i) from tt where tt.j = t.j); > {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)