Skip to content

Unable to connect secure drill version 1.15 using pydrill #39

@goodjoefong

Description

@goodjoefong

Trying to connect drill 1.15 using pydrill but failed. Used sqlline and I am able to connect by using MAPRSAL or PLAIN authorization. Also I can use drill explorer or tableau to connect to drill.

OS : CentOS 7

<< test.py >>
from pydrill.client import PyDrill
import sys
import os
header = {"Accept": "application/json"}
drill = PyDrill(host='127.0.0.1', port=8047, auth='mapr:XXXXXXXX$!')

< Error >>
select CONCAT(Address1 ,Address2) as Address from dfs.uat_kfe.Address_LMS where Address1 is not null
Traceback (most recent call last):
File "/home/mapr/dataload_scripts/megaloan_scripts/address/test.py", line 12, in
drill = PyDrill(host='127.0.0.1', port=8047, auth='mapr:XXXXXXXX$!')
File "/usr/lib/python2.7/site-packages/pydrill/client/init.py", line 21, in init
self.transport = trasport_class(host, port, connection_class=connection_class, auth=auth, **kwargs)
File "/usr/lib/python2.7/site-packages/pydrill/transport.py", line 21, in init
self.connection = connection_class(host, port, **kwargs)
File "/usr/lib/python2.7/site-packages/pydrill/connection/requests_conn.py", line 65, in init
headers={}
File "/usr/lib/python2.7/site-packages/pydrill/connection/requests_conn.py", line 100, in perform_request
raise ConnectionError('N/A', str(e), e)
pydrill.exceptions.ConnectionError: ConnectionError(('Connection aborted.', BadStatusLine("''",))) caused by: ConnectionError(('Connection aborted.', BadStatusLine("''",)))

<< SQLline screen >>
/opt/mapr/drill/drill-1.15.0/bin/sqlline
Apache Drill 1.15.0.0-mapr
"Your Drill is the Drill that will pierce the heavens."
sqlline> !connect jdbc:drill:drillbit=localhost:31010;auth=MAPRSASL mapr XXXXXXXX$!
0: jdbc:drill:drillbit=localhost:31010> !close
Closing: org.apache.drill.jdbc.impl.DrillConnectionImpl
sqlline> !connect jdbc:drill:drillbit=localhost:31010;auth=PLAIN mapr XXXXXXXX$!
0: jdbc:drill:drillbit=localhost:31010> !quit
Closing: org.apache.drill.jdbc.impl.DrillConnectionImpl

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions