Zoltan Haindrich created HIVE-19357:
---------------------------------------

             Summary: vectorization breaks assert functionality
                 Key: HIVE-19357
                 URL: https://issues.apache.org/jira/browse/HIVE-19357
             Project: Hive
          Issue Type: Bug
          Components: Vectorization
            Reporter: Zoltan Haindrich


This could be limited to assert exceptions; but might interfere with other 
exceptions...discovered while "fixing" testreopt after HIVE-19269

{code}
create table tu(id_uv int,id_uw int,u int);
create table tv(id_uv int,v int);
create table tw(id_uw int,w int);

insert into tu values 
(10,10,10),(1,1,1),(2,2,2),(3,3,3),(4,4,4),(5,5,5),(6,6,6);
insert into tv values (10,10),(1,1),(2,2),(3,3);
insert into tw values 
(10,10),(1,1),(2,2),(3,3),(4,4),(5,5),(6,6),(7,7),(8,8),(9,9);

set zzz=0;
set hive.vectorized.execution.enabled=false;
select assert_true(${hiveconf:zzz}>sum(1)) from tu join tv on 
(tu.id_uv=tv.id_uv) where u<10 and v>1;
-- fails as expected

set hive.vectorized.execution.enabled=true;
select assert_true(${hiveconf:zzz}>sum(1)) from tu join tv on 
(tu.id_uv=tv.id_uv) where u<10 and v>1;
-- there is a result set
{code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to