[jira] [Commented] (HIVE-19399) Down cast from int to tinyint generating incorrect value for vectorization
[ https://issues.apache.org/jira/browse/HIVE-19399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16497598#comment-16497598 ] Vihang Karajgaonkar commented on HIVE-19399: Hi [~jerrychenhf] Can you please repeat the test by setting {{hive.vectorized.use.checked.expressions}} to true? > Down cast from int to tinyint generating incorrect value for vectorization > -- > > Key: HIVE-19399 > URL: https://issues.apache.org/jira/browse/HIVE-19399 > Project: Hive > Issue Type: Bug > Components: Vectorization >Affects Versions: 3.1.0 >Reporter: Haifeng Chen >Priority: Major > > The following sql scripts generating different result for vectorization > disabled and enabled (both for ORC and for parquet). > drop table test_schema; > create table test_schema (f int) stored as parquet; > insert into test_schema values ('9'); > select cast(f as tinyint) + 1 from test_schema; > For non-vectorization, the result is -96 while for vectorization mode, it is > 10 > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-19399) Down cast from int to tinyint generating incorrect value for vectorization
[ https://issues.apache.org/jira/browse/HIVE-19399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16471364#comment-16471364 ] Bharathkrishna Guruvayoor Murali commented on HIVE-19399: - I am interested in working on this Jira as it is a chance for me to get familiarized with vectorization related stuff! If nobody is planning to work on it soon, I can take a look at this :) > Down cast from int to tinyint generating incorrect value for vectorization > -- > > Key: HIVE-19399 > URL: https://issues.apache.org/jira/browse/HIVE-19399 > Project: Hive > Issue Type: Bug > Components: Vectorization >Affects Versions: 3.1.0 >Reporter: Haifeng Chen >Priority: Major > > The following sql scripts generating different result for vectorization > disabled and enabled (both for ORC and for parquet). > drop table test_schema; > create table test_schema (f int) stored as parquet; > insert into test_schema values ('9'); > select cast(f as tinyint) + 1 from test_schema; > For non-vectorization, the result is -96 while for vectorization mode, it is > 10 > -- This message was sent by Atlassian JIRA (v7.6.3#76005)