-- SORT_QUERY_RESULTS
set hive.mapred.mode=nonstrict;
set hive.explain.user=false;
SET hive.vectorized.execution.enabled=true;
set hive.fetch.task.conversion=none;
SET hive.auto.convert.join=true;

CREATE TABLE test_1_n0 (member BIGINT, attr BIGINT) STORED AS ORC; 

CREATE TABLE test_2_n0 (member BIGINT) STORED AS ORC;

INSERT INTO test_1_n0 VALUES (3,1),(2,2); 
INSERT INTO test_2_n0 VALUES (1),(2),(3),(4); 

-- Add a single NULL row that will come from ORC as isRepeated.
insert into test_1_n0 values (NULL, NULL);
insert into test_2_n0 values (NULL);


EXPLAIN VECTORIZATION DETAIL
SELECT m.member, (CASE WHEN COALESCE(n.attr, 5)>1 THEN n.attr END) AS attr 
FROM test_2_n0 m LEFT JOIN test_1_n0 n ON m.member = n.member; 

SELECT m.member, (CASE WHEN COALESCE(n.attr, 5)>1 THEN n.attr END) AS attr 
FROM test_2_n0 m LEFT JOIN test_1_n0 n ON m.member = n.member;