You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Panagiotis Garefalakis (Jira)" <ji...@apache.org> on 2021/05/28 11:57:00 UTC
[jira] [Commented] (HIVE-25169) using coalesce via vector,source
column type is int and target column type is bigint,the result of target is
zero
[ 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)