MIGRATE PIVOT ASTER FUNCTION TO HIVE FUNCTION

Question

I have a existing aster script need to migrate into hive language. But i dont understand how the script define the value into the column. I dont know how to change the function so that it can be execute on hive.Anyone can help me? Here are the script.

    create table coll_ledger_cashfprofile_ta distribute by hash(it_ref_no) as (
SELECT * FROM pivot (
ON coll_ledger_cashfprofile_tb
PARTITION BY it_ref_no, file_type, comb_id, startyear
ORDER BY moorder
Partitions ('it_ref_no', 'file_type', 'comb_id', 'startyear')
Rows (45)
Metrics ('cum_cashflow', 'relcum_cf', 'relcum_cinf')
));