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
1
<property>
2
<name>hive.exec.local.scratchdir</name>
3
<value>/tmp/hive</value>
4
<description>Local scratch space for Hive jobs</description>
5
</property>
6
​
Copied!
Simply change to:
1
<property>
2
<name>hive.exec.local.scratchdir</name>
3
<value>~/tmp/hive</value>
4
<description>Local scratch space for Hive jobs</description>
5
</property>
6
​
Copied!
Then in the OS, log in as user that owns HIVE
1
cd ~
2
mkdir tmp
3
cd tmp
4
mkdir hive
5
cd ~
6
chmod -R 777 tmp/hive
Copied!
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
1
sudo cp /Library/ODBC/odbcinst.ini /Library/ODBC/odbcinst.ini.org
2
sudo vi /Library/ODBC/odbcinst.ini
Copied!
1
[ODBC Drivers]
2
PostgreSQL Unicode = Installed
3
Simba Spark ODBC Driver = Installed
4
​
5
[PostgreSQL Unicode]
6
Description = PostgreSQL ODBC driver
7
Driver = /usr/local/lib/psqlodbcw.so
8
​
9
[Simba Spark ODBC Driver]
10
Driver = /Library/simba/spark/lib/libsparkodbc_sbu.dylib
11
​
Copied!
delete line 3, line 9 and line 10, it should be like below
1
[ODBC Drivers]
2
PostgreSQL Unicode = Installed
3
​
4
[PostgreSQL Unicode]
5
Description = PostgreSQL ODBC driver
6
Driver = /usr/local/lib/psqlodbcw.so
7
​
Copied!
save and exit vi
Next, move away /Library/simba folder
1
mv /Libray/simba /Library/simba.org
Copied!
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
​
Last modified 1yr ago
Copy link