Creating a System Administration Role for 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 procedure to do the following on all Presto nodes (prestoadmin node, coordinator node, and worker nodes):
  • Create a prestoadmin group and user
  • Grant sudo privileges to the prestoadmin group. Granting sudo privileges allows the prestoadmin group to perform administrative tasks for Teradata Presto.
In Teradata Hadoop clusters, the prestoadmin node is co-located with the coordinator node. The procedures for the prestoadmin node and the coordinator node are performed on the prestoadmin node.
  1. On each Presto node (prestoadmin node/coordinator node, worker nodes), log in as root.
  2. Create a prestoadmin group, a prestoadmin user, and set a password for the prestoadmin user.
    1. groupadd prestoadmin
    2. useradd -d /home/prestoadmin -m -c "presto admin user to administer the Teradata Presto SQL Engine" -G prestoadmin prestoadmin
    3. passwd prestoadmin
  3. Grant the prestoadmin group on each Presto node (prestoadmin node/coordinator node, worker nodes) sudo privileges by doing the following.
    1. Enter visudo.
    2. Add the following entry:
      %prestoadmin ALL=(ALL) NOPASSWD: ALL
    3. Save and exit visudo. ESC:wq