hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aihua Xu (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-13235) Insert from select generates incorrect result when hive.optimize.constant.propagation is on
Date Tue, 08 Mar 2016 21:26:41 GMT
Aihua Xu created HIVE-13235:
-------------------------------

             Summary: Insert from select generates incorrect result when hive.optimize.constant.propagation
is on
                 Key: HIVE-13235
                 URL: https://issues.apache.org/jira/browse/HIVE-13235
             Project: Hive
          Issue Type: Bug
          Components: Query Planning
    Affects Versions: 2.0.0
            Reporter: Aihua Xu
            Assignee: Aihua Xu


The following query returns incorrect result when constant optimization is turned on. The
subquery happens to have an alias p1 to be the same as the input partition name. Constant
optimizer will optimize it incorrectly as the constant.

When constant optimizer is turned off, we will get the correct result.
{noformat}
set hive.cbo.enable=false;
set hive.optimize.constant.propagation = true;
create table t1(c1 string, c2 double) partitioned by (p1 string, p2 string);
create table t2(p1 double, c2 string);
insert into table t1 partition(p1='40', p2='p2') values('c1', 0.0);
INSERT OVERWRITE TABLE t2  select if((c2 = 0.0), c2, '0') as p1, 2 as p2 from t1 where c1
= 'c1' and p1 = '40';
select * from t2;

40   2
{noformat}




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message