Trino: The Definitive Guide, 2nd Edition

Chapter 8. Using SQL in Trino

After installing and running Trino, you first learned about the central feature of first-class SQL support in Trino in “SQL with Trino”. Go back and check out that content again if you need an overview or a reminder.

From Chapter 6 about connectors, you know that you can query a lot of data sources with SQL in Trino.

In this chapter, you get to dive deep into the details of SQL support of Trino, including a set of data definition language (DDL) statements for creating and manipulating database objects such as schemas, tables, columns, and views. You learn more about the supported data types and SQL statements. In Chapter 9, you learn about operators and functions for more advanced usage.

Overall, the goal of this chapter is not to serve as a reference guide for SQL but rather to demonstrate the SQL capabilities in Trino. For the latest and most complete information about SQL on Trino, you can refer to the official Trino documentation.

Note

You can take advantage of all SQL support by using the Trino CLI, or any application using the JDBC driver, the Python client library, ODBC drivers, or any other client application, all discussed in Chapter 3.

Impact from the Connector

All operations performed in Trino depend on the connector to the data source and its support for specific commands. For example, if the connector to the data source does not support the DELETE statement, any usage results in a failure. Check the SQL support section in the ...