You can translate the question and the replies:

jdbc connection to denodo derived view fails for multi-table join

Hi, We are using squirrel sql client to test extracts for a UI. we can read base views and 2 table joins fine but 3 or more tables results in semanticexception error 10009, invalid table alias 't0'. the same query works fine in denodo client and the web service. Sourcing from Hive on HDP 2.5 Any guidance would be much appreciated.
JDBC hive; hadoop
user
09-02-2017 21:49:08 -0500
code

1 Answer

Hi, It seems there's an issue in the Hive Simba driver you're using. While the issue is not resolved by Simba, there's a workaround: Enable the ***UseNativeQuery*** in your connection URI. Hope this helps.
Denodo Team
10-03-2017 08:33:19 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here