Installing the Presto Server - Presto on Teradata Appliance for Hadoop

Presto on Teradata Appliance for Hadoop 6 Installation, Configuration, and Upgrade Guide
Product
Presto on Teradata Appliance for Hadoop
Release Number
157t
Published
February 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
jpl1484678832656.ditamap
dita:ditavalPath
Generic_no_ie_no_tempfilter.ditaval
dita:id
jpl1484678832656
Product Category
Open Source
A config.json file containing the valid host names of the coordinator and worker nodes in the Teradata Hadoop Appliance 6 cluster.
The installation script copies and installs the Presto Server rpm (presto-server rpm) packages on the coordinator and worker nodes defined in the config.json file.
If valid host names are not provided in the config.json file, the installation fails.
During installation, the script installs the following into directories on the prestoadmin/coordinator node and worker nodes in the cluster:
  • Default config.properties, node.properties, and jvm.config Presto Admin (presto-admin) templates into the /home/prestoadmin/.prestoadmin directory
    • One set of .properties and jvm.config files for the coordinator node defined in the config.json file
    • One set of .properties and jvm.config files for all the worker nodes defined in the config.json file
  • A tpch connector configuration into the /home/prestoadmin/.prestoadmin/catalog directory
Replace the FQDNs in the examples with the FQDNs for your Hadoop nodes.
  1. Log in to the prestoadmin node as prestoadmin.
  2. Install the Presto Server package on the coordinator node and worker nodes. Installing the Presto Server package deploys the default configuration files to coordinator and worker nodes. The default files are configured later.
    1. cd /opt/prestoadmin
    2. ./presto-admin server install /var/opt/teradata/packages/presto-<version>/presto_server_pkg.<version>/presto-server-rpm-<version>.x86_64.rpm

      Something similar to the following displays.

      Deploying rpm on xyz721d5.customer.com...
Deploying rpm on xyz721d4.customer.com...
...
Deploying rpm on xyz721m1.customer.com...
Package deployed successfully on: xyz721m1.customer.com
...
Package deployed successfully on: xyz721d5.customer.com
Package installed successfully on:xyz721m1.customer.com
Deploying configuration on:xyz721m1.customer.com
Deploying tpch.properties connector configurations on:
xyz721m1.customer.com
...
Package installed successfully on: xyz721d5.customer.com
Deploying configuration on: xyz721d5.customer.com
Deploying tpch.properties connector configurations on:
xyz721d5.customer.com
Deploying tpch.properties connector configurations on:
xyz721d5.customer.com
    3. chown -R prestoadmin:prestoadmin /home/prestoadmin/.prestoadmin/
    4. sudo chown -R presto:presto /etc/presto
  3. [Optional] View the coordinator node directory and subdirectories.
    The worker nodes contain the same directory and subdirectories as the coordinator node.
    1. ls -ld /etc/presto 
      drwxr-xr-x 3 presto presto 4096 Aug 29 21:54 presto
    2. ls -l /etc/presto 
       total 20
drwxr-xr-x 2 presto presto 4096 Aug 29 21:54 catalog
-rw------- 1 presto presto 210 Aug 29 21:54 config.properties
-rw-r--r-- 1 presto presto 36 Aug 29 21:54 env.sh
-rw------- 1 presto presto 229 Aug 29 21:54 jvm.config
-rw------- 1 presto presto 280 Aug 29 21:54 node.properties
    3. ls -l /etc/presto/catalog 
      total 4
-rw------- 1 presto presto 19 Aug 29 21:54 tpch.properties
  4. [Optional] View the /home/prestoadmin subdirectories before you change permissions.
    1. ls -lR /home/prestoadmin/.prestoadmin 
      /home/prestoadmin/.prestoadmin:
total 16
-rw-rw---- 1 prestoadmin prestoadmin 233 Aug 30 08:14 config.json
drwxrwx--- 2 prestoadmin prestoadmin 4096 Aug 30 08:18 connectors
drwxrwx--- 2 prestoadmin prestoadmin 4096 Aug 30 08:18 coordinator
drwxrwx--- 2 prestoadmin prestoadmin 4096 Aug 30 08:18 workers

/home/prestoadmin/.prestoadmin:
total 4
-rwxr-xr-x 1 prestoadmin prestoadmin 19 Aug 30 08:18 tpch.properties

/home/prestoadmin/.prestoadmin:
total 12
-rw-r--r-- 1 prestoadmin prestoadmin 210 Aug 30 08:18 config.properties
-rw-r--r-- 1 prestoadmin prestoadmin 228 Aug 30 08:18 jvm.config
-rw-r--r-- 1 prestoadmin prestoadmin 235 Aug 30 08:18 node.properties

/home/prestoadmin/.prestoadmin:
total 12
-rw-r--r-- 1 prestoadmin prestoadmin 140 Aug 30 08:18 config.properties
-rw-r--r-- 1 prestoadmin prestoadmin 228 Aug 30 08:18 jvm.config
-rw-r--r-- 1 prestoadmin prestoadmin 235 Aug 30 08:18 node.properties
  5. Change the permissions on the /home/prestoadmin/.prestoadmin subdirectories. chmod 660 `find /home/prestoadmin/.prestoadmin -type f`
  6. [Optional] View the new permissions for the /home/prestoadmin/.prestoadmin subdirectories. ls -lR /home/prestoadmin/.prestoadmin 
    /home/prestoadmin/.prestoadmin:
total 16
-rw-rw---- 1 prestoadmin prestoadmin 233 Aug 30 08:14 config.json
drwxr-xr-x 2 prestoadmin prestoadmin 4096 Aug 30 08:18 connectors
drwxr-xr-x 2 prestoadmin prestoadmin 4096 Aug 30 08:18 coordinator
drwxr-xr-x 2 prestoadmin prestoadmin 4096 Aug 30 08:18 workers

/home/prestoadmin/.prestoadmin/catalog:
total 4
-rw-rw---- 1 prestoadmin prestoadmin 19 Aug 30 08:18 tpch.properties

/home/prestoadmin/.prestoadmin/coordinator:
total 12
-rw-rw---- 1 prestoadmin prestoadmin 210 Aug 30 08:18 config.properties
-rw-rw---- 1 prestoadmin prestoadmin 228 Aug 30 08:18 jvm.config
-rw-rw---- 1 prestoadmin prestoadmin 235 Aug 30 08:18 node.properties

/home/prestoadmin/.prestoadmin/workers:
total 12
-rw-rw---- 1 prestoadmin prestoadmin 140 Aug 30 08:18 config.properties
-rw-rw---- 1 prestoadmin prestoadmin 228 Aug 30 08:18 jvm.config
-rw-rw---- 1 prestoadmin prestoadmin 235 Aug 30 08:18 node.properties