[OOZIE-3177] Unclear ooziedb -sqlFile option behaviour

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: scripts
• Assignee: Unassigned
• Reporter: Kinga Marton
• Created: 07/Feb/18 13:06
• Updated: 05/Aug/19 11:21

Description

There are two scenarios when running ooziedb.sh with -sqlscript option can lead to misunderstandings:

full command: ooziedb.sh upgrade -sqlfile oozie-upgrade.sql

1. if there are no changes, the following information is printed out: "The SQL commands have been written to: oozie-upgrade.sql", however if there is no SQL command, the file will be not created. 
2. If there are changes and the file is created, it is stored in the /tmp/ directory. In the log message it would be good to print out the full path to the file, not only the file name.

Issue Links

• relates to: OOZIE-3174 Allow users to retain SQL file generated by OozieDBCLI