We need your support on issues we are facing currently.
We are trying to connect to Impala using Cloudera ODBC driver with HA Proxy and Elastic Load Balancer. it is failing with below error.
[Cloudera][DriverSupport] (1110) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct and confirm if SSL should be enabled for the connection.
Cluster Details -
CDH Version 6.1
Clouder ODBC Driver 2.6
Impala daemons run on a machine dn1,dn2, master2
ELB points to only master2 daemon for now.
HAProxy points to only master2 daemon for now.
Cluster is kerberos enabled.
Let us assume
ELB Name - elb-test-odbc.com
HAProxy name - haproxy-name.com
Below combination works -
we put ELB Name in HOST and impala daemon name in HOST FQDN(under kerberos) name it works.
Below combination DOES NOT works -
we put ELB Name in HOST and haproxy-name.com in HOST FQDN(under kerberos) name it does not work.
We actaully want to achieve the resilency so that we are not depenedent on single impala daemon.
Can someone please let us know how can we make it happen. any help on this would be greatly appreciated.