...
Further, note that if we do not specify the value for the druid.datasource property, Hive automatically uses the fully qualified name of the table to create the corresponding datasource with the same name.
| Info | ||
|---|---|---|
| ||
Version 32.02.0-: CREATE TABLE syntax when data is managed via hive. CREATE TABLE druid_table_1 (`__time` TIMESTAMP, `dimension1` STRING, `dimension2` STRING, `metric1` INT, `metric2` FLOAT) STORED BY 'org.apache.hadoop.hive.druid.DruidStorageHandler'; NOTE - Before Hive 3.0.0, we do not use EXTERNAL tables and do not specify the value for the For versions 3.0.0+, All Druid tables are EXTERNAL (HIVE-20085). |
Druid kafka ingestion from Hive
...
INSERT, INSERT OVERWRITE and DROP statements
| Info | ||
|---|---|---|
| ||
Version 2.2.0 : These statements are supported by Hive managed tables (not external) backed by Druid |
...
. For versions 3.0.0+, All Druid tables are EXTERNAL (HIVE-20085) and these statements are supported for any table. |
Querying Druid from Hive
Once we have created our first table stored in Druid using the DruidStorageHandler, we are ready to execute our queries against Druid.
...