[jira] [Updated] (HIVE-24614) using coalesce via vector,when date type of column are different between source and target,the result of target is zero

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

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

taoyuyin updated HIVE-24614:
----------------------------
    Environment:     (was: set hive.vectorized.execution.enabled=true;

 

CREATE TABLE `tmp.tmp_test_vectorization_source`( 
`rn` string,
`val_1` int,
`val_2` bigint)
stored as parquet;

 

insert into table `tmp.tmp_test_vectorization_source` values('line1',1000,10001),('line1',2000,20001);

 

select rn,val_1,val_2 from tmp.tmp_test_vectorization_source t;

 

+--------+--------+--------+
| rn | val_1 | val_2 |
+--------+--------+--------+
| line1 | 1000 | 10001 |
| line1 | 2000 | 20001 |
+--------+--------+--------+

 

CREATE TABLE `tmp.tmp_test_vectorization_target`( 
`rn` string,
`val_1` bigint,
`val_2` int)
stored as parquet;

 

insert into table tmp.tmp_test_vectorization_target
select
rn,
coalesce(val_1,0),
coalesce(val_2,0)
from tmp.tmp_test_vectorization_source;

 

select rn,val_1,val_2 from tmp.tmp_test_vectorization_target t;

 

+--------+--------+--------+
| rn | val_1 | val_2 |
+--------+--------+--------+
| line1 | 0 | 0 |
| line1 | 0 | 0 |
+--------+--------+--------+)

> using coalesce via vector,when date type of column are different between source and target,the result of target is zero
> -----------------------------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-24614
>                 URL: https://issues.apache.org/jira/browse/HIVE-24614
>             Project: Hive
>          Issue Type: Bug
>          Components: Vectorization
>    Affects Versions: 3.1.2
>            Reporter: taoyuyin
>            Priority: Major
>




--
This message was sent by Atlassian Jira
(v8.3.4#803005)