title: Apache Drill 1.2 and Oracle JDBC
body: <p>Using Apache Drill v1.2 and  Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit in embedded mode.</p>
  
  <p>I'm curious if anyone has had any success connecting Apache Drill to an Oracle DB. I've updated the <code>drill-override.conf</code> with the following configurations (per documents):</p>
  
  <pre><code>drill.exec: {
    cluster-id: "drillbits1",
    zk.connect: "localhost:2181",
    drill.exec.sys.store.provider.local.path = "/mypath"
  }
  </code></pre>
  
  <p>and placed the <code>ojdbc6.jar</code> in <code>\apache-drill-1.2.0\jars\3rdparty</code>. I can successfully create the storage plug-in:</p>
  
  <pre><code>{
    "type": "jdbc",
    "driver": "oracle.jdbc.driver.OracleDriver",
    "url": "jdbc:oracle:thin:@&lt;IP&gt;:&lt;PORT&gt;:&lt;SID&gt;",
    "username": "USERNAME",
    "password": "PASSWORD",
    "enabled": true
  }
  </code></pre>
  
  <p>but when I issue a query such as:</p>
  
  <pre><code>    select * from &lt;storage_name&gt;.&lt;schema_name&gt;.`dual`; 
  </code></pre>
  
  <p>I get the following error:</p>
  
  <pre><code>Query Failed: An Error Occurred
  org.apache.drill.common.exceptions.UserRemoteException: VALIDATION ERROR: From line 1, column 15 to line 1, column 20: Table '&lt;storage_name&gt;.&lt;schema_name&gt;.dual' not found [Error Id: 57a4153c-6378-4026-b90c-9bb727e131ae on &lt;computer_name&gt;:&lt;PORT&gt;].
  </code></pre>
  
  <p>I've tried to query other schema/tables and get a similar result. I've also tried connecting to Teradata and get the same error. Does any one have suggestions/run into similar issues?</p>