Issues with connecting from Tableau to Spark SQL

Permission error with root scratch dir

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

Problem with ODBC driver, then uninstall and reinstall

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