Support Questions

Find answers, ask questions, and share your expertise
Announcements
Welcome to the upgraded Community! Read this blog to see What’s New!

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.

Labels