Is there a way to load balance hana servers in a Vora-Hana table that was made with
'USING com.sap.spark.hana' ?
In the OPTIONS section 'host' is specified, is it possible to have this point to multiple HANA hosts? such as "host" "hana1,hana2,hana3".
for example a 3+1 cluster, 3 active 1 standby.
Workload distribution of queries can be handled via HANA's statement routing mechanism (see SAP Note 2079372 - SAP HANA - Statement Routing; parameter in indexserver.ini -> [distribution] -> client_distribution_mode = [ off | connection | statement | all ]). The HANA datasource uses the HANA jdbc driver to connect to HANA - the current client default setting is distribution=ALL. By changing the parameter on the HANA side either a round-robin distribution or statement routing should be possible.