How to connect Tableau 10.4 to Vora 2.0

[former_member255270]

Please note that Vora is not yet certified by Tableau and that the instructions below are not officially supported by SAP.

Pre-requisites:

• The Kubernetes cluster has already been deployed and configured


• Vora 2.0 is ready to be installed or has already been deployed


• You are using Tableau 10.4 or greater

 

Assuming you've downloaded and extracted the SAP Vora installer, go to the root directory of the Vora installer e.g. /SAPVora-DistributedRuntime/

Modify line 16 of the file:

/<root_install_dir>/deployments/helm/vora-thriftserver/values.yaml 

11 thriftserver:

12     docker:

13         image: vora/thriftserver

14         imageTag: 2.0.14

15     service:

16         expose: true

 

Add the following three lines of code after line 131 in file

/<root_install_dir/deployment/helm/vora-thriftserver/templates/deployment.yaml

131 "--hiveconf", "hive.server2.transport.mode={{$mode}}",

132 {{- if eq $mode "http" }}

133 "--conf", "spark.sql.dialect=hiveql",

134 {{- end }} 

 

If you've already installed Vora 2.0 then you can simply update the deployment with the new settings using below command. Only Vora Tools and the Thriftserver will experience a momentary downtime during this execution:

/<root_install_dir>/install.sh -ui --limit-service=vora-thriftserver

 

If you have not yet installed Vora 2.0 then proceed to install as you would normally. Refer to the SAP Vora Install guide for details.

 

Regardless of whether you updated your existing Vora installation or installed from scratch you should verify that you have now two Thriftserver services running, one in binary mode and another in http mode which has an exposed service port. This exposed port is dynamically assigned and changes with each deployment.

kubectl get svc --all-namespaces | grep vora-thriftserver

 

Proceed to launch Tableau 10.4 on your workstation. Look under the section "Connection" and choose "Spark SQL"


 

Hostname:                    Kubernetes master host
Port:                               vora-thriftserver-http exposed port
Authentication mode:  HTTP
Username/password:  lumira/lumira
HTTP path:                    /cliservice



 

When selecting a schema choose default and submit the entry by clicking on the blue cross icon

 

To search and view a list of available tables in Tableau click on the magnifying glass icon



 

Note: In order for Vora tables to be visible in Tableau, they must first be registered in the Vora HTTP Thriftserver by issuing a REGISTER TABLE command from a tool like beeline. This has to be done each time the Thriftserver is restarted.

To connect to the Vora HTTP thriftserver using beeline use the following beeline command:

!connect jdbc:hive://<kubernetesMaster_host>:<exposedPort>/default;transportMode=http;httpPath=/cliservice; lumira lumira

For details on how to use the REGISTER TABLE commands, please refer to the SAP Vora Developer Guide.