Installing the Presto CLI on an Edge or Master Node - 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
Install the Presto CLI on an Edge Node. If the cluster does not have an Edge node, install the Presto CLI on the first Master Node.
  1. If your configuration does not include an Edge Node, do the following:
    1. On the first Master Node, log in as root.
    2. cd /var/opt/teradata/packages/presto-<version>

      The Teradata Presto package in this directory contains the presto_client_pkg.<version>.tar.gz needed to install Presto CLI.

  2. If your configuration includes an Edge node, do the following.
    1. On the Edge Node, log in as root.
    2. Using the presto-<version> naming convention to identify the Presto package version, create a subdirectory for the Presto packages: mkdir -p /var/opt/teradata/packages/presto-<version>
    3. Download the Teradata Presto Client Package (presto_client_pkg.<version>.tar.gz) from http://www.teradata.com/presto to /var/opt/teradata/packages/presto-<version> .
    4. cd /var/opt/teradata/packages/presto-<version> The Teradata Presto package in this directory contains the presto_client_pkg.<version>.tar.gz needed to install Presto CLI.
  3. Untar the presto_client_pkg.<version>.tar.gz file. tar -xvf presto_client_pkg.<version>.tar.gz

    Something similar to the following displays. The .gz file contains all the client drivers and Presto CLI.

    presto_client_pkg.<version>
    /presto_client_pkg.<version>/jdbc/
    presto_client_pkg.<version>/odbc/
    ...
    presto_client_pkg.<version>/jdbc/presto-jdbc<version>.jar
    presto_client_pkg.<version>/jdbc/._TeradataJDBCDriverPrestoInstallGuide_<version>.pdf
    presto_client_pkg.<version>/jdbc/TeradataJDBCDriverPrestoInstallGuide_<version>.pdf
  4. View ownership of the contents of the presto_client_pkg.<version>.tar.gz file. tar tvf presto_client_pkg.<version>.tar.gz

    Something similar to the following displays.

    drwxr-xr-x admin/staff 0 2016-08-08 12:17 presto_client_pkg.<version>/
    drwxr-xr-x admin/staff 0 2016-08-15 11:04 presto_client_pkg.<version>/jdbc/
    drwxr-xr-x admin/staff 0 2016-08-15 11:05 presto_client_pkg.<version>/odbc/
    -rw-r--r-- admin/staff 12839464 2016-07-27 09:51 presto_client_pkg.<version>/presto-cli-<version>-executable.jar
    ...
    -rw-r--r-- admin/staff 194 2016-08-11 07:00 presto_client_pkg.<version>/jdbc/._TeradataJDBCDriverPrestoInstallGuide_<version>.pdf
    -rw-r--r-- admin/staff 432802 2016-08-11 07:00 presto_client_pkg.<version>/jdbc/TeradataJDBCDriverPrestoInstallGuide_<version>.pdf
    
  5. Change ownership of the contents of the presto_client_pkg.<version> directory.
    1. chown -R <user>:<group> presto_client_pkg.<version>
    2. [Optional] View the ownership change. ls -lR /var/opt/teradata/packages/presto-<version>/presto_client_pkg.<version>

      Something similar to the following displays.

      /var/opt/teradata/packages/presto-<version>/presto_client_pkg.<version>:
      total 12568
      drwxr-xr-x 2 tdatuser cdrom 4096 Aug 30 16:20 jdbc
      drwxr-xr-x 2 tdatuser cdrom 4096 Aug 30 16:20 odbc
      -rw-r--r-- 1 tdatuser cdrom 12839464 Jul 27 09:51 presto-cli-<version>-executable.jar
      
      /var/opt/teradata/packages/presto-<version>/presto_client_pkg.<version>/jdbc:
      total 11356
      -rw-r--r-- 1 tdatuser cdrom 194 Aug 11 07:00 ._TeradataJDBCDriverPrestoInstallGuide_<version>.pdf
      -rw-r--r-- 1 tdatuser cdrom 432802 Aug 11 07:00 TeradataJDBCDriverPrestoInstallGuide_<version>.pdf
      ...
      -rw-r--r-- 1 tdatuser cdrom 3747964 Aug 9 06:35 presto-jdbc<version>.jar
      
      /var/opt/teradata/packages/presto-<version>/presto_client_pkg.<version>/odbc:
      total 75740
      -rw-r--r-- 1 tdatuser cdrom 194 Aug 8 17:27 ._TeradataODBCDriverPrestoInstallGuide_<version>.pdf
      -rw-r--r-- 1 tdatuser cdrom 226 Aug 8 12:09 ._TeradataPrestoODBC-<version>.dmg
      ...
      -rw-r--r-- 1 tdatuser cdrom 6219 Aug 15 11:05 Teradata_Presto_ODBC_Driver.tdc
      
  6. Go to the presto_client_pkg.<version> directory cd presto_client_pkg.<version>
  7. Copy presto-cli-0.<version>-executable.jar to the /usr/bin directory.
    The /usr/bin directory contains executables for other client software. The typical $PATH variable includes /usr/bin in its path search.
    cp /var/opt/teradata/packages/presto-<version>/presto_client_pkg.<version>/presto-cli-0.xxxt-executable.jar /usr/bin/
  8. Rename presto-cli-0.<version>-executable.jar to presto and set permissions.
    1. mv /usr/bin/presto-cli-<version>-executable.jar /usr/bin/presto
    2. chmod +x /usr/bin/presto
    3. [Optional] View permissions for /usr/bin/presto. ls -l /usr/bin/presto

      Something similar to the following displays.

      -rwxr-xr-x 1 root root 12548650 Aug 17 09:42 /usr/bin/presto