Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Observe that you need to specify the broker address and datasource as TBLPROPERTIES using the druid.address and druid.datasource properties, respectively. Further, observe that the table needs to be created as EXTERNAL, as data is stored in Druid. The table is just a logical entity that we will use to express our queries, but there is no data movement when we create the table. In fact, what happened under the hood when you execute that statement, is that Hive sends a Segment Metadata Query segment metadata query to Druid in order to discover the schema (columns and their types) of the data source. Retrieval of other information that might be useful such as statistics e.g. number of rows, is in our roadmap, but it is not supported yet.

...