Forum Discussion
Spark - Wrong query generated
Hi, We're using Spark Connector to send queries to our custom Spark Server. However, we receive some queries that are not Spark protocol (e.g. SELECT TOP). This is not valid Hive SQL. The...
Hi, I have a PBI model where I join a table in Direct Query with another one in Import mode (everything is on top of spark of course).
I was able to fix this issue by changing the type of the key from the table in import mode that was in the join condition. It was trying to join one of the key in "Whole Number" and the other one in "String".
It's quite weird that this change fixed the issue but I did not encounter this wrong auto-generated SparkSql issues anymore...
Hope this gives you something to look into.