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 2018/11/07 16:00:00 UTC
[jira] [Created] (HIVE-20881) Constant propagation oversimplifies
projections
Zoltan Haindrich created HIVE-20881:
---------------------------------------
Summary: Constant propagation oversimplifies projections
Key: HIVE-20881
URL: https://issues.apache.org/jira/browse/HIVE-20881
Project: Hive
Issue Type: Bug
Reporter: Zoltan Haindrich
Assignee: Zoltan Haindrich
{code:java}
create table cx2(bool1 boolean);
insert into cx2 values (true),(false),(null);
set hive.cbo.enable=true;
select bool1 IS TRUE OR (cast(NULL as boolean) AND bool1 IS NOT TRUE AND bool1 IS NOT FALSE) from cx2;
+--------+
| _c0 |
+--------+
| true |
| false |
| NULL |
+--------+
set hive.cbo.enable=false;
select bool1 IS TRUE OR (cast(NULL as boolean) AND bool1 IS NOT TRUE AND bool1 IS NOT FALSE) from cx2;
+-------+
| _c0 |
+-------+
| true |
| NULL |
| NULL |
+-------+
{code}
from explain it seems the expression was simplified to: {{(_col0 is true or null)}}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)