SQL Reference

• Creating and Modifying Distributed Tables (DDL)
  • Creating And Distributing Tables
  • Co-Locating Tables
  • Dropping Tables
  • Modifying Tables
• Ingesting, Modifying Data (DML)
  • Inserting Data
• Caching Aggregations with Rollups
  • Updates and Deletion
  • Maximizing Write Performance
• Querying Distributed Tables (SQL)
  • Aggregate Functions
  • Limit Pushdown
  • Views on Distributed Tables
  • Joins
• Query Processing
  • Distributed Query Planner
  • Distributed Query Executor
  • PostgreSQL planner and executor
• Manual Query Propagation
  • Running on all Workers
  • Running on all Shards
  • Running on all Placements
  • Limitations
• SQL Support and Workarounds
  • Workarounds