Hi Katherine Woods,
I think it happens because the Hive is set to strict mode.
This allow the partition table to access the respective partition/folder in hdfs .
Hope this helps!
Lénaïc RIÉDINGER, Global Community Engineer Tableau
If you see an Helpful or Correct response, please mark it thanks to the buttons below the targeted post!
Thanks for the feedback, but this is the first thing I checked. I have an initial SQL statement in there to set it to non-strict. Also, the exact same workbook & connection runs fins on our other server, connecting to the same Hive instance.
Katherine Woods | Senior Software Engineer, Global Services Managed Analytics|
image001.png 14.5 KB
This issue was resolved by back rev'ving the Cloudera Hive ODBC drivers from 2.5.21 to 2.5.19 and restarting the machine. Hope this helps other users!