I am having difficulty connecting to Impala. We have been succesful in the past connecting to Impala from local desktop but now need to make this connection on a server that has ODBC set up.
Everytime I try to make the connection I get the error that Data Source Name not found and no driver specified...I have confirmed that the DSN is correct and that the Clouder ODBC Driver for Impala is installed on the server
Data Source Name: ECM_SDM
Mechanism: SASL User Name and Password (SSL)
Host: "my confirmed host name"
Transport Buffer SIze:1000
Connection String: - I have tried different variations of this but have had no luck
odbc:DSN=ECM_SDM;Driver=Cloudera ODBC Driver for Impala;Host= "My Host Name";UID="My UID";PWD="My Password";Port=21050;