You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "ASF GitHub Bot (Jira)" <ji...@apache.org> on 2022/12/07 20:42:00 UTC
[jira] [Work logged] (HIVE-26819) Vectorization: wrong results when filter on repeating map key orc table
[ https://issues.apache.org/jira/browse/HIVE-26819?focusedWorklogId=831878&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-831878 ]
ASF GitHub Bot logged work on HIVE-26819:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 07/Dec/22 20:41
Start Date: 07/Dec/22 20:41
Worklog Time Spent: 10m
Work Description: yigress opened a new pull request, #3844:
URL: https://github.com/apache/hive/pull/3844
### What changes were proposed in this pull request?
fix data correctness bug when query on map in orc table in vectorization mode.
### Why are the changes needed?
to fix data correctness bug
### Does this PR introduce _any_ user-facing change?
No
### How was this patch tested?
Tested with qtest and locally
Issue Time Tracking
-------------------
Worklog Id: (was: 831878)
Remaining Estimate: 0h
Time Spent: 10m
> 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
> Time Spent: 10m
> Remaining Estimate: 0h
>
> 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)