Trino Connector SQL Support

Introduction

The connector provides read access and write access to data and metadata stored in Apache Gravitino.

Globally Available Statements

• EXPLAIN
• EXPLAIN ANALYZE
• PREPARE
• USE

Read Operations

• SELECT
• DESCRIBE
• SHOW CATALOGS
• SHOW COLUMNS
• SHOW CREATE SCHEMA
• SHOW CREATE TABLE
• SHOW SCHEMAS
• SHOW TABLES

Write Operations

• INSERT
• INSERT INTO SELECT
• UPDATE
• DELETE
• MERGE

Schema and Table Management

• CREATE TABLE
• CREATE TABLE AS SELECT (CREATE OR REPLACE TABLE AS SELECT is not supported)
• DROP TABLE
• ALTER TABLE
• CREATE SCHEMA
• DROP SCHEMA
• COMMENT

Transactions

• START TRANSACTION
• COMMIT
• ROLLBACK

For more information, refer to Trino SQL statements support