2021.02

2021.02

  • Imply
  • Pivot
  • Druid
  • Manager
  • Clarity

›Query data

Overview

  • Pivot overview
  • Navigation

Data

  • Data ingestion
  • Datasources

Visualize

    Data cubes

    • About data cubes
    • Managing data cubes
    • Dimensions
    • Measures
    • Visualizations
    • Time compare
    • Filter by measure
    • Data export

    Dashboards

    • About dashboards
    • Managing dashboards

Query data

  • SQL
  • Monitor queries

Alerts & Reports

  • Alerts
  • Scheduled reports

Manage user access

  • Access control
  • User management in Pivot
  • Manage users with LDAP
  • Manage users with OIDC

Advanced usage

  • Pivot server config
  • Pivot API
  • Generating links into Pivot
  • White label deployment
  • Load Hadoop data via Amazon EMR

Experimental features

  • Explain
  • Annotations
  • Pivot SQL

SQL

Imply allows you to run SQL queries through Druid SQL, a built-in SQL layer and an alternative to Druid's native JSON-based query language. Druid SQL is powered by a parser and planner based on Apache Calcite. Druid SQL queries are translated into native queries on the query broker (the first node you query), which are then passed down to data nodes as native queries. Other than the (slight) overhead of translating SQL on the broker, Druid SQL queries do not impose an additional performance penalty versus native queries.

SQL in Pivot

Pivot includes a graphical SQL query interface:

SQL results

On the left is a bar showing queryable datasets (tables) and their schemas.

To run a query simply enter it into the SQL query box. You can make use of the auto complete feature and the schema on the left to compose your query. Then click Run. The results will appear in the results pane. You can now iterate on your query, share it, and download the results locally using the controls in the interface.

It is also possible to explain the query plan for a given SQL query by selecting "Explain query" from the ... button.

If user management is enabled in Pivot (the default in Cloud Imply), users need to have AccessSQL permissions to view or use the SQL interface.

More information

For much more information on Druid SQL, including details on its features and syntax, see the Druid SQL documentation.

← Managing dashboardsMonitor queries →
  • SQL in Pivot
  • More information
2021.02
Key links
Try ImplyApache Druid siteImply GitHub
Get help
Stack OverflowSupportContact us
Learn more
BlogApache Druid docs
Copyright © 2021 Imply Data, Inc