Created on 02-11-2019 02:31 PM - edited 09-16-2022 07:08 AM
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
Created 02-11-2019 04:29 PM
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
Created 08-19-2019 12:23 AM
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
Created 02-24-2019 02:10 AM
Any updates?