...

• setAutoCommit(false) throws an exception because transactions are not supported.

• presto-jdbc queries share the same Presto resources you have available for any other ad hoc or scheduled queries that you submit from the TD Console or through the REST API.

• presto-jdbc queries are shown in your account’s account job log, with the exception of the following standard entries:

  • Query result table

  • Query plan  

  • Progress log  

• The query result is converted into JSON before being submitted back to separate tools for display. As such, very large result tables may take some time before being displayed. If you  you have latency problems, contact supportSupport.

• Certain BI tools issue “information_schema” requests that cause failed queries in our system. This may be an issue in your tool during first use.

If you see any unexpected errors/bugs/logs that occur during beta use, contact supportSupport.

Our aim is to keep this API up as much as possible. Specifically, we expect to achieve a downtime of less than 1 hour total per month.

...

jdbc:trino://api-presto.treasuredata.com:443/td-presto/(database name)?SSL=true Or jdbc:presto://api-presto.treasuredata.com:443/td-presto/(database name)?SSL=true

...

jdbc:trino://api-presto.treasuredata.com:443/td-presto?SSL=true
OR
jdbc:presto://api-presto.treasuredata.com:443/td-presto?SSL=true

jdbc:trino://api-presto.treasuredata.com:443/td-presto/sample_datasets?SSL=true
OR
jdbc:presto://api-presto.treasuredata.com:443/td-presto/sample_datasets?SSL=true

Example Code

$ javac Sample.java
$ java -cp .:trino-jdbc-0.359.jar Sample (your TD API key)
time=1412351990, method=GET, path=/category/office
time=1412351976, method=GET, path=/item/software/2265
time=1412351961, method=GET, path=/category/toys
time=1412351947, method=GET, path=/item/electronics/3305
time=1412351932, method=GET, path=/category/software

...