QueryingQueryingThis section provides an overview of how to query CrateDB. See also General use: Data definition General use: Data manipulation Selecting data IntroductionFROM clauseJoinsDISTINCT clauseWHERE clauseComparison operatorsArray comparisonsContainer data typesAggregationWindow functionsGROUP BY Joins Cross joinsInner joinsOuter joinsJoin conditionsAvailable join algorithmsLimitations Union AllRefresh IntroductionMultiple Table RefreshPartition Refresh Fulltext search MATCH PredicateUsageSearching On Multiple ColumnsNegative SearchFilter By _score Geo search IntroductionMATCH predicateExact queries