Creating a file with a Presto connection

Applies to: Kyvos Enterprise Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

Kyvos Azure Marketplace Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)

Here is some information about working with Presto and Presto connections.

To create a dataset with a Presto connection, perform the following.

From the Toolbox, click Datasets.
Click the Actions menu ( ⋮ ) and choose Add Dataset.
Select the Connection type: Presto.
The default Input type is set to SQL.
Use the SQL query editor to write a query to use with Presto. See Writing SQL queries using data in Hive to learn more.
Click Refine at the top of the window to format the columns. See Formatting columns to learn more.
Click Save when you are finished. You can click Revert if needed.

To query over Presto columns that have a data type that is not supported by Kyvos

Cast the data type explicitly using a cast statement in the SQL editor.
This example uses the time with time zone data type.

Query in Presto: SELECT current_time FROM hive.test.test100;
To create an equivalent query in the Kyvos SQL editor use: SELECT cast("current_time"() as VARCHAR) FROM hive.test.test100;

Presto functions that don't require parenthesis should use a specific format in the Kyvos SQL editor. For example: "fun_name"().

This is seen in:

Aliasing is mandatory for all aggregated columns or functions.

If a dataset uses a Presto connection, you can't use it to create a transformation for processing semantic models.

If you don't view the PrestoConnection in the list of available connection types, you must enable it using the portal.properties file.

To configure the Presto connection, perform the following steps:

Go to the path jakarta/webapps/kyvos/client/config and open the portal.properties file.
Change allowSqlBasedFile to True.
After clearing the cache, the Presto option is added to the list of Connection types.

Related topics