Support Questions
Find answers, ask questions, and share your expertise

pyodbc connection using Hortonworks Hive ODBC Driver

Highlighted

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?