title: sqoop job shell script execute parallel in oozie
body: <p>I have a shell script which executes <code>sqoop job</code>. The script is below.</p>
  
  <pre><code>!#/bin/bash
  
  table=$1
  
  sqoop job --exec ${table}
  </code></pre>
  
  <p>Now when I pass the table name in the workflow I get the sqoop job to be executed successfully.</p>
  
  <p>The workflow is below.</p>
  
  <pre><code>&lt;workflow-app name="Shell_script" xmlns="uri:oozie:workflow:0.5"&gt;
  &lt;start to="shell"/&gt;
  &lt;kill name="Kill"&gt;
      &lt;message&gt;Action failed, error message[${wf:errorMessage(wf:lastErrorNode())}]&lt;/message&gt;
  &lt;/kill&gt;
  &lt;action name="shell_script"&gt;
      &lt;shell xmlns="uri:oozie:shell-action:0.1"&gt;
          &lt;job-tracker&gt;${jobTracker}&lt;/job-tracker&gt;
          &lt;name-node&gt;${nameNode}&lt;/name-node&gt;
          &lt;exec&gt;sqoopjob.sh&lt;/exec&gt;
          &lt;argument&gt;test123&lt;/argument&gt;
          &lt;file&gt;/user/oozie/sqoop/lib/sqoopjob.sh#sqoopjob.sh&lt;/file&gt;
      &lt;/shell&gt;
      &lt;ok to="End"/&gt;
      &lt;error to="Kill"/&gt;
      &lt;/action&gt;
      &lt;end name="End"/&gt;
  &lt;/workflow-app&gt;
  </code></pre>
  
  <p>The job executes successfully  for table <code>test123</code>.</p>
  
  <p>Now I have 300 sqoop jobs same like above. I want to execute 10 sqoop jobs in parallel. All the table names are in a single file. </p>
  
  <p>Now I want to loop to the file and execute 10 sqoop jobs for first 10 tables and so on.  </p>
  
  <p>How can I do this? should I prepare 10 workflows? I am literally confused.</p>