I created a sqoop job in the JobDesign, but when I submit this job, I have an error like this:
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. InvalidObjectException(message:There is no database named pedido)
But this database exist, I can do select in the database with Hive, and, I can run the same sooq scritp in the shell with success.
Aparently sqoop can't access the database when running by the oozie workflow.
For anyone else that may run into a similar issue, this ultimately resolved the issue after I created the job as part of a workflow (Workflows -> Editor -> New). Initially the sqoop job was created in job designer (Query Editors -> Job Designer -> New Action) . There is an option when created as a workflow to select the credentials needed for the job.
Is this something that can be configured in CM so that the hive-site.xml file does not have to be added to every sqoop job that is created?