0- 描述
描述:容器–反转内容
表名:t10
表字段及内容:
a
AB,CA,BAD
BD,EA
1- 问题一
描述:反转逗号分隔的数据:改变顺序,内容不变
输出结果如下所示:
BAD,CA,AB
EA,BD
参考答案:
select
a,
concat_ws(",",collect_list(str))
from
(
select
a,
str
from t10
lateral view explode(split(reverse(a),",")) t as str
) tmp1
group by a;
2- 问题二
描述:反转逗号分隔的数据:改变内容,顺序不变
输出结果如下所示:
BA,AC,DAB
DB,AE
参考答案:
select
a,
concat_ws(",",collect_list(reverse(str)))
from
(
select
a,
str
from t10
lateral view explode(split(a,",")) t as str
) tmp1
group by a;