maxCompute odps 行转列

最新推荐文章于 2024-05-24 22:25:50 发布

weixin_30411819

最新推荐文章于 2024-05-24 22:25:50 发布

阅读量2.1k

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/chenzechao/p/10948596.html

select
     name
    ,REGEXP_REPLACE(str,"[\\[\"\\]]",'')
from (
    select
        trans_array(1, ",", name,list) as (name,str)
    from (
    select '经办人' as name,'["1001","1002"]' as list
    ) t1
) t2
;

select 
    trans_array(1, ",", name,REGEXP_REPLACE(list,"[\\[\"\\]]",'')) as (name,str)
from (
select '经办人' as name,'["1001","1002"]' as list
) t1
;

select
     name
    ,list_tmp
from (
    select '经办人' as name,'["1001","1002"]' as list
) t1
lateral view explode(split(REGEXP_REPLACE(list,"[\\[\"\\]]",''),',')) b AS list_tmp
;