4.2. Readme for HDP VM Sandbox

This is a VirtualBox sandbox image that can be used to experiment with the Presto distribution. The credentials for the VM are:

user: presto

password: presto

The image is based on CentOS 6.6 and contains the following components:

• Presto is installed in /usr/lib/presto. It is set up with Hive, TPCH and JMX connectors. Logs are located in /var/log/presto.
• presto-admin is installed in /opt/prestoadmin. You can run presto-admin by executing: /opt/prestoadmin/presto-admin.
• For documentation of the Presto release embedded in the VM see: Presto Documentation.

In addition, the image contains:

• The Hortonworks Hadoop distribution, version 2.3, running in pseudo distributed mode.
• Hive (set up to use YARN).
• Hive Metastore.
• Zookeeper (used by Hive).
• MySQL (used by Hive Metastore).

The following sample tables are loaded to HDFS and are visible from Hive:

• TPC-H nation table.
• TPC-H region table.

The presto-cli executable JAR can be found in /home/presto and should be used to execute Presto queries. Please wait a few moments after the image boots for the Presto service to start.

Usage example:

[presto@presto-demo-hdp ~]# java -jar /home/presto/presto-cli.jar --catalog hive
show tables;
 Table
--------
 nation
 region
(2 rows)

presto:default> select * from nation;
...