Are you using CM?

If yes before running the command you need to:


*Note*:

If using CM, export this variable in order to point to the correct database:
1
2
3
HUE_CONF_DIR=/var/run/cloudera-scm-agent/process/-hue-HUE_SERVER-id
echo $HUE_CONF_DIR
export HUE_CONF_DIR

Where is the most recent ID in that process directory for
hue-HUE_SERVER.


http://gethue.com/export-and-import-your-oozie-workflows/