Reference

This section provides reference for using SQream DB’s interfaces and SQL features.

In this section:

• Data Types
  • Supported types
  • Converting and casting types
  • Data type reference
    • Boolean (BOOL)
      • Syntax
      • Size
      • Examples
      • Casts and conversions
    • Integers (TINYINT, SMALLINT, INT, BIGINT)
      • Integer types
      • Syntax
      • Size
      • Examples
      • Casts and conversions
    • Floating point (REAL, DOUBLE)
      • Floating point types
      • Aliases
      • Syntax
      • Size
      • Examples
      • Casts and conversions
    • String types (TEXT, VARCHAR)
      • String types
      • Length
      • Syntax
      • Size
      • Examples
      • Casts and conversions
    • Date types (DATE, DATETIME)
      • Date types
      • Aliases
      • Syntax
      • Size
      • Examples
      • Casts and conversions
• SQL statements and syntax
  • SQL syntax features
    • Keywords and Identifiers
      • Keywords
      • Identifiers
        • Identifier rules
      • Reserved keywords
    • Literals
      • Number literals
        • Examples
      • String literals
        • Examples
      • Typed literals
        • Syntax reference
        • Examples
      • Other constants
    • Scalar expressions
      • Literals
      • Column references
      • Operators
        • Unary operator
        • Binary operator
        • Special operators for set membership
        • Comparisons
        • Operator precedence
    • Joins
      • Syntax
        • Join types
        • Join conditions
      • Examples
        • Inner join
        • Left join
        • Right join
        • Cross join
        • Join hints
    • Common table expressions (CTEs)
      • Syntax
      • Examples
        • Simple CTE
        • Nested CTEs
        • Reusing CTEs
        • Using CTEs with create_table_as
    • Window functions
      • Syntax
      • Arguments
      • Supported window functions
      • How window functions work
        • PARTITION BY
        • ORDER BY
        • Frames
        • Frame exclusion
      • Limitations
      • Examples
        • Window function application
        • Ranking results
        • Using LEAD to access following rows without a join
    • Subqueries
      • Examples
        • Simple subquery
        • Combining a subquery with a join
        • WITH subqueries
    • Null handling
      • Comparisons
      • Conditionals
      • Operations
        • Scalar functions
        • Aggregates
        • Distincts
      • Sorting
  • SQL statements
    • Data Definition commands (DDL)
    • Data manipulation commands (DML)
    • Utility commands
    • Saved queries
    • Monitoring
    • Workload management
    • Access control commands
  • SQL functions
    • Summary of functions
      • Scalar functions
        • Bitwise operations
        • Conditionals
        • Conversion
        • Date and time
        • Numeric
        • Strings
      • Aggregate functions
      • Window functions
      • System functions
      • Workload management functions
• Catalog reference
  • Types of data exposed by sqream_catalog
  • Tables in the catalog
    • clustering_keys
    • columns
    • external_tables
    • external_table_columns
    • databases
    • database_permissions
    • identity_key
    • permission_types
    • roles
    • roles_memberships
    • savedqueries
    • schemas
    • schema_permissions
    • tables
    • table_permissions
    • udf_permissions
    • user_defined_functions
    • views
  • Additional tables
    • extents
    • chunk_columns
    • chunks
    • delete_predicates
  • Examples
    • List all tables in the database
    • List all schemas in the database
    • List columns and their types for a specific table
    • List delete predicates
    • List saved_queries
• Command line programs
• SQL Feature Checklist
  • Data types and values
  • Contraints
  • Transactions
  • Indexes
  • Schema changes
  • Statements
  • Clauses
  • Table expressions
  • Scalar expressions
  • Permissions
  • Extra functionality