Presto

Summary

1. prestodb.io created by Facebook.
2. Teradata contribute to Presto after acquire Hadapt.
3. Several Devs left after Hadapt acquired, created Startburst Data.
4. Presto is a SQL compute engine, visiting all kinds of data in HDFS, relational, etc.
5. Written in Java and has its own JDBC/ODBC, somewhat compatible with MySQL, Teradata, etc.
6. Release every half month, actively developed.
7. AWS Athena uses Presto, maybe somebody’s EMR too.

A Try

1. According to the official document, 0.195.
2. Problems in WSL:
   1. Openn JDK 9
   2. Edit /etc/vm.properties, add -XX:+StartAttachListener
   3. ln -s /usr/lib/jvm/java-9-openjdk-amd64/lib /usr/lib/jvm/java-9-openjdk-amd64/conf
   4. https://github.com/prestodb/presto/pull/9469/files can’t connect to port 8080
3. Work with JDK 8 in WSL

   e.g. /etc/alternatives/java -> /usr/lib/jvm/java-8-openjdk-amd64/bin/java

$ ./presto --server localhost:8080 --catalog jmx --schema default
presto:default> show catalogs;
 Catalog
---------
 jmx
 system
(2 rows)

Query 20180301_123854_00033_8dn8x, FINISHED, 1 node
Splits: 1 total, 1 done (100.00%)
0:00 [0 rows, 0B] [0 rows/s, 0B/s]

Known issues

1. String comparision is different with MySQL, e.g. c2 = ‘c’ => c2 = ‘c ’
2. Can’t filter dynamically https://github.com/prestodb/presto/issues/7428
3. Mgmt UI is too simple