-
Notifications
You must be signed in to change notification settings - Fork 11
Description
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