[
https://issues.apache.org/jira/browse/HIVE-25169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17353306#comment-17353306
]
Panagiotis Garefalakis commented on HIVE-25169:
-----------------------------------------------
Hey [~junnan.yang] thanks for reporting this! Would it make sense to backport
the ticket that resolved this from master?
On a general note it would be much easier to review this with a github PR and a
test case.
Cheers
> 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)
