You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Zoltan Haindrich (JIRA)" <ji...@apache.org> on 2019/03/29 15:07:00 UTC
[jira] [Created] (HIVE-21544) Constant propagation corrupts
coalesce/case/when expressions during folding
Zoltan Haindrich created HIVE-21544:
---------------------------------------
Summary: Constant propagation corrupts coalesce/case/when expressions during folding
Key: HIVE-21544
URL: https://issues.apache.org/jira/browse/HIVE-21544
Project: Hive
Issue Type: Bug
Reporter: Zoltan Haindrich
Assignee: Zoltan Haindrich
{code}
set hive.fetch.task.conversion=none;
set hive.optimize.ppd=false;
create table t (s1 string,s2 string);
insert into t values (null,null);
explain
select
coalesce(s1, 'null_value' ), coalesce(s2, 'null_value' ),
coalesce(s1, 'null_value' )=coalesce(s2, 'null_value' ),
case when coalesce(s1, 'null_value' )=coalesce(s2, 'null_value' ) then 'eq' else 'noteq' end
from t;
select
coalesce(s1, 'null_value' ), coalesce(s2, 'null_value' ),
coalesce(s1, 'null_value' )=coalesce(s2, 'null_value' ),
case when coalesce(s1, 'null_value' )=coalesce(s2, 'null_value' ) then 'eq' else 'noteq' end
from t;
{code}
incorrect result is:
{code}
null_value null_value NULL noteq
{code}
expected result:
{code}
null_value null_value true eq
{code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)