[jira] [Commented] (HIVE-18999) Filter operator does not work for List
[ https://issues.apache.org/jira/browse/HIVE-18999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16451422#comment-16451422 ] Steve Yeom commented on HIVE-18999: --- Talked with Ashutosh. What he is proposing is that we can convert the type conversion while we are converting Hive filter expression AST tree to Calcite Rex node tree, not during execution, > Filter operator does not work for List > -- > > Key: HIVE-18999 > URL: https://issues.apache.org/jira/browse/HIVE-18999 > Project: Hive > Issue Type: Bug > Components: Query Processor >Affects Versions: 3.0.0 >Reporter: Steve Yeom >Assignee: Steve Yeom >Priority: Major > Attachments: HIVE-18999.01.patch, HIVE-18999.02.patch, > HIVE-18999.03.patch > > > {code:sql} > create table table1(col0 int, col1 bigint, col2 string, col3 bigint, col4 > bigint); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2015, 11); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2013, 11); > -- INCORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct(2014,11)); > -- CORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct('2014','11')); > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-18999) Filter operator does not work for List
[ https://issues.apache.org/jira/browse/HIVE-18999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16431342#comment-16431342 ] Steve Yeom commented on HIVE-18999: --- If nothing prevents, we can just move the prepareInSet() changes into compilation time. > Filter operator does not work for List > -- > > Key: HIVE-18999 > URL: https://issues.apache.org/jira/browse/HIVE-18999 > Project: Hive > Issue Type: Bug > Components: Query Processor >Affects Versions: 3.0.0 >Reporter: Steve Yeom >Assignee: Steve Yeom >Priority: Major > Attachments: HIVE-18999.01.patch, HIVE-18999.02.patch, > HIVE-18999.03.patch > > > {code:sql} > create table table1(col0 int, col1 bigint, col2 string, col3 bigint, col4 > bigint); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2015, 11); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2013, 11); > -- INCORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct(2014,11)); > -- CORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct('2014','11')); > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-18999) Filter operator does not work for List
[ https://issues.apache.org/jira/browse/HIVE-18999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16431300#comment-16431300 ] Steve Yeom commented on HIVE-18999: --- 1. The newly added q file for this jira "struct_in_filter.q" runs successfully with "hive.vectorized.execution.enabled=true". 2. Out of two modified files, "ql/udf/generic/GenericUDFIn.java" and "ql/udf/generic/GenericUDFUtils.java", GenericUDFUtils.update() is called during compilation (logical plan generation/optimization),. GenericUDFIn.prepareInSet() is called during execution but JUST ONE TIME when the "constantInSet" is null. I am investigating the possibility that "deferred object list" input arguments to the method may have cases where their final values are determined ONLY during execution. > Filter operator does not work for List > -- > > Key: HIVE-18999 > URL: https://issues.apache.org/jira/browse/HIVE-18999 > Project: Hive > Issue Type: Bug > Components: Query Processor >Affects Versions: 3.0.0 >Reporter: Steve Yeom >Assignee: Steve Yeom >Priority: Major > Attachments: HIVE-18999.01.patch, HIVE-18999.02.patch, > HIVE-18999.03.patch > > > {code:sql} > create table table1(col0 int, col1 bigint, col2 string, col3 bigint, col4 > bigint); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2015, 11); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2013, 11); > -- INCORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct(2014,11)); > -- CORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct('2014','11')); > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-18999) Filter operator does not work for List
[ https://issues.apache.org/jira/browse/HIVE-18999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16428703#comment-16428703 ] Steve Yeom commented on HIVE-18999: --- Talked with Ashutosh. For the vectorization execution path, "hive.vectorized.execution.enabled=true" might be enough to enable one for the test case. > Filter operator does not work for List > -- > > Key: HIVE-18999 > URL: https://issues.apache.org/jira/browse/HIVE-18999 > Project: Hive > Issue Type: Bug > Components: Query Processor >Affects Versions: 3.0.0 >Reporter: Steve Yeom >Assignee: Steve Yeom >Priority: Major > Attachments: HIVE-18999.01.patch, HIVE-18999.02.patch, > HIVE-18999.03.patch > > > {code:sql} > create table table1(col0 int, col1 bigint, col2 string, col3 bigint, col4 > bigint); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2015, 11); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2013, 11); > -- INCORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct(2014,11)); > -- CORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct('2014','11')); > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-18999) Filter operator does not work for List
[ https://issues.apache.org/jira/browse/HIVE-18999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16428646#comment-16428646 ] Steve Yeom commented on HIVE-18999: --- TypeCheckProcFactory part seems reasonable. But do we have vectorizaed path testing unit tests? Or do I need to add a new one for vectorization case? > Filter operator does not work for List > -- > > Key: HIVE-18999 > URL: https://issues.apache.org/jira/browse/HIVE-18999 > Project: Hive > Issue Type: Bug > Components: Query Processor >Affects Versions: 3.0.0 >Reporter: Steve Yeom >Assignee: Steve Yeom >Priority: Major > Attachments: HIVE-18999.01.patch, HIVE-18999.02.patch, > HIVE-18999.03.patch > > > {code:sql} > create table table1(col0 int, col1 bigint, col2 string, col3 bigint, col4 > bigint); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2015, 11); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2013, 11); > -- INCORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct(2014,11)); > -- CORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct('2014','11')); > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-18999) Filter operator does not work for List
[ https://issues.apache.org/jira/browse/HIVE-18999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16428640#comment-16428640 ] Ashutosh Chauhan commented on HIVE-18999: - Although this fixes the issue, its not an ideal solution. e.g., this fix doesn't address vectorization case. So, this will still be an issue on vectorized path. Compiler should generate type safe plan and runtime shouldn't be responsible for 'fixing' up type mismatch. So, correct fix is to insert these casts in TypeCheckProcFactory when we generate ExprNodeDesc from AST. > Filter operator does not work for List > -- > > Key: HIVE-18999 > URL: https://issues.apache.org/jira/browse/HIVE-18999 > Project: Hive > Issue Type: Bug > Components: Query Processor >Affects Versions: 3.0.0 >Reporter: Steve Yeom >Assignee: Steve Yeom >Priority: Major > Attachments: HIVE-18999.01.patch, HIVE-18999.02.patch, > HIVE-18999.03.patch > > > {code:sql} > create table table1(col0 int, col1 bigint, col2 string, col3 bigint, col4 > bigint); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2015, 11); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2013, 11); > -- INCORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct(2014,11)); > -- CORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct('2014','11')); > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-18999) Filter operator does not work for List
[ https://issues.apache.org/jira/browse/HIVE-18999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16425921#comment-16425921 ] Steve Yeom commented on HIVE-18999: --- Hi [~ashutoshc] [~jcamachorodriguez], could you please review the patch? Please let me know if you need a RB. Thanks, Steve. > Filter operator does not work for List > -- > > Key: HIVE-18999 > URL: https://issues.apache.org/jira/browse/HIVE-18999 > Project: Hive > Issue Type: Bug > Components: Query Processor >Affects Versions: 3.0.0 >Reporter: Steve Yeom >Assignee: Steve Yeom >Priority: Major > Attachments: HIVE-18999.01.patch, HIVE-18999.02.patch, > HIVE-18999.03.patch > > > {code:sql} > create table table1(col0 int, col1 bigint, col2 string, col3 bigint, col4 > bigint); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2015, 11); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2013, 11); > -- INCORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct(2014,11)); > -- CORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct('2014','11')); > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-18999) Filter operator does not work for List
[ https://issues.apache.org/jira/browse/HIVE-18999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16425916#comment-16425916 ] Steve Yeom commented on HIVE-18999: --- The failed 4 tests with age 1 of the above p-test run are clear in my laptop test environment. > Filter operator does not work for List > -- > > Key: HIVE-18999 > URL: https://issues.apache.org/jira/browse/HIVE-18999 > Project: Hive > Issue Type: Bug > Components: Query Processor >Affects Versions: 3.0.0 >Reporter: Steve Yeom >Assignee: Steve Yeom >Priority: Major > Attachments: HIVE-18999.01.patch, HIVE-18999.02.patch, > HIVE-18999.03.patch > > > {code:sql} > create table table1(col0 int, col1 bigint, col2 string, col3 bigint, col4 > bigint); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2015, 11); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2013, 11); > -- INCORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct(2014,11)); > -- CORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct('2014','11')); > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-18999) Filter operator does not work for List
[ https://issues.apache.org/jira/browse/HIVE-18999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16425438#comment-16425438 ] Hive QA commented on HIVE-18999: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12917397/HIVE-18999.03.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 202 failed/errored test(s), 13308 tests executed *Failed tests:* {noformat} TestCopyUtils - did not produce a TEST-*.xml file (likely timed out) (batchId=230) TestDbNotificationListener - did not produce a TEST-*.xml file (likely timed out) (batchId=246) TestExportImport - did not produce a TEST-*.xml file (likely timed out) (batchId=230) TestHCatHiveCompatibility - did not produce a TEST-*.xml file (likely timed out) (batchId=246) TestNegativeCliDriver - did not produce a TEST-*.xml file (likely timed out) (batchId=95)
[jira] [Commented] (HIVE-18999) Filter operator does not work for List
[ https://issues.apache.org/jira/browse/HIVE-18999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16425355#comment-16425355 ] Hive QA commented on HIVE-18999: | (x) *{color:red}-1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 0m 1s{color} | {color:blue} Findbugs executables are not available. {color} | | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 8m 24s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 18s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 45s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 1m 5s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 39s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 23s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 1m 23s{color} | {color:green} the patch passed {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 44s{color} | {color:red} ql: The patch generated 4 new + 43 unchanged - 0 fixed = 47 total (was 43) {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 1m 4s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:red}-1{color} | {color:red} asflicense {color} | {color:red} 0m 15s{color} | {color:red} The patch generated 50 ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 16m 56s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-9990/dev-support/hive-personality.sh | | git revision | master / 93f609e | | Default Java | 1.8.0_111 | | checkstyle | http://104.198.109.242/logs//PreCommit-HIVE-Build-9990/yetus/diff-checkstyle-ql.txt | | asflicense | http://104.198.109.242/logs//PreCommit-HIVE-Build-9990/yetus/patch-asflicense-problems.txt | | modules | C: ql U: ql | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-9990/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Filter operator does not work for List > -- > > Key: HIVE-18999 > URL: https://issues.apache.org/jira/browse/HIVE-18999 > Project: Hive > Issue Type: Bug > Components: Query Processor >Affects Versions: 3.0.0 >Reporter: Steve Yeom >Assignee: Steve Yeom >Priority: Major > Attachments: HIVE-18999.01.patch, HIVE-18999.02.patch, > HIVE-18999.03.patch > > > {code:sql} > create table table1(col0 int, col1 bigint, col2 string, col3 bigint, col4 > bigint); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2015, 11); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2013, 11); > -- INCORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct(2014,11)); > -- CORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct('2014','11')); > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-18999) Filter operator does not work for List
[ https://issues.apache.org/jira/browse/HIVE-18999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16424253#comment-16424253 ] Steve Yeom commented on HIVE-18999: --- One logical NOT operator (!) is added I think by mistake while creating patch version 1 from testing-plus-fix code. That is why the newly added "struct_in_filter.q" q file test itself failed. Submitting patch version 3. > Filter operator does not work for List > -- > > Key: HIVE-18999 > URL: https://issues.apache.org/jira/browse/HIVE-18999 > Project: Hive > Issue Type: Bug > Components: Query Processor >Affects Versions: 3.0.0 >Reporter: Steve Yeom >Assignee: Steve Yeom >Priority: Major > Attachments: HIVE-18999.01.patch, HIVE-18999.02.patch > > > {code:sql} > create table table1(col0 int, col1 bigint, col2 string, col3 bigint, col4 > bigint); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2015, 11); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2013, 11); > -- INCORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct(2014,11)); > -- CORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct('2014','11')); > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-18999) Filter operator does not work for List
[ https://issues.apache.org/jira/browse/HIVE-18999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16423477#comment-16423477 ] Hive QA commented on HIVE-18999: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12917225/HIVE-18999.02.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 192 failed/errored test(s), 13297 tests executed *Failed tests:* {noformat} TestCopyUtils - did not produce a TEST-*.xml file (likely timed out) (batchId=230) TestDbNotificationListener - did not produce a TEST-*.xml file (likely timed out) (batchId=246) TestExportImport - did not produce a TEST-*.xml file (likely timed out) (batchId=230) TestHCatHiveCompatibility - did not produce a TEST-*.xml file (likely timed out) (batchId=246) TestNegativeCliDriver - did not produce a TEST-*.xml file (likely timed out) (batchId=95)
[jira] [Commented] (HIVE-18999) Filter operator does not work for List
[ https://issues.apache.org/jira/browse/HIVE-18999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16423436#comment-16423436 ] Hive QA commented on HIVE-18999: | (x) *{color:red}-1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 0m 1s{color} | {color:blue} Findbugs executables are not available. {color} | | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 8m 27s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 21s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 46s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 1m 6s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 35s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 20s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 1m 20s{color} | {color:green} the patch passed {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 52s{color} | {color:red} ql: The patch generated 4 new + 43 unchanged - 0 fixed = 47 total (was 43) {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 1m 6s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:red}-1{color} | {color:red} asflicense {color} | {color:red} 0m 16s{color} | {color:red} The patch generated 49 ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 17m 8s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-9966/dev-support/hive-personality.sh | | git revision | master / ad9852c | | Default Java | 1.8.0_111 | | checkstyle | http://104.198.109.242/logs//PreCommit-HIVE-Build-9966/yetus/diff-checkstyle-ql.txt | | asflicense | http://104.198.109.242/logs//PreCommit-HIVE-Build-9966/yetus/patch-asflicense-problems.txt | | modules | C: ql U: ql | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-9966/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Filter operator does not work for List > -- > > Key: HIVE-18999 > URL: https://issues.apache.org/jira/browse/HIVE-18999 > Project: Hive > Issue Type: Bug > Components: Query Processor >Affects Versions: 3.0.0 >Reporter: Steve Yeom >Assignee: Steve Yeom >Priority: Major > Attachments: HIVE-18999.01.patch, HIVE-18999.02.patch > > > {code:sql} > create table table1(col0 int, col1 bigint, col2 string, col3 bigint, col4 > bigint); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2015, 11); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2013, 11); > -- INCORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct(2014,11)); > -- CORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct('2014','11')); > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-18999) Filter operator does not work for List
[ https://issues.apache.org/jira/browse/HIVE-18999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16422953#comment-16422953 ] Steve Yeom commented on HIVE-18999: --- patch 01 is not p-tested. So the same patch is added as patch 02. > Filter operator does not work for List > -- > > Key: HIVE-18999 > URL: https://issues.apache.org/jira/browse/HIVE-18999 > Project: Hive > Issue Type: Bug > Components: Query Processor >Affects Versions: 3.0.0 >Reporter: Steve Yeom >Assignee: Steve Yeom >Priority: Major > Attachments: HIVE-18999.01.patch, HIVE-18999.02.patch > > > {code:sql} > create table table1(col0 int, col1 bigint, col2 string, col3 bigint, col4 > bigint); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2015, 11); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2013, 11); > -- INCORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct(2014,11)); > -- CORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct('2014','11')); > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-18999) Filter operator does not work for List
[ https://issues.apache.org/jira/browse/HIVE-18999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16416495#comment-16416495 ] Steve Yeom commented on HIVE-18999: --- A better patch might be to change constant side if it is smaller in type than the column side since the conversion helper takes larger type as common type at least for the test case. > Filter operator does not work for List > -- > > Key: HIVE-18999 > URL: https://issues.apache.org/jira/browse/HIVE-18999 > Project: Hive > Issue Type: Bug > Components: Query Processor >Affects Versions: 3.0.0 >Reporter: Steve Yeom >Assignee: Steve Yeom >Priority: Major > > {code:sql} > create table table1(col0 int, col1 bigint, col2 string, col3 bigint, col4 > bigint); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2015, 11); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2013, 11); > -- INCORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct(2014,11)); > -- CORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct('2014','11')); > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-18999) Filter operator does not work for List
[ https://issues.apache.org/jira/browse/HIVE-18999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16415895#comment-16415895 ] Steve Yeom commented on HIVE-18999: --- GenericUDFIn.evaluate(DeferredObject[]) has .. 175 case STRUCT: { 176 if (constantInSet.contains(((StructObjectInspector) compareOI).getStructFieldsDataAsList(conversionHelper 177.convertIfNecessary(arguments[0].get(), argumentOIs[0] { 178 bw.set(true); 179 return bw; 180 } 181 break; 182 } The case 1 get the "arguments[0].get()" converted to Text (or String) so that we get true to have a correct result. Here "arguments[0].get()" is the left side node in where clause. constantInSet has Text node. The case 3 has both constantInSet and arguments[0].get() has IntWritable to get a correct result. The second case 2 has IntWritable for constantInSet and LongWritable for the other, which causes "constantInSet.contains(..)" to return false. A patch might be to convert left side LongWritable node to IntWritable . > Filter operator does not work for List > -- > > Key: HIVE-18999 > URL: https://issues.apache.org/jira/browse/HIVE-18999 > Project: Hive > Issue Type: Bug > Components: Query Processor >Affects Versions: 3.0.0 >Reporter: Steve Yeom >Assignee: Steve Yeom >Priority: Major > > {code:sql} > create table table1(col0 int, col1 bigint, col2 string, col3 bigint, col4 > bigint); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2015, 11); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2013, 11); > -- INCORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct(2014,11)); > -- CORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct('2014','11')); > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-18999) Filter operator does not work for List
[ https://issues.apache.org/jira/browse/HIVE-18999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16415874#comment-16415874 ] Steve Yeom commented on HIVE-18999: --- We can further shorten the test case: create table table1(col1 bigint); insert into table1 values (2014); -- CORRECT SELECT COUNT(t1.col1) from table1 t1 where struct(col1) in (struct("2014")); -- INCORRECT SELECT COUNT(t1.col1) from table1 t1 where struct(col1) in (struct(2014)); create table table2(col2 int); insert into table2 values (2014); -- CORRECT SELECT COUNT(t2.col2) from table2 t2 where struct(col2) in (struct(2014)); > Filter operator does not work for List > -- > > Key: HIVE-18999 > URL: https://issues.apache.org/jira/browse/HIVE-18999 > Project: Hive > Issue Type: Bug > Components: Query Processor >Affects Versions: 3.0.0 >Reporter: Steve Yeom >Assignee: Steve Yeom >Priority: Major > > {code:sql} > create table table1(col0 int, col1 bigint, col2 string, col3 bigint, col4 > bigint); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2015, 11); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2013, 11); > -- INCORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct(2014,11)); > -- CORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct('2014','11')); > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-18999) Filter operator does not work for List
[ https://issues.apache.org/jira/browse/HIVE-18999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16408696#comment-16408696 ] Jesus Camacho Rodriguez commented on HIVE-18999: Cc [~ashutoshc] > Filter operator does not work for List > -- > > Key: HIVE-18999 > URL: https://issues.apache.org/jira/browse/HIVE-18999 > Project: Hive > Issue Type: Bug > Components: Query Processor >Affects Versions: 3.0.0 >Reporter: Steve Yeom >Priority: Major > > {code:sql} > create table table1(col0 int, col1 bigint, col2 string, col3 bigint, col4 > bigint); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2015, 11); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2013, 11); > -- INCORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct(2014,11)); > -- CORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct('2014','11')); > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-18999) Filter operator does not work for List
[ https://issues.apache.org/jira/browse/HIVE-18999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16408695#comment-16408695 ] Gopal V commented on HIVE-18999: This is broken because the constant structs are being constructed with Struct(Int, Int) and they don't compare with Struct(Long,Long) from the bigint on the Table side. > Filter operator does not work for List > -- > > Key: HIVE-18999 > URL: https://issues.apache.org/jira/browse/HIVE-18999 > Project: Hive > Issue Type: Bug > Components: Query Processor >Affects Versions: 3.0.0 >Reporter: Steve Yeom >Priority: Major > > {code:sql} > create table table1(col0 int, col1 bigint, col2 string, col3 bigint, col4 > bigint); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2015, 11); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2013, 11); > -- INCORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct(2014,11)); > -- CORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct('2014','11')); > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-18999) Filter operator does not work for List
[ https://issues.apache.org/jira/browse/HIVE-18999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16406702#comment-16406702 ] Steve Yeom commented on HIVE-18999: --- I have reproduced the test case failure in the current master. > Filter operator does not work for List > -- > > Key: HIVE-18999 > URL: https://issues.apache.org/jira/browse/HIVE-18999 > Project: Hive > Issue Type: Bug > Components: Query Processor >Affects Versions: 3.0.0 >Reporter: Steve Yeom >Priority: Major > > {code:sql} > create table table1(col0 int, col1 bigint, col2 string, col3 bigint, col4 > bigint); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2015, 11); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2013, 11); > -- INCORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct(2014,11)); > -- CORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct('2014','11')); > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-18999) Filter operator does not work for List
[ https://issues.apache.org/jira/browse/HIVE-18999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16406630#comment-16406630 ] Gopal V commented on HIVE-18999: [~steveyeom2017]: are you mixing up internal and external tickets? The EAR references makes no sense for Apache JIRAs - I removed the one in the descriptions. > Filter operator does not work for List > -- > > Key: HIVE-18999 > URL: https://issues.apache.org/jira/browse/HIVE-18999 > Project: Hive > Issue Type: Bug > Components: Query Processor >Affects Versions: 3.0.0 >Reporter: Steve Yeom >Priority: Major > > set hive.optimize.point.lookup=false; > > create table table1(col0 int, col1 bigint, col2 string, col3 bigint, col4 > bigint); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2015, 11); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2013, 11); > -- INCORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct(2014,11)); > -- CORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct('2014','11')); -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-18999) Filter operator does not work for List
[ https://issues.apache.org/jira/browse/HIVE-18999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16406627#comment-16406627 ] Steve Yeom commented on HIVE-18999: --- Cautiously speaking, it seems to exist in master from my testing. But there could a chance that EAR-8093 case may be different from this. > Filter operator does not work for List > -- > > Key: HIVE-18999 > URL: https://issues.apache.org/jira/browse/HIVE-18999 > Project: Hive > Issue Type: Bug > Components: Query Processor >Affects Versions: 3.0.0 >Reporter: Steve Yeom >Priority: Major > > I have reproduced at the current master. > set hive.optimize.point.lookup=false; > > create table table1(col0 int, col1 bigint, col2 string, col3 bigint, col4 > bigint); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2015, 11); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2013, 11); > -- INCORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct(2014,11)); > -- CORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct('2014','11')); -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-18999) Filter operator does not work for List
[ https://issues.apache.org/jira/browse/HIVE-18999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16406624#comment-16406624 ] Jesus Camacho Rodriguez commented on HIVE-18999: [~steveyeom2017], is this a duplicate of HIVE-18610? Or does it still exist in master? Cc [~gopalv] > Filter operator does not work for List > -- > > Key: HIVE-18999 > URL: https://issues.apache.org/jira/browse/HIVE-18999 > Project: Hive > Issue Type: Bug > Components: Query Processor >Affects Versions: 3.0.0 >Reporter: Steve Yeom >Priority: Major > > The repro is from EAR-8093 , especially by [~jcamachorodriguez]. > I have reproduced at the current master. > set hive.optimize.point.lookup=false; > > create table table1(col0 int, col1 bigint, col2 string, col3 bigint, col4 > bigint); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2015, 11); > insert into table1 values (1, 1, 'ccl',2014, 11); > insert into table1 values (1, 1, 'ccl',2013, 11); > -- INCORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct(2014,11)); > -- CORRECT > SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in > (struct('2014','11')); -- This message was sent by Atlassian JIRA (v7.6.3#76005)