我有一个像下面这样的表数据,我想用聚合来透视数据。
ColumnA ColumnB ColumnC
1 complete Yes
1 complete Yes
2 In progress No
2 In progress No
3 Not yet started initiate
3 Not yet started initiate
想要像下面这样透视
ColumnA Complete In progress Not yet started
1 2 0 0
2 0 2 0
3 0 0 2
我们有没有办法在hive或Impala中实现这一点?
https://stackoverflow.com/questions/52191603
复制相似问题