1) Create Database - On Hue, click on query browser and select hive
create database nyse_demo;
Refresh database list.
2) Create companylist table using wizard
3) Create stock_eod as external table using hive command/query
create external table stock_eod (stockticker string, transactiondate string, openprice float, highprice float, lowprice float, closeprice float, volume bigint )ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' LOCATION '/user/admin/nyse_demo/stock_eod'; 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
