Hive 全局排序

Hive全局排序取清单

CREATE TABLE tmp2 AS
SELECt *
FROM tmp 
DISTRIBUTE BY (
	CASE WHEN year < 1930 THEN 0 
		 WHEN year > 1960 THEN 2 
		 ELSE 1 
	END) 
SORT BY (year ASC, t DESC);

Hive全局排序取TopN

--从表中获取name长度为TOP10的数据
SELECt a.id, a.name
FROM (
    SELECt id, name
    FROM tableA
        DISTRIBUTE BY length(name) SORT BY length(name) DESC
    LIMIT 10
) a
ORDER BY LENGTH(a.name) DESC
LIMIT 10;