Support Questions
Find answers, ask questions, and share your expertise

How to solve “Oozie XML schema error E0701”

How to solve “Oozie XML schema error E0701”

Contributor

Below is a simple Oozie script that I tried to run

<!-- This is a comment -->
<workflow-app xmlns = "uri:oozie:workflow:0.4" name = "simple-Workflow">
   <start to = "Create_External_Table" />

   <!-- Step 1 -->
   
   <action name = "Create_External_Table">
      <hive xmlns = "uri:oozie:hive-action:0.4">
         <job-tracker>quickstart.cloudera:8088</job-tracker>
         <name-node>hdfs://quickstart.cloudera:8020</name-node>
         <script>/user/cloudera/external.hive</script>
      </hive>

      <ok to = "Create_orc_Table" />
      <error to = "kill_job" />
   </action>

   <!-- Step 2 -->

   <action name = "Create_orc_Table">
      <hive xmlns = "uri:oozie:hive-action:0.4">
         <job-tracker>quickstart.cloudera:8088</job-tracker>
         <name-node>hdfs://quickstart.cloudera:8020</name-node>
         <script>/user/cloudera/orc.hive</script>
      </hive>
        
      <ok to = "Insert_into_Table" />
      <error to = "kill_job" />
   </action>

   <!-- Step 3 -->
      
   <action name = "Insert_into_Table">
      <hive xmlns = "uri:oozie:hive-action:0.4">
         <job-tracker>quickstart.cloudera:8088</job-tracker>
         <name-node>hdfs://quickstart.cloudera:8020</name-node>
         <script>/user/cloudera/Copydata.hql</script>
         <param>cars</param>
      </hive>
        
      <ok to = "end" />
      <error to = "kill_job" />
   </action>
   
   <kill name = "kill_job">
      <message>Job failed</message>
   </kill>
    
   <end name = "end" />

</workflow-app>

Then I tried running the script ang got the following error: Error: E0701 : E0701: XML schema error, The content of elements must consist of well-formed character data or markup.