Configuring Presto - Presto on Teradata Appliance for Hadoop

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.

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
On the prestoadmin node, log in as prestoadmin.

Edit the coordinator config.properties file and change the default port to 8285.

cd /home/prestoadmin/.prestoadmin/coordinator

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

Save the file. ESC:wq

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
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
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

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