Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

pyodbc connection using Hortonworks Hive ODBC Driver

pyodbc connection using Hortonworks Hive ODBC Driver

New Contributor
0

I'm trying to make a connection using pyodbc to the Hortonworks Hive ODBC Driver, but am encountering the following error

pyodbc.connect(driver='{Hortonworks Hive ODBC Driver}',
               host='xxx:yyy, xxx:yyy, xxx:yyy',
               port=port,
               autocommit=True)

This is the error that I'm getting

pyodbc.OperationalError: ('08001', '[08001] [Hortonworks][ODBC] (10380) Unable to establish a connection with data source. Missing settings: {[Host]} (10380) (SQLDriverConnect)')

The host is in the zookeeper format.

Many thanks in advance for your assistance!

Don't have an account?
Coming from Hortonworks? Activate your account here