Blog

Created with Sketch.

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

Time Series Data Analysis Using Metatron Discovery

Metatron Discovery utilizes Druid as a data processing engine, and thus has many strengths in analyzing large time series based data. Metatron Discovery was developed to take full advantage of these features of Druid. In this example, we will explain how to analyze time series data using Metatron Discovery through an example. Visualizing time series…
Read more