Connect Tableau to Spark SQL running in VM with VirtualBox with NAT
This section is specific only to Spark running on Virtualbox VM which network adapter is set to NAT, with IP address to be 10.0.2.15. If your Spark SQL does not run on the VirtualBox VM or if the network adapter of the VirtualBox VM is not set to NAT, then this section does not apply.
First, Hadoop, HIVE, Spark must be up and running:
1
(spark) [[email protected] tmp]$ jps
2
21520 Jps
3
3110 SecondaryNameNode
4
3447 NodeManager
5
3847 RunJar
6
4120 Worker
7
3290 ResourceManager
8
4010 Master
9
12490 SparkSubmit
10
2684 NameNode
11
2861 DataNode
12
4893 SparkSubmit
13
​
Copied!
Next Spark thrift server needs to be up and running, if not start it by:
1
$SPARK_HOME/sbin/start-thriftserver.sh
Copied!
that run the process such as below
1
hadoop 4893 1 1 17:09 pts/0 00:01:33 /usr/java/default/bin/java -cp /opt/spark/conf/:/opt/spark/jars/* -Xmx1g org.apache.spark.deploy.SparkSubmit --class org.apache.spark.sql.hive.thriftserver.HiveThriftServer2 --name Thrift JDBC/ODBC Server spark-internal
2
​
Copied!
Then you need to with telnet to ensure port 10000 is being listened to:
1
(spark) [[email protected] tmp]$ telnet master 10000
2
Trying fe80::e85c:6b26:5c3d:b72e%enp0s3...
3
Connected to master.
4
Escape character is '^]'.
5
​
6
​
Copied!
You need to make sure you have setup port forward in VirtualBox network settings, in this example, add a port forwarding rule to forward TCP packets from port 36 of host machine to port 10000 of guest machine
Also, on your windows command window, test with telnet with host port 36 that is set to forward to port 10000 of VirtualBox guest machine
1
telnet localhost 36
2
​
Copied!
Then specify port 36 in Tableau login window
You should be able to log in from Tableau
Last modified 1yr ago
Copy link