<workflow-app name="Sqoop and Hive2 Test" xmlns="uri:oozie:workflow:0.5">
<start to="sqoop-a3af"/>
<action name="sqoop-a3af">
<sqoop xmlns="uri:oozie:sqoop-action:0.2">
<job-tracker>${jobTracker}</job-tracker>
<name-node>${nameNode}</name-node>
<command>import --m 1 --connect jdbc:mysql://host:port/navigator --username user --password-file /user/32230704/passwords --table HIVE_AUDIT_EVENTS_2018_10_29 --delete-target-dir --target-dir=/user/hive/warehouse/das_audit_navigator_db.db/HIVE_AUDIT_EVENTS_2018_10_29 --hive-import --hive-overwrite --hive-table das_audit_navigator_db.amore_audit_test</command>
<file>/user/32230704/oozie-oozi/hive-site.xml#hive-site.xml</file>
</sqoop>
<ok to="End"/>
<error to="Kill"/>
</action>
<kill name="Kill">
<message>Action failed, error message[${wf:errorMessage(wf:lastErrorNode())}]</message>
</kill>
<end name="End"/>
</workflow-app> oozie.use.system.libpath=True
send_email=False
dryrun=False
credentials={u'hcat': {'xml_name': u'hcat', 'properties': [('hcat.metastore.uri', u'thrift://host:port'), ('hcat.metastore.principal', u'hive/host@host')]}, u'hive2': {'xml_name': u'hive2', 'properties': [('hive2.jdbc.url', u'jdbc:hive2://host:port/default;ssl=true;sslTrustStore=/opt/cloudera/security_ca/jks/cloudera.truststore'), ('hive2.server.principal', u'hive/host@host')]}, u'hbase': {'xml_name': u'hbase', 'properties': []}}
nameNode=hdfs://name
submit_single_action=True
jobTracker=yarnRM
security_enabled=True path to hive-site.xml /user/32230704/oozie-oozi/hive-site.xml
... View more
