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
.