Druid integration with Hive LLAP

[#1]

hive-llap-druid-eror.txt

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.

[#2 · Accepted solution]

@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.*

[#3]

Hi Slim,

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