blob: e24f8a7cadfc391622ddbe7c16938eae22c1ee44 [file] [log] [blame]
--! qt:dataset:src
set hive.fetch.task.conversion=more;
SET hive.vectorized.execution.enabled=false;
describe function inline;
explain SELECT inline(
ARRAY(
STRUCT (1,'dude!'),
STRUCT (2,'Wheres'),
STRUCT (3,'my car?')
)
) as (id, text) FROM SRC limit 2;
SELECT inline(
ARRAY(
STRUCT (1,'dude!'),
STRUCT (2,'Wheres'),
STRUCT (3,'my car?')
)
) as (id, text) FROM SRC limit 2;
-- HIVE-3475 INLINE UDTF doesn't convert types properly
select * from (SELECT
ARRAY(
STRUCT (1,'dude!'),
STRUCT (2,'Wheres'),
STRUCT (3,'my car?')
) as value FROM SRC limit 1) input
LATERAL VIEW inline(value) myTable AS id, text;