Query Ocient

The Ocient Hyperscale Data Warehouse™ contains one or more SQL relational databases. Ocient® follows the PostgreSQL® dialect closely and most functions operate the same in Ocient as in PostgreSQL.

• Quick Start Querying
• Query Performance Tuning
• General SQL Syntax
  • Join Operations
  • SQL Syntax Conventions
  • Identifiers
  • Generate Tables Using sys.dummy
• Understanding Data Types
  • Array, Tuple, and Matrix Overview
• Functions Overview