You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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
The text was updated successfully, but these errors were encountered:
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 whereAddress1
is not nullTraceback (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
The text was updated successfully, but these errors were encountered: