You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org> on 2016/09/08 09:02:20 UTC
[jira] [Updated] (HIVE-14438) Create Table on Druid data source
[ 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)