Zeppelin Presto Interpreter

• Presto JDBC configuration
  • Download presto-jdbc-<version>.jar
    • wget https://repo1.maven.org/maven2/com/facebook/presto/presto-jdbc/0.164/presto-jdbc-0.164.jar
  • Copy or move it to the <zeppelin home>/interpreter/jdbc
    • /usr/hdp/current/zeppelin-server/interpreter/jdbc
• Presto interpreter configuration
  • Go to the interpreter page
    • http://<zeppelin host>:9995/#/interpreter
  • Add the following properties to the JDBC interpreter
    • presto.driver
      • com.facebook.presto.jdbc.PrestoDriver
    • presto.url
      • jdbc:presto://<coordinator URL>/hive/default
        • jdbc:presto://10.107.92.31:8087/hive/default
          
    • presto.user
      • presto
  • Add the following artifact to the JDBC interpreter
    • The path of the JDBC JAR file
      • /usr/hdp/current/zeppelin-server/interpreter/jdbc/presto-jdbc-0.164.jar
  • restart the JDBC interpreter
• Specify "%jdbc(presto)" for using presto JDBC interpreter
  • %jdbc(presto) show tables