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
