Configuring Presto - 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
Use the following steps to configure Presto for a Teradata Hadoop Appliance 6 cluster. The Presto configuration files are config.properties, node.properties, and jvm.config. Although changes are made to the .properties files, no changes are made to the default jvm.config file during installation.
Replace the FQDNs in the examples with the FQDNs for your Hadoop nodes.
  1. On the prestoadmin/coordinator node and all worker nodes, relocate the Presto log directories and the Presto lib directories. The directories must be relocated to support the upcoming configuration changes to the config.properties files of the coordinator node and worker nodes.
    1. Log in as prestoadmin.
    2. Relocate the Presto log directory. sudo mv /var/log/presto /var/opt/teradata/log/ sudo ln -s /var/opt/teradata/log/presto /var/log/presto
    3. Relocate the Presto lib directory. sudo mv /var/lib/presto /var/opt/teradata/ sudo ln -s /var/opt/teradata/presto /var/lib/presto
  2. On the prestoadmin node, log in as prestoadmin.
  3. Edit the coordinator config.properties file and change the default port to 8285.
    1. cd /home/prestoadmin/.prestoadmin/coordinator
    2. vi config.properties
      query.max-memory=50GB
      node-scheduler.include-coordinator=false
      discovery.uri=http://xyz721m1.customer.com:8285
      discovery-server.enabled=true
      http-server.http.port=8285
      coordinator=true
      query.max-memory-per-node=8GB
    3. Save the file. ESC:wq
  4. Edit the coordinator node.properties file.
    1. cd /home/prestoadmin/.prestoadmin/coordinator
    2. vi node.properties
      • Change the node.data.dir to /var/opt/teradata/log/presto.
      • Add node.launcher-log-file and node.server-log-file properties, so these log files are placed in the largest file system (/var/opt/teradata).
      plugin.dir=/usr/lib/presto/lib/plugin
      node.environment=presto
      plugin.config-dir=/etc/presto/catalog
      node.data-dir=/var/opt/teradata/log/presto 
      node.launcher-log-file=/var/opt/teradata/log/presto/launcher.log 
      node.server-log-file=/var/opt/teradata/log/presto/server.log
    3. Save the file. ESC:wq
  5. Edit the worker config.properties file and change the default ports to 8285.
    1. cd /home/prestoadmin/.prestoadmin/ workers
    2. vi config.properties
      query.max-memory=50GB
      coordinator=false
      query.max-memory-per-node=8GB
      http-server.http.port=8285
      discovery.uri=http://xyz721m1.customer.com:8285
    3. Save the file. ESC:wq
  6. Edit the worker node.properties file.
    1. cd /home/prestoadmin/.prestoadmin/workers
    2. vi node.properties
      • Change the node.data.dir to /var/opt/teradata/log/presto.
      • Add node.launcher-log-file and node.server-log-file properties, so these log files are placed in the largest file system (/var/opt/teradata).
      plugin.dir=/usr/lib/presto/lib/plugin
      node.environment=presto
      plugin.config-dir=/etc/presto/catalog
      node.data-dir=/var/opt/teradata/log/presto 
      node.launcher-log-file=/var/opt/teradata/log/presto/launcher.log 
      node.server-log-file=/var/opt/teradata/log/presto/server.log
    3. Save the file. ESC:wq
  7. Deploy the configuration changes to the cluster. /opt/prestoadmin/presto-admin configuration deploy

    Something similar to the following displays.

    Deploying configuration on: xyz721d1.customer.com
    Deploying configuration on: xyz721d2.customer.com
    Deploying configuration on: xyz721d3.customer.com
    Deploying configuration on: xyz721d4.customer.com
    Deploying configuration on: xyz721d5.customer.com
    Deploying configuration on: xyz721m1.customer.com