1 of 1

Examples

Below are various examples for querying data with the TileDB Presto connector.

SQL Examples

Selecting Data

Typical select statements work as expected. This include predicate pushdown for dimension fields.

Select all columns and all data from an array:

Select subset of columns:

Select with predicate pushdown:

Showing Query Plans

Get the query plan without running the query:

Analyze the query but running and profiling:

Creating a TileDB Array

It is possible to create TileDB array from Presto. Not all array schema options are currently supported from Presto though (see Limitations for more details).

Minimum create table:

Create table with all options specified:

Inserting Data

Data can be inserted into TileDB arrays through Presto. Inserts can be from another table or individual values.

Copy data from one table to another:

Data can be inserted using the VALUES method for single row inserts. This is not recommended because each insert will create a new fragment and cause degraded read performance as the number of fragments increases.