Use OpenTSDB Ambari service to store/visualize stock data on HDP sandbox
OpenTSDB (Scalable Time Series DB) allows you to store and serve massive amounts of time series data without losing granularity (more details here). In this tutorial we will install it on Hbase on HDP sandbox using the Ambari sevice and use it to import and visualize stock data.
Import ova file into VMWare and ensure the VM memory size is set to at least 8GB
Now start the VM
After it boots up, find the IP address of the VM and add an entry into your machines hosts file e.g.
192.168.191.241 sandbox.hortonworks.com sandbox
Connect to the VM via SSH (password hadoop)
Start HBase service from Ambari and ensure Hbase is up and root has authority to create tables. You can do this by trying to create a test table
create 't1', 'f1', 'f2', 'f3'
If this fails with the below, you will need to provide appropriate access via Ranger (http://sandbox.hortonworks.com:6080) ERROR: org.apache.hadoop.hbase.security.AccessDeniedException: Insufficient permissions for user 'root (auth:SIMPLE)' (global, action=CREATE)