Presto installation

presto

Installation
  https://teradata.github.io/presto/docs/141t/server-installation.html 
  http://teradata.github.io/presto/docs/127t/installation/installation-ambari.html

Adding public key to clusters
  https://teradata.github.io/presto/docs/141t/installation/presto-admin/ssh-configuration.html#ssh-configuration-label

Reference
http://teradata.github.io/presto/docs/127t/installation/installation-ambari.html
https://teradata.github.io/presto/docs/current/getting-started.html
https://github.com/prestodb/presto-admin/blob/master/docs/presto-admin-commands.rst

Commands 
  Navigate to directory where presto is installed.
  Type presto and
  
  ./presto-admin --help
  eg ./presto-admin --password=xyz server start

# execute query from cli
  ./presto --server localhost:8181 --catalog hive --schema default
 
# add mysql / sqlserver connector
  /etc/catalog/mysql.properties
    
# show tables from catalog.database
   show tables from hive.sddm
# desc hive.sddm.service_delivery_case;   
  
# check for JVM
java -XX:+PrintFlagsFinal -version | grep -iE 'HeapSize|PermSize|ThreadStackSize'

# configuration
https://stackoverflow.com/questions/20038642/presto-configuration

# How to list all available schemas
https://support.chartio.com/knowledgebase/how-to-list-all-available-schemas
http://getindata.com/tutorial-using-presto-to-combine-data-from-hive-and-mysql-in-one-sql-like-query/