https://community.cloudera.com/t5/Archives-of-Support-Questions/Persistent-Hive-variables-possible/m-p/160493#M29132 <A rel="user" href="https://community.cloudera.com/users/1486/smanjee.html" nodeid="1486">@Sunile Manjee</A><P>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. </P><P>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).</P> Sat, 21 May 2016 17:34:00 GMT jyadav 2016-05-21T17:34:00Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Persistent-Hive-variables-possible/m-p/160492#M29131 <P>I want to set a hive variable which will be used by all hive sessions. Any ideas how I can do this?</P> Sat, 21 May 2016 09:53:37 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Persistent-Hive-variables-possible/m-p/160492#M29131 sunile_manjee 2016-05-21T09:53:37Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Persistent-Hive-variables-possible/m-p/160493#M29132 <A rel="user" href="https://community.cloudera.com/users/1486/smanjee.html" nodeid="1486">@Sunile Manjee</A><P>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. </P><P>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).</P> Sat, 21 May 2016 17:34:00 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Persistent-Hive-variables-possible/m-p/160493#M29132 jyadav 2016-05-21T17:34:00Z