Feedback

  Suggest improvement

  Edit page

  View page source

3.3

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