title: HortonWorks “Table or view not found” when querying Hive from Excel using ODBC connection in Mac
body: <p>I am using <strong>Hortonworks sandbox 2.1</strong> with <strong>Apache Hive ODBC driver 2.1</strong> and <strong>iODBC</strong>. </p>
  
  <p>The <code>ODBC</code> connection is successful when I test it using the <code>iODBC</code> software. But, when I open excel and use Microsoft query to return the data to excel spreadsheet I get this error when I run SQL <code>SELECT</code> query </p>
  
  <blockquote>
    <p>: [Hortonworks][SQLEngine] (31740) Table or view not found:
    HIVE.default.tweetsbi.</p>
  </blockquote>
  
  <p>I am able to view the tables inside the database, but I can't view the content of them. Whenever I press Run I get the aforementioned error. </p>
  
  <p>I am getting the same error in both <code>Excel 2011</code> and <code>2016</code></p>
  
  <p><a href="https://i.stack.imgur.com/prCd0.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/prCd0.png" alt="enter image description here"></a></p>