hive数组排序

最新推荐文章于 2024-08-25 03:52:23 发布

wgdzz

最新推荐文章于 2024-08-25 03:52:23 发布

阅读量6.7k

点赞数

分类专栏： hive

本文链接：https://blog.csdn.net/wgdzz/article/details/105950594

版权

hive 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

hive数组排序

hive中关于数组内部排序等函数主要有以下两个：

sort_array

sort_array(array(obj1, obj2,…)) - Sorts the input array in ascending order according to the natural ordering of the array elements.
Example:

SELECT sort_array(array('b', 'd', 'c', 'a')) FROM src LIMIT 1;'a', 'b', 'c', 'd'

Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFSortArray
Function type:BUILTIN

sort_array_by

sort_array_by(array(obj1, obj2,…),‘f1’,‘f2’,…,[‘ASC’,‘DESC’]) - Sorts the input tuple array in user specified order(ASC,DESC) by desired field[s] name If sorting order is not mentioned by user then dafault sorting order is ascending
Example:

SELECT sort_array_by(array(struct('g',100),struct('b',200)),'col1','ASC') FROM src LIMIT 1;array(struct('b',200),struct('g',100))

Function class:org.apache.hadoop.hive.ql.udf.generic.GenericUDFSortArrayByField
Function type:BUILTIN

https://www.iteblog.com/archives/2032.html#sort_array_by
https://github.com/apache/hive/blob/master/ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDFSortArrayByField.java