SQL Support for the Presto Connector

Trino, formerly known as PrestoSQL, supports the ANSI SQL language. The Presto connector uses Trino’s SPI interface to translate SQL language to Aerospike operations using the Aerospike Java client.

Data model

Trino is an SQL engine, but Aerospike is a NoSQL database and is schemaless. Hence, the data models are different as shown in the following table. The Presto connector reconciles those differences to provide seamless SQL experience. Please see the Aerospike data model if you are not familiar with it.

Aerospike	Presto
Cluster	Catalog
Namespace	Schema
Set	Table
Record	Row
Bin	Catalog

Data types

The Presto connector does not support all Presto data types. You must typecast unsupported types to supported types.

Aerospike Data Type	Presto Data Type
byte[]	VARBINARY
String	VARCHAR
Integer	INTEGER
Long	BIGINT
Double	DOUBLE
Float	DOUBLE
Boolean	BOOLEAN
Byte	TINYINT
Value.ListValue	JSON
Value.MapValue	JSON
Value.GeoJSONValue	JSON
Value.HLLValue	HYPER_LOG_LOG

SQL Statements

The Presto connector supports the following SQL statements:

• SHOW CATALOGS
• USE
• SHOW SCHEMA
• SHOW TABLE
• DESCRIBE
• SELECT
• INSERT INTO
• EXPLAIN
• SET SESSION
• REST SESSION
• SHOW SESSIONS
• SHOW STATS