blob: d4591e8fdcd5268c022b05b148473889a611bf7b [file] [log] [blame]
create table tez_test_t1(md_exper string);
insert into tez_test_t1 values('tez_test_t1-md_expr');
create table tez_test_t5(md_exper string, did string);
insert into tez_test_t5 values('tez_test_t5-md_expr','tez_test_t5-did');
create table tez_test_t2(did string);
insert into tez_test_t2 values('tez_test_t2-did');
explain
SELECT NULL AS first_login_did
FROM tez_test_t5
LATERAL VIEW explode(split('0,6', ',')) gaps AS ads_h5_gap
UNION ALL
SELECT null as first_login_did
FROM tez_test_t1
UNION ALL
SELECT did AS first_login_did
FROM tez_test_t2;
SELECT NULL AS first_login_did
FROM tez_test_t5
LATERAL VIEW explode(split('0,6', ',')) gaps AS ads_h5_gap
UNION ALL
SELECT null as first_login_did
FROM tez_test_t1
UNION ALL
SELECT did AS first_login_did
FROM tez_test_t2;