Versions Compared

Old Version 1

changes.mady.by.user Sarabjeet Kaur

Saved on

compared with

New Version Current

changes.mady.by.user Pallavee Dutta (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Applies to: Image Removed (tick) Kyvos Enterprise   Image RemovedKyvos Cloud  Image Removed(tick) Kyvos Cloud (SaaS on AWS) (error) Kyvos AWS Marketplace

(error) Kyvos Azure Marketplace   Image Removed(error) Kyvos GCP Marketplace (error) Kyvos Single Node Standard Installation Image RemovedKyvos Single Node Installation Image RemovedKyvos FreeInstallation (Kyvos SNI)

...


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

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

  1. From the Toolbox, click Datasets.

  2. Click the Actions menu ( ⋮ ) and choose Add Dataset.

  3. Select the Connection type: Presto.
    The default Input type is set to SQL.

  4. Use the SQL query editor to write a query to use with Presto. See Writing SQL queries using data in Hive to learn more. 

  5. Click Refine at the top of the window to format the columns. See Formatting columns to learn more.

  6. 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

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: 

  • SELECT cast("current_time"() as VARCHAR) FROM hive.test.test100;

Limitations of Presto connection

...

To configure the Presto connection, perform the following steps: 

  1. Go to the path jakarta/webapps/kyvos/client/config and open the portal.properties file.

  2. Change allowSqlBasedFile to True.

  3. After clearing the cache, the Presto option is added to the list of Connection types.

...

Related topics