concat_ws, spilt, sort_array,size
16lz
2021-12-04
这三个字段,通过各个函数结果
concat_ws
用相应符号将各字段连接起来 string类型
select concat_ws(',',user_id,mobile,system) as concatfrom statistic.qz_tracklimit 5;concat"13742988,,android""38643821,+8613075351265,android""11230781,,android""38702379,,android""0,+8613414655611,android"
spilt
将上述结果通过spilt , 分开
select split(concat_ws(",",user_id,mobile,system), ",") con_spfrom statistic.qz_tracklimit 5;con_sp"[""13742988"","""",""android""]""[""38643821"",""+8613075351265"",""android""]""[""11230781"","""",""android""]""[""38702379"","""",""android""]""[""0"",""+8613414655611"",""android""]"
sort_array 默认升序
select sort_array(split(concat_ws(",",user_id,mobile,system), ",")) as con_safrom statistic.qz_tracklimit 5;con_sa"["""",""13742988"",""android""]""[""+8613075351265"",""38643821"",""android""]""["""",""11230781"",""android""]""["""",""38702379"",""android""]""[""+8613414655611"",""0"",""android""]"
更多相关文章
- Ubuntu18.04配置ADB调试环境
- android之无返回结果跳转intent
- ANDROID轻量级JSON序列化和反序列化
- Android—复选框和单选框使用
- android之PopUpWindow显示Listview(文件列表)
- android content命令
- Android(安卓)GreenDao3.2配置及使用详解
- android之无返回结果跳转intent
- Android(安卓)SDK 和Oralce 也有冲突