I'm currently facing some trouble to use the Custom SQL while connected on Hive through the Hortonworks Hadoop Hive connector.
The connection was sucessful, and I can visualize the data from the tables on Tableau.
However, when I try to run a custom query (as simple as a "Select Count(*) from table") I receive the following error:
"Error to load data
Unable to resolve relationship associations [TableauSQL]"
Does anyone have any idea what it could be? When I run my query on ambari, it returns the expected results
Thanks so much in advance!
Hello Raquel - have you been able to resolve this issue?
I usually find that custom sql errors are a result of a format error related to the fact that Tableau is wrapping the code within another Select * command to prevent Insert, Drop, etc..