Concepts

​

Entities

• Schemas
• Types
  • Data Types
    • Array
    • JSON
    • Vector
  • Column Properties
  • Nulls
• Tables
  • Distribution (Sharding/Replication)
  • Partitioning
  • Primary Keys
  • Soft Primary Keys
  • Shard Keys
  • Foreign Keys
• Views
  • Filtered
  • Joined
  • Materialized
• Indexes
  • Primary Key
  • Relational
  • Column (Attribute)
  • Low-Cardinality
  • Chunk Skip
  • Geospatial
  • CAGRA
  • HNSW
• Credentials
• Data Sources
• Data Sinks
• External Tables
• Graphs
• Table Monitors

​

Features

• Column Compression
• Dictionary Encoding
• Full Text Search
• TTL

​

Operations

• Expressions (Operators/Functions)
• Aggregation
• Iteration
• Memory-Only Tables
• Projections
• Joins
• Set Unions
• Set Intersections (Intersect)
• Set Subtractions (Except)
• Window
• Rollup
• Cube
• Grouping Sets
• Pivot
• Unpivot