[
https://issues.apache.org/jira/browse/HIVE-25169?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
junnan.yang updated HIVE-25169:
-------------------------------
Description:
sourceTable:
product_id int;
###########################################
targetTable:
product_id bigint;
##########################################
sql:
insert overwrite table targetTable:
select
......
coalesce(product_id,-1),
......
from sourceTable;
##########################################
explain sql :
UDFToLong(COALESCE(product_id,-1)) (type: bigint)
##########################################
result :
the column product_id in targetTable is zero, this is wrong result
was:
source table:
product_id int;
###########################################
target table:
product_id bigint;
##########################################
sql:
coalesce(product_id,-1)
##########################################
explain sql :
##########################################
> using coalesce via vector,source column type is int and target column type is
> bigint,the result of target is zero
> -----------------------------------------------------------------------------------------------------------------
>
> Key: HIVE-25169
> URL: https://issues.apache.org/jira/browse/HIVE-25169
> Project: Hive
> Issue Type: Bug
> Components: Vectorization
> Affects Versions: 3.1.2
> Reporter: junnan.yang
> Priority: Major
> Attachments: HIVE-25169.01.patch
>
>
> sourceTable:
> product_id int;
> ###########################################
> targetTable:
> product_id bigint;
> ##########################################
> sql:
> insert overwrite table targetTable:
> select
> ......
> coalesce(product_id,-1),
> ......
> from sourceTable;
> ##########################################
> explain sql :
> UDFToLong(COALESCE(product_id,-1)) (type: bigint)
> ##########################################
> result :
> the column product_id in targetTable is zero, this is wrong result
>
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
