Querying Crate

This section provides an overview on how to query documents using SQL. See Data Definition for information about Table creation and other Data Definition statements.

Table of Contents

• Selecting Data
  • Introduction
  • FROM Clause
  • Joins
  • DISTINCT Clause
  • WHERE Clause
  • Regular Expressions
  • LIKE
  • NOT
  • IN
  • IS NULL
  • IS NOT NULL
  • ANY (array)
  • Limits
  • Inner Objects and Nested Objects
  • Object Arrays
  • Data Aggregation
  • Window Functions
  • GROUP BY
• Joins
  • Cross Joins
  • Inner Joins
  • Left Outer Joins
  • Right Outer Joins
  • Full 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