Support Questions

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

oozie derby db

avatar
Master Collaborator

Hi:

How can i connect to the oozie DERBYDB database?? i need to make a backup to update de HDP, and also y want to look the schema.

Thanks

1 ACCEPTED SOLUTION

avatar
Master Guru

@Roberto Sancho - I think you can take backup of below directory and keep it in tar.gz etc. if you are using embedded oozie derby DB.

/hadoop/oozie/data/oozie-db/

To connect to Derby shell:

1. Download derbytools-<version>.jar ( preferably 10.10.1.1) & put it at /usr/hdp/<version>/oozie/libtools/

2. Stop oozie service

3. cd /usr/hdp/<version>/oozie/libtools/

4. export CLASSPATH=derbytools-10.10.1.1.jar:derby-10.10.1.1.jar

5. java org.apache.derby.tools.ij

View solution in original post

4 REPLIES 4

avatar
Master Mentor

avatar
Master Collaborator

thanks, but what i need is to connect to the derby shell to make queries

avatar
Master Mentor

You can use any of the tools in this thread to access derby and look at schema https://community.hortonworks.com/questions/15108/how-to-export-data-from-oozie-derby-database.html

Keep in mind derby is only for test/dev use.

avatar
Master Guru

@Roberto Sancho - I think you can take backup of below directory and keep it in tar.gz etc. if you are using embedded oozie derby DB.

/hadoop/oozie/data/oozie-db/

To connect to Derby shell:

1. Download derbytools-<version>.jar ( preferably 10.10.1.1) & put it at /usr/hdp/<version>/oozie/libtools/

2. Stop oozie service

3. cd /usr/hdp/<version>/oozie/libtools/

4. export CLASSPATH=derbytools-10.10.1.1.jar:derby-10.10.1.1.jar

5. java org.apache.derby.tools.ij