INSERT OVERWRITE TABLE test_data_resultSELECT  id        ,ROW_NUMBER() OVER (ORDER BY id ASC ) AS rnFROM    test_data;

--第一步WITH hash_bucket AS (SELECT  id            ,ROW_NUMBER() OVER (PARTITION BY bucket_no ORDER BY id ASC ) AS bucket_rel_index            ,COUNT(1) OVER (PARTITION BY bucket_no ) AS bucket_size            ,bucket_noFROM    (SELECT  id                        ,ABS(HASH(id)) % 100000 AS bucket_noFROM    test_data            ) )--第二步,bucket_base AS (SELECT  bucket_no            ,SUM(bucket_size) OVER (ORDER BY bucket_no ASC ) - bucket_size AS bucket_baseFROM    (SELECT  DISTINCT bucket_no                        ,bucket_sizeFROM    hash_bucket            ) )--第三步INSERT OVERWRITE TABLE sort_data_result_1SELECT  /*+ MAPJOIN(t2) */        t1.id        ,t2.bucket_base + bucket_rel_index AS id_indexFROM    hash_bucket t1JOIN    bucket_base t2ON      t1.bucket_no = t2.bucket_no;