Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Druid and Hive error, Getting attached error .

Highlighted

Druid and Hive error, Getting attached error .

New Contributor

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

3 REPLIES 3

Re: Druid and Hive error, Getting attached error .

Mentor

@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

Re: Druid and Hive error, Getting attached error .

New Contributor

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

Re: Druid and Hive error, Getting attached error .

Mentor

@Mohammad Layeeq

Any updates?