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 ' 13' group by cl.sector, cl.company_name, substr(s.transactiondate, 4) order by sector, company_name, transactionmonth; Connect with me or follow me at

• #تحصیلات_و_یادگیری
• #cloudera
• #apache_hadoop
• #apache_hive