How to set up CNAME for MySQL connection

[Sanchay Javeria <ja...@illinois.edu>]

Hi folks,

To mitigate downtime during fail overs of the SQL hosts, I was wondering if
I could put a CNAME for the MySQL host machine in `hive_site.xml`. Such
that I can later change where the CNAME points to without having to change
the config file again. Would someone be able to help on how this is done?
Specifically, how to setup a CNAME and let the Hive Metastore know about
it?

Thank you!