question Re: Druid integration with Hive LLAP in Archives of Support Questions (Read Only)

Druid integration with Hive LLAP

lnc_adoni — Fri, 16 Sep 2022 13:09:29 GMT

Hi,

I am testing Druid with very small amount of data, treat my case as POC before working on big data set.

When creating table on Druid, iam getting Mysql jdbc error. Thought i have specified postgres as my database for metastore.

Am i missing my configuration parameter?

Please help. Thanks in advance.

Re: Druid integration with Hive LLAP

sbouguerra — Sun, 29 Apr 2018 04:32:27 GMT

@ln Chari

the properties you need are

set hive.druid.metadata.db.type=postgresql;
set hive.druid.metadata.username=${DRUID_USERNAME};
set hive.druid.metadata.password=${DRUID_PASSWORD};
set hive.druid.metadata.uri=jdbc:postgresql://${METADATA_DRUID_HOST}:5432/druid;

You were missing hive.druid.metadata.db.type

Also make sure that ${DRUID_USERNAME} are replaced with actual values

You do not need all the properties starting with druid.*

Re: Druid integration with Hive LLAP

lnc_adoni — Wed, 02 May 2018 16:17:51 GMT

Hi Slim,

Thanks for your response. That worked. I have few more questions, i will open a new thread.