blob: c28d26e27905453b784700a38fe680ee62bbe3f5 [file] [log] [blame]
--! qt:dataset:src
set hive.mapred.mode=nonstrict;
explain
select concat(*),array(*) from src where key < 100 limit 10;
select concat(*),array(*) from src where key < 100 limit 10;
-- The order of columns is decided by row schema of prev operator
-- Like join which has two or more aliases, it's from left most aias to right aliases.
explain
select stack(2, *) as (e1,e2,e3) from (
select concat(*), concat(a.*), concat(b.*), concat(a.*, b.key), concat(a.key, b.*)
from src a join src b on a.key+1=b.key where a.key < 100) x limit 10;
select stack(2, *) as (e1,e2,e3) from (
select concat(*), concat(a.*), concat(b.*), concat(a.*, b.key), concat(a.key, b.*)
from src a join src b on a.key+1=b.key where a.key < 100) x limit 10;
-- HIVE-4181 TOK_FUNCTIONSTAR for UDTF
create table allcolref as select array(key, value) from src;
explain select explode(*) as x from allcolref limit 10;
select explode(*) as x from allcolref limit 10;