crate.io Logo
  • Products
    • CrateDB
    • CrateDB Cloud
    • Pricing
    • Get CrateDB
  • Customers
    • Success Stories
    • Use Cases
  • Compare
  • Company
    • About us
    • Careers
    • Partners
    • Newsroom
    • Newsletter
    • Events
    • Contact us
  • Resources
    • Documentation
    • Videos
    • Webinars
    • White Papers
    • Community
  • Blog
  •  
  • Login
  • Contact us
Toggle Doc Menu
Search Documentation
    • CrateDB
      • Tutorials
      • How-To Guides
      • Reference
        • Concepts
          • Joins
            • Types of join
            • Joins in CrateDB
          • Clustering
            • Components of a CrateDB Node
            • Multi-node setup: Clusters
            • Cluster behavior
            • Application use case
          • Storage and consistency
            • Data storage
            • Atomicity at document level
            • Durability
            • Addressing documents
            • Consistency
            • Cluster meta data
          • Resiliency
            • Overview
        • CLI tools
          • crate
            • Synopsis
            • Options
            • Signal handling
            • Example
          • crate-node
            • Synopsis
            • Commands
            • Options
        • Configuration
          • Node-specific settings
            • Basics
            • Node types
            • Read-only node
            • Hosts
            • Ports
            • Paths
            • Plug-ins
            • CPU
            • Memory
            • Garbage collection
            • Authentication
            • Secured communications (SSL/TLS)
            • Cross-origin resource sharing (CORS)
            • Blobs
            • Repositories
            • Queries
            • JavaScript language
            • Custom attributes
          • Cluster-wide settings
            • Non-runtime cluster-wide settings
            • Collecting stats
            • Shard limits
            • Usage data collector
            • Graceful stop
            • Bulk operations
            • Discovery
            • Routing allocation
            • Recovery
            • Memory management
            • Query circuit breaker
            • Field data circuit breaker
            • Request circuit breaker
            • Accounting circuit breaker
            • Stats circuit breakers
            • Total circuit breaker
            • Thread pools
            • Metadata
          • Session settings
            • Usage
            • Supported session settings
          • Logging
            • Application logging
            • JVM logging
          • Environment variables
            • Application variables
            • JVM variables
        • General use
          • Data definition
            • Creating tables
            • Data types
            • System columns
            • Generated columns
            • Constraints
            • Storage
            • Partitioned tables
            • Sharding
            • Replication
            • Shard allocation filtering
            • Column policy
            • Fulltext indices
            • Fulltext analyzers
            • Show Create Table
            • Views
            • Altering tables
          • Data manipulation
            • Inserting data
            • Updating data
            • Deleting data
            • Import and export
          • Querying
            • Selecting data
            • Joins
            • Union All
            • Refresh
            • Fulltext search
            • Geo search
          • Built-in functions and operators
            • Scalar functions
            • Aggregation
            • Arithmetic operators
            • Table functions
            • Comparison operators
            • Array comparisons
            • Subquery expressions
            • Window functions
          • User-defined functions
            • CREATE OR REPLACE
            • Supported types
            • Overloading
            • Determinism
            • DROP FUNCTION
            • Supported languages
          • Blobs
            • Creating a table for blobs
            • Custom location for storing blob data
            • List
            • Altering a blob table
            • Deleting a blob table
            • Using blob tables
          • Optimistic Concurrency Control
            • Introduction
            • Optimistic update
            • Optimistic delete
            • Known limitations
          • Information schema
            • Access
            • Virtual tables
        • Administration
          • System information
            • Cluster
            • Nodes
            • Node checks
            • Shards
            • Segments
            • Jobs, operations, and logs
            • Cluster checks
            • Health
            • Repositories
            • Snapshots
            • Snapshot Restore
            • Summits
            • Users
            • Allocations
            • Shard table permissions
            • Sys jobs tables permissions
            • pg_stats
          • Runtime configuration
          • User management
            • CREATE USER
            • ALTER USER
            • DROP USER
            • List users
          • Privileges
            • Introduction
            • Privilege types
            • Hierarchical inheritance of privileges
            • Behavior of GRANT, DENY and REVOKE
            • List privileges
          • Authentication
            • Authentication Methods
            • Host Based Authentication (HBA)
          • Secured communications (SSL/TLS)
            • SSL/TLS configuration
            • Setting up a Keystore/Truststore with a certificate chain
          • Optimization
            • Introduction
            • Multiple table optimization
            • Partition optimization
            • Segments upgrade
          • Jobs management
          • JMX monitoring
            • Setup
            • Using Docker
            • JMX Beans
            • Exposing JMX via HTTP
          • Snapshots
            • Snapshot
            • Restore
            • Cleanup
            • Requirements for using HDFS repositories
          • Cloud discovery
            • Amazon EC2 discovery
            • Microsoft Azure discovery
          • Usage Data Collector
            • Technical information
            • Admin UI tracking
            • Configuration
            • How to disable UDC
        • SQL syntax
          • General SQL
            • Constraints
            • Value expressions
            • Lexical structure
          • SQL Statements
            • ALTER CLUSTER
            • ALTER TABLE
            • ALTER USER
            • ANALYZE
            • BEGIN
            • COMMIT
            • COPY FROM
            • COPY TO
            • CREATE ANALYZER
            • CREATE BLOB TABLE
            • CREATE FUNCTION
            • CREATE REPOSITORY
            • CREATE SNAPSHOT
            • CREATE TABLE
            • CREATE TABLE AS
            • CREATE USER
            • CREATE VIEW
            • DEALLOCATE
            • DELETE
            • DENY
            • DISCARD
            • DROP ANALYZER
            • DROP CONSTRAINT
            • DROP FUNCTION
            • DROP REPOSITORY
            • DROP SNAPSHOT
            • DROP TABLE
            • DROP USER
            • DROP VIEW
            • EXPLAIN
            • GRANT
            • INSERT
            • KILL
            • OPTIMIZE
            • REFRESH
            • RESTORE SNAPSHOT
            • REVOKE
            • SELECT
            • SET and RESET
            • SET LICENSE
            • SET AND RESET SESSION AUTHORIZATION
            • SET TRANSACTION
            • SHOW COLUMNS
            • SHOW CREATE TABLE
            • SHOW SCHEMAS
            • SHOW TABLES
            • SHOW (session settings)
            • UPDATE
            • VALUES
        • Client interfaces
          • HTTP endpoint
            • Introduction
            • Parameter substitution
            • Default schema
            • Column types
            • Bulk operations
            • Error handling
          • PostgreSQL wire protocol
            • Server compatibility and implementation status
            • Client compatibility
            • Implementation differences
        • Appendices
          • Release Notes
            • Versions
            • Older Versions
          • SQL compatibility
            • Implementation notes
            • Unsupported features and functions
          • SQL standard compliance
          • Resiliency Issues
            • Known issues
            • Fixed issues
          • Glossary
            • Terms
      • Clients and Tools
      • Admin UI
      • Crash CLI
    • CrateDB Cloud
      • Tutorials
      • How-To Guides
      • Reference
      • Croud CLI
    • JDBC
    • PHP DBAL
    • PHP PDO
    • Python
    • .NET Npgsql
    • Sample Applications
    • Support
v:4.5
master latest 4.5 4.4 3.3

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 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

Feedback

How helpful was this page?
New issue Edit on GitHub View on GitHub
  • Product
  • CrateDB
  • CrateDB Cloud
  • Compare
  • Download
  • CrateDB Cloud Login
  • Pricing
  • Use Cases
  • Success Stories
  • Use Cases
  • IoT & Sensors
  • Time Series
  • Geospatial Tracking
  • Cybersecurity
  • Resources
  • Blog
  • Content Library
  • Videos
  • Webinars
  • White Papers
  • Developers
  • Get Started
  • Reference
  • How-To Guides
  • Support
  • SQL 99 Docs
  • Community
  • Github
  • Contribute
  • Company
  • About us
  • Jobs
  • Events
  • Newsletter
  • Partners
  • Press
  • Security
  • Contact
  • Legal
  • Privacy Policy
  • Imprint
  • European Regional Development Funds Logo
crate.io Logo