Hi, Can you please confirm that you have followed the steps that are documented here,
Installing the Driver on Mac OS X https://drill.apache.org/docs/installing-the-driver-on-mac-os-x/ Configuring ODBC on Mac OS X https://drill.apache.org/docs/configuring-odbc-on-mac-os-x/ Thanks, Khurram On Thu, May 23, 2019 at 10:46 AM Nicolas Seyvet <[email protected]> wrote: > Hi, > > I am new to drill and running into a problem with a basic setup. > > From https://github.com/HariSekhon/Dockerfiles/tree/master/apache-drill, > I run a docker-compose ($ docker-compose up) of drill, and open up port > 8047 for incoming drill requests. The UI at http://0.0.0.0:8047 works. > > On OSX, I have installed the ODBC driver > http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v1.3.22.1055/ > > Then updated my odbc.ini file under ~/Library/ODBC with my port and host > such as: > -------------------- > [ODBC] > Trace=yes > > [ODBC Data Sources] > MapR Drill=MapR Drill ODBC Driver > > [MapR Drill] > > # Description: DSN Description. > # This key is not necessary and is only to give a description of the data > source. > Description=MapR Drill ODBC Driver DSN > > Driver=/Library/mapr/drill/lib/libdrillodbc_sbu.dylib > ConnectionType=Direct > HOST=0.0.0.0 > PORT=18047 > AuthenticationType=No Authentication > DelegationUID= > #KrbServiceHost= > #KrbServiceName= > > AdvancedProperties=CastAnyToVarchar=true;HandshakeTimeout=10;QueryTimeout=180;TimestampTZDisplayTimezone=utc; > ExcludedSchemas=sys,INFORMATION_SCHEMA;NumberOfPrefetchBuffers=5; > Catalog=DRILL > Schema= > --------- > > Then using the DrillExplorer when I try to connect to my DSN, I keep > getting the following error: > > Connection failed. > [MapR][Drill] (20) Failure occurred while trying to connect to local= > 0.0.0.0:8047. (Details: [30004]Connection failed with error: Cannot > decode handshake.) > > Any ideas? > > Thanks > -- > Regards, > Nicolas Seyvet >
