AMP SKEW

SELECT
HASHAMP (HASHBUCKET(HASHROW (
dt_dat_cre ,cd_prod_div ,cd_dpt ,cd_main_acct ,cd_dtl_acct ,cd_sub_acct ,cd_bu ,id_itm ,cd_loc ,cd_crcy
))) AS "AMP NO"
,COUNT(*)
FROM dwhtst.TAPD_BLNC_DAY
GROUP BY 1
ORDER BY 2 DESC;

Tweet