Querying

This section provides an overview of how to query CrateDB.

See also

General use: Data definition

General use: Data manipulation

Table of contents

• Selecting data
  • Introduction
  • FROM clause
  • Joins
  • DISTINCT clause
  • WHERE clause
  • Comparison operators
  • Array comparisons
  • EXISTS
  • Container data types
  • Aggregation
  • Window functions
  • GROUP BY
  • WITH Queries (Common Table Expressions)
• Joins
  • Cross joins
  • Inner joins
  • Outer joins
  • Join conditions
  • Available join algorithms
  • Limitations
• Union
  • Union All
  • Union Distinct
  • Union of object types
  • Union of different types
• Refresh
  • Introduction
  • Multiple Table Refresh
  • Partition Refresh
• Fulltext search
  • MATCH Predicate
  • Usage
  • Searching On Multiple Columns
  • Negative Search
  • Filter By _score
• Geo search
  • Introduction
  • MATCH predicate
  • Exact queries