https://community.cloudera.com/t5/Support-Questions/JDBC-Connection-String-with-multiple-worker-node-Impala/m-p/311750#M224812 <P>Hello&nbsp;<a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/85639">@bb9900m</a>&nbsp;</P><P>&nbsp;</P><P>The use case in your scenario is make use of Load balancer. You can make user of external Load Balancer and balance the impala coordinators behind the Load balancer.</P><P>&nbsp;</P><P>This way, you will have the Load balancer Ip exposed to the client(Virtual IP) which further will balance the load based upon the load balancing mechanism set.</P><P>&nbsp;</P><P>Attaching the link and sample configuration for your reference.</P><P>&nbsp;</P><P><A href="https://docs.cloudera.com/runtime/7.2.6/impala-manage/topics/impala-load-balancer-configure.html" target="_blank">https://docs.cloudera.com/runtime/7.2.6/impala-manage/topics/impala-load-balancer-configure.html</A></P><P>&nbsp;</P><P>When it comes to SSL, make sure you have the LB hostname added as SAN names on all the impala certificates.</P><P>&nbsp;</P><P>Let me know if you have issues in any of the points above.</P> Thu, 18 Feb 2021 18:34:21 GMT tusharkathpal 2021-02-18T18:34:21Z