Connection To Apache Drill Failed With Initial SQL

KNOWLEDGE BASE

Connection To Apache Drill Failed With Initial SQL

Published: 17 Apr 2020
Last Modified Date: 08 Jul 2022

Issue

When connecting to Apache Drill with Initial SQL "ALTER SESSION SET `planner.enable_hashjoin` = false", following error occurs.

An error occurred while communicating with Apache Drill
Bad Connection: Tableau could not connect to the data source.
Error Code: 37CE01A3
Unable to connect to the Apache Drill server "xxx". Check that the server is running and that you have access privileges to the requested database.

Environment

Tableau Desktop
Apache Drill 1.9 or later

Resolution

As a workaround use the attached .tdc file to connect to Apache Drill:

1. Place the attached "drill.tdc" file to "My Tableau Repository\Datasources".
2. Re-launch Tableau Desktop and connect to the data source.

Cause

Apache Drill (version 1.9 or later) does not support ALTER SESSION by SQLPrepare query that is used as part of the prepared statements to run the queries by Tableau.