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

junnan.yang updated HIVE-25169:
-------------------------------
    Description: 
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
>
>
> source table:
>     product_id int;
> ###########################################
> target table:
>     product_id bigint;
> ##########################################
> sql: 
>      coalesce(product_id,-1)
> ##########################################
> explain sql :
>  
> ##########################################
>      
>  
>  



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

Reply via email to