Issues with connecting from Tableau to Spark SQL
By default hive config attribute hive.exec.local.scratchdir is set to /tmp/hive, NOT HDFS, despite error message says so
<property>
<name>hive.exec.local.scratchdir</name>
<value>/tmp/hive</value>
<description>Local scratch space for Hive jobs</description>
</property>
Simply change to:
<property>
<name>hive.exec.local.scratchdir</name>
<value>~/tmp/hive</value>
<description>Local scratch space for Hive jobs</description>
</property>
Then in the OS, log in as user that owns HIVE
cd ~
mkdir tmp
cd tmp
mkdir hive
cd ~
chmod -R 777 tmp/hive
Relaunch Tableau to connect to Spark SQL
Simply uninstall ODBC driver.
On Windows, uninstall ODBC driver in the red box from control panel -> program and feature
On Mac, delete or move away ODBC driver file and edit odbcinstall.ini
sudo cp /Library/ODBC/odbcinst.ini /Library/ODBC/odbcinst.ini.org
sudo vi /Library/ODBC/odbcinst.ini
[ODBC Drivers]
PostgreSQL Unicode = Installed
Simba Spark ODBC Driver = Installed
[PostgreSQL Unicode]
Description = PostgreSQL ODBC driver
Driver = /usr/local/lib/psqlodbcw.so
[Simba Spark ODBC Driver]
Driver = /Library/simba/spark/lib/libsparkodbc_sbu.dylib
delete line 3, line 9 and line 10, it should be like below
[ODBC Drivers]
PostgreSQL Unicode = Installed
[PostgreSQL Unicode]
Description = PostgreSQL ODBC driver
Driver = /usr/local/lib/psqlodbcw.so
save and exit vi
Next, move away /Library/simba folder
mv /Libray/simba /Library/simba.org
Then you will get back to initial state of your Tableau Spark SQL log in screen that requires you to download ODBC driver following link on the screen.
or
