SQL language

BDV is an ANSI SQL compliant query engine. This standard compliance allows BDV users to integrate their favorite data tools, including BI and ETL tools with any underlying data source.

BDV validates and translates the received SQL statements into the necessary operations on the connected data source.

This chapter provides a reference to the supported SQL data types and other general characteristics of the SQL support of BDV.

A full SQL statement and syntax reference is available in a separate chapter.

BDV also provides numerous SQL functions and operators.

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