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 Container data types Aggregation Window functions GROUP BY Joins Cross joins Inner joins Outer joins Join conditions Available join algorithms Limitations Union Union All Union Distinct 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