I'm looking to modify the Hive Warehouse location in HDFS to store the managed
tables in a location where all users have write access. I'd also like the
ability to support multiple Hive instances on the cluster, so we are looking at
an HDFS path like /data/hive/<hostname>/warehouse.
Is there a way to programmatically set the <hostname> value? I see that it's
available in Hive as ${env:HOSTNAME}, but I get errors when I try to use that
in the hive.metastore.warehouse.dir path in hive-site.xml.
Thanks
Matt Tucker