Presto connection

To access your data in Presto, create a connection asset for it.

Presto is a fast and reliable SQL engine for Data Analytics and the Open Lakehouse.

Supported versions

  • Version 0.286.

Create a connection to Presto

To create the connection asset, you need these connection details:

  • Hostname or IP address
  • Port
  • Username
  • Password (required if you connect to Presto with SSL enabled)
  • SSL certificate (if required by the Presto server)

Connecting to Presto within IBM watsonx.data

You can use the Presto connection to connect to multiple types of Presto, including the Presto engine within an instance of watsonx.data. Alternatively, you can use the IBM watsonx.data Presto connection.

To connect to a Presto server within watsonx.data on IBM Cloud, use these connection details:

  • Username: ibmlhapikey_username
  • Password (for SSL-enabled, which is the default): An IBM Cloud API key. For more information, see Connecting to Presto server.

To connect to a Presto server within watsonx.data on Cloud Pak for Data or stand-alone watsonx.data, use the username and password that you use for the watsonx.data console.

Presto connection write modes

In Presto connection you can use the following write modes:

Insert
Adds new records to a table.
Update
Modifies existing records based on specified columns in the key_column_names property. Only records matching the given keys are updated.
Merge
Combines insert and update operations. It updates existing records and inserts new ones based on the columns from key_column_names.
Update statement
A custom SQL statement manually provided by the user. It can include any operation such as INSERT, UPDATE, MERGE, or DELETE.
Update statement with table action
A custom SQL statement manually provided by the user, preceded by a table action. It can include any operation such as INSERT, UPDATE, MERGE, or DELETE.
Static statement
Any SQL statement that is executed without restrictions on type or purpose.

Presto setup

To set up Presto, see Presto installation.

Limitations

  • The Presto connection does not support the Apache Cassandra Time data type.

  • The Presto connection does not support TIME and TIMESTAMP data types when the Presto C++ engine is used.

  • The Presto connection supports update and merge operations only for Iceberg tables.

  • The Presto C++ engine does not support update and merge operations.

  • Iceberg tables do not support concurrent writes. To mitigate this, the connector retries conflicting update and merge operations up to three times. If conflicts continue, execute jobs sequentially.

Running SQL statements

To ensure that your SQL statements run correctly, refer to the SQL Statement Syntax for the correct syntax.

Learn more

Related connection: IBM watsonx.data Presto connection