[HIVE-25169] using coalesce via vector,source column type is int and target column type is bigint,the result of target is zero

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.1.2
• Component/s: Vectorization
• Assignee: Unassigned
• Reporter: junnan.yang
• Created: 27/May/21 03:44
• Updated: 28/May/21 11:56

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