- Hive全局排序取清单
CREATE TABLE tmp2 AS
SELECT *
FROM tmp
DISTRIBUTE BY (
CASE WHEN year < 1930 THEN 0
WHEN year > 1960 THEN 2
ELSE 1<
CREATE TABLE tmp2 AS
SELECT *
FROM tmp
DISTRIBUTE BY (
CASE WHEN year < 1930 THEN 0
WHEN year > 1960 THEN 2
ELSE 1<