随笔分类 -  MaxCompute

MaxCompute将json数组拆分成多行
摘要：select GET_JSON_OBJECT(name_tmp,'$.val') as val ,GET_JSON_OBJECT(name_tmp,'$.area') as area ,GET_JSON_OBJECT(name_tmp,'$.setVal') as setVal ,GET_JSON_ 阅读全文
posted @ 2020-05-19 11:05 chenzechao 阅读(2966) 评论(0) 推荐(0) 编辑
一行中多列取最大值和最小值
摘要：select name ,greatest(num1,num2,num3,num4) as max_num -- 最大值 ,least(num1,num2,num3,num4) as min_num -- 最小值 from ( select 'a' as name,1 as num1, 3 as num2, 2 as num3,4 as num4 ) t1 ; 阅读全文
posted @ 2019-12-19 16:39 chenzechao 阅读(783) 评论(0) 推荐(0) 编辑
maxCompute odps 行转列
摘要：select name ,REGEXP_REPLACE(str,"[\\[\"\\]]",'') from ( select trans_array(1, ",", name,list) as (name,str) from ( select '经办人' as name,'["1001","1002"]' as list ) ... 阅读全文
posted @ 2019-05-30 11:28 chenzechao 阅读(3861) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示