Yesterday I tried to install Stinger on Hortonworks HDP 2.0 Sandbox. Below are the steps I followed. I used the Sandbox 2 for Hyper-V.
Installing Stinger phase 3 preview
Import the sandbox 2 VM and make sure that it can access to the internet.
Start the VM and log into it using Alt+F5 keys. Download Stinger Quickstart Bundle using wget. Remember the url is case sensitive.
untar the downloaded file
Change the directory name to StingerPreview. We are going to use that directory for multiple times.
Installing and Configuring Tez
Download the Stinger Phase 3 Preview Tez tarball:
Extract the Stinger Phase 3 Preview Tez tarball:
Create a directory on HDFS for Tez:
hadoop fs -chmod 755 /apps/tez
Deploy Tez files to HDFS:
Deploy a sample Tez configuration from the Quickstart Bundle:
Installing and Configuring Hive 0.13
We have to use Hive 0.13 preview to the Hadoop cluster because this version of Hive is designed to work with Tez 0.2.
Download the Stinger Phase 3 Preview Hive tarball:
Extract the Stinger Phase 3 Preview Hive tarball:
Create a directory on HDFS for Hive with appropriate permissions.
hadoop fs -chmod 755 /user/hive
Deploy Hive files to HDFS:
Configure the environment:
You must run below commands before starting hive.
Deploy Hive configuration:
To use Hive on Tez, certain configuration options must be set in hive-site.xml. This file must also contain information including login and password to your metastore. Copy an existing hive-site.xml.
Running Hive and Ensuring a Correct Install
If you want to run Hive with Stinger settings, you will need to start Hive with an additional parameter that contains in the stinger.settings. The file stinger.settings is provided in the Stinger Quickstart Bundle’s configs folder.
To ensure the proper configurations have been made, in the hive command line, Issue the command set hive.vectorized.execution.enabled;. You should see the output as true.
Now you would be able to query Hive which will use Stinger.