在Impala中选择堆栈() UDTF

Question

在Hive中，我可以使用堆栈() UDTF对数据进行如下示例：

with students as ( 
select stack(5,
1,'Vikrant',
2,'Abhishek',
3,'Ragesh',
4,'Valeriy',
5,'Swarna') as (id, name)
)

select * from students;

在Presto 我可以用价值中也是如此。

除了用每个行和UNION的多个选择都类似于这个答案，我怎么能在黑斑羚里做这件事呢？

Answer 1

正如我所研究的，Impala还不支持表生成函数。不幸的是，黑斑羚没有堆栈，无侧视爆炸，不可能有UDTF。

所以，唯一的办法是：

with students as ( 
select 1 as id,'Vikrant'  as name union all
select 2 as id,'Abhishek' as name union all
select 3 as id,'Ragesh'   as name union all
select 4 as id,'Valeriy'  as name union all
select 5 as id,'Swarna'   as name
)

select * from students;