Hi , I am getting this error when I do a show schemas; 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. NestedThrowables: 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. FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
I am running hadoop-0.20-0.20.2+923.97-1 hadoop-zookeeper-3.3.3+12.12-1 hadoop-0.20-native-0.20.2+923.97-1 hadoop-hbase-0.90.3+15.3-1 hadoop-0.20-sbin-0.20.2+923.97-1 hadoop-hive-0.7.1+42.9-2 hadoop-pig-0.8.1+28.2-1 hadoop-0.20-sbin-0.20.2+923.97-1 hadoop-0.20-native-0.20.2+923.97-1 And I configured everything using cloudera-scm-server-express-3.6.1.1-1 I can acces hive just fine via the HUE desktop but when I try to access hive through the cli I get these problems. Please Advise, Thanks -Eric