Rather than have passwords (ie mysql, redshift or others) in plaintext could use a jceks to store the password like in below example: https://mapr.com/blog/5-steps-to-remove-hive-metastore-password/