select
conv((`id`/N),N,N) as batch,
concat(
sum(conv(substring(md5(concat_ws("S",`id`,`area`,`dept`,`fund_type`,`fund`,`org`,`sort_group`,`rev_src_code`,`obj_exp_code`,`sub_org`,`origin_ref_code`,`origin_ref_num`,`accept_date`,`invoice_num`,`trans_code`,`trans_num`,`trans_line_num`,`reporting_grp`,`reporting_ledger`,`approp_unit`,`acct_code`,` back_ref_code`,`back_ref_num`,`record_date`,`budg_fiscal_yr`,`src_acctg_fiscal_prd`,`vendor_code`,`vendor_name`,`trans_line_num_descr`,`function`,`sub_obj_code`,`sub_rev_src_code`,`job_num`,`trans_amt`,`commit`,`level1_org`,`level2_org`,`level3_org`,`level4_org`,`level5_org`,`level6_org`,`level7_org`,`level8_org`,`acctg_fiscal_prd`,`fund10_sum_type`)),N,N),N,N)),
sum(conv(substring(md5(concat_ws("S",`id`,`area`,`dept`,`fund_type`,`fund`,`org`,`sort_group`,`rev_src_code`,`obj_exp_code`,`sub_org`,`origin_ref_code`,`origin_ref_num`,`accept_date`,`invoice_num`,`trans_code`,`trans_num`,`trans_line_num`,`reporting_grp`,`reporting_ledger`,`approp_unit`,`acct_code`,`back_ref_code`,`back_ref_num`,`record_date`,`budg_fiscal_yr`,`src_acctg_fiscal_prd`,`vendor_code`,`vendor_name`,`trans_line_num_descr`,`function`,`sub_obj_code`,`sub_rev_src_code`,`job_num`,`trans_amt`,`commit`,`level1_org`,`level2_org`,`level3_org`,`level4_org`,`level5_org`,`level6_org`,`level7_org`,` level8_org`,`acctg_fiscal_prd`,`fund10_sum_type`)),N,N),N,N)),
sum(conv(substring(md5(concat_ws("S",`id`,`area`,`dept`,`fund_type`,`fund`,`org`,`sort_group`,`rev_src_code`,`obj_exp_code`,`sub_org`,`origin_ref_code`,`origin_ref_num`,`accept_date`,`invoice_num`,`trans_code`,`trans_num`,`trans_line_num`,`reporting_grp`,`reporting_ledger`,`approp_unit`,`acct_code`,`back_ref_code`,`back_ref_num`,`record_date`,`budg_fiscal_yr`,`src_acctg_fiscal_prd`,`vendor_code`,`vendor_name`,`trans_line_num_descr`,`function`,`sub_obj_code`,`sub_rev_src_code`,`job_num`,`trans_amt`,`commit`,`level1_org`,`level2_org`,`level3_org`,`level4_org`, `level5_org`,`level6_org`,`level7_org`,`level8_org`,`acctg_fiscal_prd`,`fund10_sum_type`)),N,N),N,N)),
sum(conv(substring(md5(concat_ws("S",`id`,`area`,`dept`,`fund_type`,`fund`,`org`,`sort_group`,`rev_src_code`,`obj_exp_code`,`sub_org`,`origin_ref_code`,`origin_ref_num`,`accept_date`,`invoice_num`,`trans_code`,`trans_num`,`trans_line_num`,`reporting_grp`,`reporting_ledger`,`approp_unit`,`acct_code`,`back_ref_code`,`back_ref_num`,`record_date`,`budg_fiscal_yr`,`src_acctg_fiscal_prd`,`vendor_code`,`vendor_name`,`trans_line_num_descr`,`function`,`sub_obj_code`,`sub_rev_src_code`,`job_num`,`trans_amt`,`commit`,`level1_org`,`level2_org`,`level3_org`,`level4_org`,`level5_org`,`level6_org`,`level7_org`,`level8_org`,`acctg_fiscal_prd`,`fund10_sum_type`)),N,N),N,N))
) as hashkey,
count(*) as cnt, `id` from `mfs_trans06` group by N order by N