In this video you will see how data is staged in hive table
1) Determine delimiter (| in our case)
2) Execute below query
create table stock_volume_per_month
row format delimited fields terminated by '|'
as
select cl.sector, cl.company_name, substr(s.transactiondate, 4) transactionmonth,
sum(s.volume) monthlyvolume from companylist cl
join stock_eod s
on s.stockticker = cl.symbol
where s.transactiondate like ' 13'
group by cl.sector, cl.company_name, substr(s.transactiondate, 4)
order
آی-ویدئو