You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Vihang Karajgaonkar (JIRA)" <ji...@apache.org> on 2018/01/10 03:00:16 UTC
[jira] [Created] (HIVE-18421) Vectorized execution does not handle
integer overflows
Vihang Karajgaonkar created HIVE-18421:
------------------------------------------
Summary: Vectorized execution does not handle integer overflows
Key: HIVE-18421
URL: https://issues.apache.org/jira/browse/HIVE-18421
Project: Hive
Issue Type: Bug
Components: Vectorization
Affects Versions: 2.3.2, 2.2.0, 2.1.1, 3.0.0
Reporter: Vihang Karajgaonkar
Assignee: Vihang Karajgaonkar
In vectorized execution arithmetic operations which cause integer overflows can give wrong results. Issue is reproducible in both Orc and parquet.
Simple test case to reproduce this issue
{noformat}
set hive.vectorized.execution.enabled=true;
create table parquettable (t1 tinyint, t2 tinyint) stored as parquet;
insert into parquettable values (-104, 25), (-112, 24), (54, 9);
select t1, t2, (t1-t2) as diff from parquettable where (t1-t2) < 50 order by diff desc;
+-------+-----+-------+
| t1 | t2 | diff |
+-------+-----+-------+
| -104 | 25 | 127 |
| -112 | 24 | 120 |
| 54 | 9 | 45 |
+-------+-----+-------+
{noformat}
When vectorization is turned off the same query produces only one row.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)