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
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
$ 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