SQL language

You’ve come to the right place if you are looking for reference material on SQL in Dell Data Analytics Engine, powered by Starburst Enterprise platform (SEP). If you want in-depth training on handling complex data types and more, check out our advanced SQL video training. It covers topics such as: using JSON array and map functions advanced aggregations window functions

View the training

SEP uses the Trino SQL query engine that allows users to use standard SQL, and there user their favorite data tools, including BI and ETL tools, with any underlying data source.

This section provides an overview of SQL support, a reference to the supported SQL data types and other general characteristics of the SQL support in SEP.

A complete SQL statement and syntax referenceand documentation on numerous SQL functions and operators are available in separate sections.

• SQL statement support
  • Globally available statements
  • Read operations
  • Write operations
  • Security operations
  • Transactions
• Data types
  • Trino type support and mapping
  • Boolean
  • Integer
  • Floating-point
  • Fixed-precision
  • String
  • Date and time
  • Structural
  • Network address
  • UUID
  • HyperLogLog
  • SetDigest
  • Quantile digest
  • T-Digest
• Keywords and identifiers
  • Reserved keywords
  • Identifiers