Support Questions

Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

Druid integration with Hive LLAP

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

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

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

Explorer

Hi Slim,

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

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.