Author: polaris

Created with Sketch.

Using Druid as a linked data source in Metatron Discovery

When creating a dashboard from a data source already loaded in Druid, it is often difficult to visualize with Metatron Discovery when complex queries such as subquery are required. In such a case, it can be solved by creating a Linked Datasource after creating an appropriate query using Druid SQL. 1. Data Set Use the…
Read more

Kepler.gl on Druid Spatial Query

Metatron distributed Druid provides GIS indexing function for WKT format files, and supports various GIS functions. It also provides SQL query interface for ease of use, and a function to export the result to GeoJson format. This example briefly explains how to analyze location data using Spatial Query provided by Metatron distributed Druid and Kepler.gl.…
Read more

Exporting data using Druid SQL

Metatron distribution Druid provides a function to export JSON query results to files in various formats such as ORC, Parquet, JSON, CSV, Excel, etc. The syntax for this is specified in the context of the Druid JSON query and is as follows. The description and values ​​for each setting are as follows. Required Description Value…
Read more

[New Feature Introducing]“Explain Plan”statement for Druid SQL

Druid SQL is a very convenient interface that allows you to execute queries on Druid in SQL format. However, Druid Query in JSON format still provides powerful features that Druid SQL cannot provide (for example, when you want to export query results in orc format). The problem is that the more complicated the Druid Query…
Read more