تماشای ویدئو Data Analytics using Hadoop 07 Stage Hive Output از آی-ویدئو

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
28 بهمن 1395
آی-ویدئو