Druid and Hive error, Getting attached error .

[#1]

1: jdbc:hive2://devhcdl2.azure.ril.com:2181 ,CREATE EXTERNAL TABLE druid_5 STORED BY 'org.apache.hadoop.hive.druid.DruidStorageHandler' TBLPROPERTIES ("druid.datasource" ="meetup10"); INFO : Compiling command(queryId=hive_20190211131220_f397f9c3-6a76-4eae-b4ab-7344015d381e): CREATE EXTERNAL TABLE druid_5 STORED BY 'org.apache.hadoop.hive.druid.DruidStorageHandler' TBLPROPERTIES ("druid.datasource" ="meetup10") INFO : Semantic Analysis Completed (retrial = false) INFO : Returning Hive schema: Schema(fieldSchemas:null, properties:null) INFO : Completed compiling command(queryId=hive_20190211131220_f397f9c3-6a76-4eae-b4ab-7344015d381e); Time taken: 0.053 seconds INFO : Executing command(queryId=hive_20190211131220_f397f9c3-6a76-4eae-b4ab-7344015d381e): CREATE EXTERNAL TABLE druid_5 STORED BY 'org.apache.hadoop.hive.druid.DruidStorageHandler' TBLPROPERTIES ("druid.datasource" ="meetup10") INFO : Starting task [Stage-0:DDL] in serial mode ERROR : FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.RuntimeException: MetaException(message:org.apache.hadoop.hive.serde2.SerDeException Connected to Druid but could not retrieve datasource information) INFO : Completed executing command(queryId=hive_20190211131220_f397f9c3-6a76-4eae-b4ab-7344015d381e); Time taken: 0.031 seconds Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.RuntimeException: MetaException(message:org.apache.hadoop.hive.serde2.SerDeException Connected to Druid but could not retrieve datasource information) (state=08S01,code=1)

Please help me on this

[#2]

@Mohammad Layeeq

I am wondering did you set you to need to set the Hive property hive.druid.broker.address.default in your configuration to point to the broker address. You ought to have already stored the meetup10 dataset mentioned previously in Druid at the address of the Druid broker see the example below

Note: In your source table the timestamp column (__time) mandatory in Druid

SET hive.druid.broker.address.default=192.168.0.10:8082;

Then you can run your DDL

CREATE EXTERNAL TABLE druid_5 
STORED BY 'org.apache.hadoop.hive.druid.DruidStorageHandler'
TBLPROPERTIES ("druid.datasource" = "meetup10");

Can you try that and revert

[#3]

Hi ,

I already configured druid broker IP and port 8082,but even though I am getting same error

Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.RuntimeException: MetaException(message:org.apache.hadoop.hive.serde2.SerDeException Connected to Druid but could not retrieve datasource information) (state=08S01,code=1)

Please  suggest solution

[#4]

@Mohammad Layeeq

Any updates?