Connection To Apache Drill Failed With Initial SQL

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


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.


  • Tableau Desktop
  • Apache Drill 1.9 or later


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.


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.
Did this article resolve the issue?