Persistent Hive variables possible?

[#1]

I want to set a hive variable which will be used by all hive sessions. Any ideas how I can do this?

[#2 · Accepted solution]

@Sunile Manjee

You can put all the variable inside .hiverc file which will automatically call while running hive shell. And yes you have to replicate this file to all user home directory or in the directory from where they run hive shell.

Moreover I don't think we can access the modified value of a variable from one hive shell session to another( I didn't tested).