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.