Review Board 1.7.22


Implemented end-to-end support for SUBSTR() with changes to VectorizationContext class

Review Request #12926 - Created July 24, 2013 and updated

Eric Hanson
vectorization
HIVE-4512
Reviewers
hive
hive-git
Implemented end-to-end support for SUBSTR() with changes to VectorizationContext class
Verified all these queries run vectorized:

explain 
select l_shipmode, concat(l_shipmode, "<<<")
from lineitem_orc 
where l_orderkey = 1;

select l_shipmode, concat('>>>', l_shipmode)
from lineitem_orc 
where l_orderkey = 1;

select l_shipmode, concat('>>>', l_shipmode)
from lineitem_orc 
where l_orderkey = 1
and lower(l_shipmode) = 'mail';


select l_shipmode, concat(l_shipmode, l_shipmode)
from lineitem_orc 
where l_orderkey = 1;

select l_shipmode, concat(lower(l_shipmode), upper(lower(l_shipmode)))
from lineitem_orc 
where l_orderkey = 1;
Total:
1
Open:
0
Resolved:
1
Dropped:
0
Status:
From:
Description From Last Updated Status
Posted (July 25, 2013, 5:56 p.m.)

   

  
I think it should be Concat??