[
https://issues.apache.org/jira/browse/HIVE-14438?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jesus Camacho Rodriguez updated HIVE-14438:
-------------------------------------------
Description:
Starting implementation of Storage Handler for Druid.
First assuming the data already sits in Druid. We will allow users to declare a
table in Hive that references a datasource in Druid.
The proposed syntax is as follows:
{code:sql}
CREATE TABLE druid_table_1
STORED BY 'org.apache.hadoop.hive.druid.DruidStorageHandler'
TBLPROPERTIES ("druid.datasource" = "xyz");
{code}
For the statement above, the Druid datasource that we want to query is {{xyz}}.
The *schema* of the new table is discovered automatically issuing a
SegmentMetadata to Druid that will retrieve the names and types of the columns
present in the datasource.
was:
Starting implementation of Storage Handler for Druid.
First assuming the data already sits in Druid. We will allow users to declare a
table in Hive that references a datasource in Druid.
The proposed syntax is as follows:
{code:sql}
CREATE TABLE druid_table_1
STORED BY 'org.apache.hadoop.hive.druid.DruidStorageHandler'
TBLPROPERTIES ("druid.address" = "localhost", "druid.datasource" = "xyz");
{code}
For the statement above, the Druid broker hostname is {{localhost}}, while the
Druid datasource that we want to query is {{xyz}}.
The *schema* of the new table is discovered automatically issuing a
SegmentMetadata to Druid that will retrieve the names and types of the columns
present in the datasource.
> Create Table on Druid data source
> ---------------------------------
>
> Key: HIVE-14438
> URL: https://issues.apache.org/jira/browse/HIVE-14438
> Project: Hive
> Issue Type: Sub-task
> Components: Druid integration
> Reporter: Jesus Camacho Rodriguez
> Assignee: Jesus Camacho Rodriguez
> Fix For: 2.2.0
>
>
> Starting implementation of Storage Handler for Druid.
> First assuming the data already sits in Druid. We will allow users to declare
> a table in Hive that references a datasource in Druid.
> The proposed syntax is as follows:
> {code:sql}
> CREATE TABLE druid_table_1
> STORED BY 'org.apache.hadoop.hive.druid.DruidStorageHandler'
> TBLPROPERTIES ("druid.datasource" = "xyz");
> {code}
> For the statement above, the Druid datasource that we want to query is
> {{xyz}}.
> The *schema* of the new table is discovered automatically issuing a
> SegmentMetadata to Druid that will retrieve the names and types of the
> columns present in the datasource.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
