Using Drill ODBC Driver

Discussion created by riteshlath on Jun 27, 2018



We are exploring to query mixed schema JSON loaded on MapR platform through BI tools (PowerBI). In this case we are configuring a Drill ODBC driver to connect to the MapR cluster. However, while launching the Drill Browser we are continuously facing an error  as mentioned below:



ERROR [HY000] [MapR][Drill] (1070) Drill fails to execute the query with error [30020]Communication error. A request to send or receive data was disallowed because the socket had already been shut down in that direction with a previous shutdown call



In some attempts the Drill Browser is lau nched without any issues but most of the time we experience the above error message. I have even tried changing the QueryTimeOut from 180 sec to over 900 sec and in some cases even removed it from the configuration. Also, the ODBC driver was configured to user Zookeeper as well as DrillBits.


Please suggest how this issue can be resolved.


MapR Version:
Drill Version: 1.10.0

Drill ODBC Version: 1.2 (64 Bit)