[ 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)