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!