Data Analytics using Hadoop - 06 Develop Hive Queries using Hue

Make sure you are in right database (nyse_demo.db in this case) 1) select * from stock_eod limit 10; 2) select * from companylist limit 10; 3) 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 '%2013' group by cl.sector, cl.company_name, substr(s.transactiondate, 4) order by sector, company_name, transactionmonth; Connect with me or follow me at https://www.linkedin.com/in/durga0gadiraju https://www.facebook.com/durga.v.gadiraju https://github.com/dgadiraju https://www.youtube.com/c/TechnologyMentor https://twitter.com/dgadiraju