Querying

This section provides an overview of how to query CrateDB.

See also

General use: Data definition

General use: Data manipulation

• Selecting data
• Introduction
• FROM clause
• Joins
• DISTINCT clause
• WHERE clause
• Comparison operators
• Array comparisons
• Container data types
• Aggregation
• Window functions
• GROUP BY
• Joins
• Cross joins
• Inner joins
• Outer joins
• Join conditions
• Available join algorithms
• Limitations
• Union All
• 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