[jira] [Updated] (HIVE-26819) Vectorization: wrong results when filter on repeating map key orc table

["Yi Zhang (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-26819?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Yi Zhang updated HIVE-26819:
----------------------------
    Description: 
Same issue is fixed by HIVE-26447, this is to fix in 3.2.0. 

Example reproducible case:

set hive.vectorized.execution.enabled=true;

set hive.fetch.task.conversion=none;

create temporary table foo (id int, x map<string,int>) stored as orc;
insert into foo values(1, map('ABC', 9)), (2, map('ABC', 7)), (3, map('ABC', 8)), (4, map('ABC', 9));

select id from foo where x['ABC']=9;

this only gives 1, when correct result should be 1,4

For every VectorizedRowBatch, only the first row is checked.  

This seems to be a corner case of ORC table have repeating string type key for map field in the MapColumnVector.

  was:Same issue is fixed by HIVE-26447, this is to fix in 3.2.0. 


> Vectorization: wrong results when filter on repeating map key orc table
> -----------------------------------------------------------------------
>
>                 Key: HIVE-26819
>                 URL: https://issues.apache.org/jira/browse/HIVE-26819
>             Project: Hive
>          Issue Type: Bug
>          Components: Hive
>    Affects Versions: 3.1.3
>            Reporter: Yi Zhang
>            Priority: Minor
>
> Same issue is fixed by HIVE-26447, this is to fix in 3.2.0. 
> Example reproducible case:
> set hive.vectorized.execution.enabled=true;
> set hive.fetch.task.conversion=none;
> create temporary table foo (id int, x map<string,int>) stored as orc;
> insert into foo values(1, map('ABC', 9)), (2, map('ABC', 7)), (3, map('ABC', 8)), (4, map('ABC', 9));
> select id from foo where x['ABC']=9;
> this only gives 1, when correct result should be 1,4
> For every VectorizedRowBatch, only the first row is checked.  
> This seems to be a corner case of ORC table have repeating string type key for map field in the MapColumnVector.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)