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 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 (see “Documentation”).
Note
You can take advantage of all SQL support by using the Trino CLI, or any application using the JDBC driver or ODBC drivers, all discussed in Chapter 3.
Get Trino: The Definitive Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
