oozie derby db

[#1]

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

[#2]

@Roberto Sancho

See this https://github.com/hortonworks/HDP-Public-Utilities/blob/master/Backup/qa.backup_etc_dbs.sh#L65

[#3]

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

[#4]

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.

[#5 · Accepted solution]

@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