title: "Unexpected Error" on Join 2 simple tables
body: <p>I have created a hive database. I have created an ODBC Data source to Hive using Hortonworks ODBC Driver for Hive.</p>
  
  <p>I use this data source from Tableau 9 (desktop).</p>
  
  <p>I can query Table DimA, I can query Table FactA. But in tableau if I try to do a join I get error</p>
  
  <pre><code>[Hortonworks][HiveODBC] (35) Error from Hive: error code: '0' error message: 'ExecuteStatement finished with operation state: ERROR_STATE'.
  Unexpected Error
  </code></pre>
  
  <p>I can easily go to my cluster and issue the same query in hiveshell without any problems and it returns results.</p>
  
  <p>I searched the Internet and people have this permission problem which gets solved by "grant".. but in this case I am able to query individual 2 tables (dima, facta) easily from tableau... but ONLY when I JOIN the tables that it throws the above error.</p>
  
  <p>I tried the "New Custom SQL" and copy pasted the SQL which worked in hive Shell... but tableau threw the error.</p>
  
  <pre><code>[Hortonworks][HiveODBC] (35) Error from Hive: error code: '40000' error message: 'Error while compiling statement: FAILED: ParseException line 1:11 cannot recognize input near 'TOP' '1' '*' in select expression'.
  </code></pre>