(v7) Manage the Presto Connector

Manage the Presto Connector

The Composer Presto connector connects to a Presto server. It has been verified with the Presto server version 319. While other versions have not been verified, you can try to connect to a different Presto server version. In this case, we encourage you to use our driver drop-in feature to drop-in the Presto JDBC driver of the matching version.

You might use the Composer Presto connector to connect to a Presto server on which the Presto connector is installed. After the connection is made, you would then be able to visualize and explore data in the Cassandra database using the Composer client.

The Presto connector has been validated and tested with Cassandra and Postgres databases only. Composer cannot guarantee bug-free operation of the Presto connector with other databases, although you can try to use Presto to connect to them. Composer may officially add additional database support for Presto at some point in the future.

Before you can establish a connection from Composer to the Presto server, the Presto connector server must be installed, configured and enabled. See Manage Connectors and Connector Servers for general instructions and Connect to Presto for details specific to the Presto connector.

After the connector has been set up, you can create data source configurations that specify the necessary connection information and identify the data you want to use. See Manage Data Source Configurations for more information. After data sources are configured, they can be used to create dashboards and visuals from your data. See Create Dashboards.

Composer Feature Support

Presto connector support for specific Composer features is shown in the following table.

Key: Y - Supported; N - Not Supported; N/A - not applicable

Feature	Supported?
Admin-Defined Functions	Y
Box Plots	Y
Custom SQL Queries	N
Derived Fields (Row-Level Expressions)	N
Distinct Counts	Y
Fast Distinct Values	N/A
Group By Multiple Fields	Y
Group By Time	Y
Group By UNIX Time	Y
Histogram Floating Point Values	Y
Histograms	Y
Kerberos Authentication	N
Last Value	Y
Live Mode and Playback	Y
Multivalued Fields	N/A
Nested Fields	N/A
Partitions	N
Pushdown Joins for Fusion Data Sources	N
Schemas	Y
Text Search	N/A
TLS	Y
User Delegation	N
Wildcard Filters	Y
Wildcard Filters, Case-Insensitive Mode	Y
Wildcard Filters, Case-Sensitive Mode	Y

Connect to Presto

To install and configure the Presto connector:

1. Install Presto version 319. Refer to Presto's documentation Installing Presto for more details.
2. Configure the Presto Server. Refer to Presto's documentation Configuring Presto for more details.
3. Make sure that the following files are available in the presto-server-319/etc folder:

• config.properties
• node.properties
• jvm.config
• log.properties

4. Configure Presto for Cassandra databases. See Connect to Cassandra Databases Using Presto and Presto's documentation covering its Cassandra connector for more details.