Druid Meta store Details

Hi Team,

I am using derby database along with druid. I wanted to know where we I can find the derby database details like. where it is exactly stored in the machine. How I can create table and database other than by default druid.

It’s urgent!!!

Thanks,

Ashish

Hi Ashish,

You can find the Derby database in the common.runtime.properties under /conf/druid/_common. In the file, search for the Metadata storage and get the details. Generally, the derby host will be in Master.

druid.metadata.storage.type=derby
druid.metadata.storage.connector.connectURI=jdbc:derby://localhost:1527//opt/var/druid_state/derby;create=true

Below links might be helpful.

http://druid.io/docs/latest/dependencies/metadata-storage.html

https://db.apache.org/derby/docs/10.5/getstart/twwdactivity1.html

Thanks,

Hemanth

But can I access druid’s derby database. Its all jar files in the directory structure

/opt/apache-druid-0.14.1-incubating/lib/derby-10.11.1.1.jar

/opt/apache-druid-0.14.1-incubating/lib/derbyclient-10.11.1.1.jar

/opt/apache-druid-0.14.1-incubating/lib/derbynet-10.11.1.1.jar

/opt/apache-druid-0.14.1-incubating/var/druid/derby.log

/opt/tranquility-distribution-0.8.3/lib/org.apache.derby.derby-10.11.1.1.jar

/opt/tranquility-distribution-0.8.3/lib/org.apache.derby.derbyclient-10.11.1.1.jar

/opt/tranquility-distribution-0.8.3/lib/org.apache.derby.derbynet-10.11.1.1.jar

Thanks,

Ashish

.