title: Oozie workflow: Hive table not found but it does exist
body: <p>I got a oozie workflow, running on a CDH4 cluster of 4 machines (one master-for-everything, three "dumb" workers). The hive metastore runs on the master using mysql (driver is present), the oozie server also runs on the master using mysql, too. Using the web interface I can import and query hive as expected, but when I do the same queries within an oozie workflow it fails. Even the addition of the "IF EXISTS" leads to the error below. I tried to add the connection information as properties to the hive job without any success.</p>
  
  <p>Can anybody give me a hint? Did I miss anything? Any further information needed?</p>
  
  <p>This is the output of the job's log:</p>
  
  <pre><code>  Script [drop.sql] content:
    ------------------------
    DROP TABLE IF EXISTS performance_log;
  
    ------------------------
  
    Hive command arguments :
    -f
    drop.sql
  
    =================================================================
  
    &gt;&gt;&gt; Invoking Hive command line now &gt;&gt;&gt;
  
    Intercepting System.exit(10001)
  
    &lt;&lt;&lt; Invocation of Main class completed &lt;&lt;&lt;
  
    Failing Oozie Launcher, Main class [org.apache.oozie.action.hadoop.HiveMain], exit code [10001]
  
    Oozie Launcher failed, finishing Hadoop job gracefully
  </code></pre>
  
  <p>And this is the error message:</p>
  
  <pre><code>  FAILED: SemanticException [Error 10001]: Table not found performance_log
    Intercepting System.exit(10001)
    Failing Oozie Launcher, Main class [org.apache.oozie.action.hadoop.HiveMain], exit code [10001]
  </code></pre>