2023.03

2023.03

  • Imply
  • Ingest
  • Query
  • Visualize
  • Administer
  • Deploy

›Overview

Overview

  • Querying data
  • Datasources

    • Datasources
    • Joins
    • Lookups
    • Query execution

    Query configuration

    • Query caching
    • Using query caching
    • Query context
  • Enhanced IP support
  • Multi-value dimensions
  • Nested columns
  • Multitenancy
  • Troubleshooting

Druid SQL

  • Overview and syntax
  • SQL data types
  • Druid SQL Functions

    • All functions
    • Operators
    • Scalar functions
    • Aggregation functions
    • JSON functions
    • Multi-value string functions
  • SQL metadata tables
  • SQL query context
  • Async SQL download
  • SQL query translation
  • Druid SQL APIs

    • Druid SQL API
    • Async SQL download API
    • JDBC driver API

Native queries

  • Native queries
  • Native query types

    • Timeseries
    • TopN
    • GroupBy
    • Scan
    • Search
    • TimeBoundary
    • SegmentMetadata
    • DatasourceMetadata

    Native query components

    • Filters
    • Granularities
    • Dimensions
    • Aggregations
    • Post-aggregations
    • Expressions
    • Having filters (groupBy)
    • Sorting and limiting (groupBy)
    • Sorting (topN)
    • String comparators
    • Virtual columns
    • Spatial filters

Querying data

After loading data in Druid, you can run queries against the data using Druid SQL or Druid's native query language. The Druid console provides a visual interface for building and running queries against your data.

Keep in mind that users can query datasources in Pivot as well. The Druid console interface is intended to be used by data set owners or administrators to inspect, validate, and troubleshoot data ingestion and data management issues. On the other hand, data scientists and analysts would likely use Pivot to run queries and explore data. For information about Pivot queries, see SQL in Pivot.

About querying Druid data

Using Druid SQL enables you to use a familiar language for querying data in Druid as you would for other types of databases and data stores. While Druid SQL matches many features of standard SQL, it represents a subset of the functionality of Druid's native query language. In fact, Druid translates SQL queries into native query format behind the scenes.

Which to use? If you are familiar with SQL, it makes sense to start with Druid SQL. Eventually, if additional querying features become necessary or in certain troubleshooting scenarios, familiarity with native queries may become necessary.

Getting started

If you are new to the Druid console and querying data in Druid, a good place to start is with the Querying data tutorial.

For extensive information about Druid SQL, see Druid SQL.

Last updated on 7/21/2021
Datasources →
  • About querying Druid data
  • Getting started
2023.03
Key links
Try ImplyApache Druid siteImply GitHub
Get help
Stack OverflowSupportContact us
Learn more
Apache Druid forumsBlog
Copyright © 2023 Imply Data, Inc