SQL reference

ReferenceApplies to: Unified engine deployments

Look up Unified SQL syntax, types, functions, and statement behavior. SQL examples can be copied into your Unified SQL client. Examples use demo.tpcds for sample tables and demo.examples for the write lab. Replace these names with your catalog and namespace.

Run an example

Copy the SQL into Workbench or a compatible SQL client. Examples that use sample tables need a TPC-DS SF1 dataset. Replace demo.tpcds with your source catalog and namespace, and demo.examples with a private writable namespace. See Example data for the table schema and write-lab requirements. Run related statements in order in the same session. Queries with inline data do not need a sample dataset.

Find a topic

Topic	Reference
Dialect, identifiers, and statement rules	SQL overview
Dataset, joins, and write lab	Example data
SELECT, projection, filtering, and ordering	Queries
Inner, outer, semi, anti, and cross joins	Joins
Grouping, HAVING, ROLLUP, and aggregates	Aggregations
CTEs and subqueries	CTEs and subqueries
UNION, INTERSECT, and EXCEPT	Set operations
PARTITION BY, ordering, and frames	Window queries
Types, casts, and nested values	Types and expressions
Comparisons, logic, arithmetic, and NULL	Operators and nulls
Registered function inventory	Functions
CREATE, ALTER, DROP, SHOW, and DESCRIBE	Statements
INSERT, overwrite, UPDATE, DELETE, MERGE	Writing data
Maintenance procedures	Maintenance

Try the data

This reads ten items from Hub’s SF1 dataset. Replace the qualified name with your catalog and dataset namespace.

SELECT i_item_sk, i_item_id, i_category, i_current_price
FROM demo.tpcds.item
ORDER BY i_item_sk
LIMIT 10;

The examples teach SQL using TPC-DS data. They are not certified TPC-DS benchmark queries or performance measurements.

Transformation Engine

Learn Laminar

Workloads

HTTP API

Recipes

Operations

SQL reference

Run an example

Find a topic

Try the data

​Run an example

​Find a topic

​Try the data

Run an example

Find a topic

Try the data