Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Druid integration with Hive LLAP

avatar
Explorer

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.

1 ACCEPTED SOLUTION

avatar
Expert Contributor

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

View solution in original post

2 REPLIES 2

avatar
Expert Contributor

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

avatar
Explorer

Hi Slim,

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