title: How to use hive with other user
body: <p>I installed Hadoop and Hive on 3 cluster.
  Normally I can use hive and Hadoop but when i log in with other user, I can't use Hive.
  The error is:</p>
  <blockquote>
  <p>hive&gt; show tables;</p>
  <p>FAILED: Error in metadata: javax.jdo.JDOFatalDataStoreException: Cannot get a connection, pool error Could not create a validated object, cause: A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection.</p>
  <p>NestedThrowables:</p>
  <p>org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Could not create a validated object, cause: A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection.</p>
  <p>FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask</p>
  </blockquote>
  <p>I log in with other user,and set permission chmod 777 for the folder which i installed hadoop and hive,i can use hive. But when i log on the other user,it's error. I mean,i have to set permission when i log on to use hive on hadoop. How can use hive on hadoop with one time configure permission ????</p>