关于Hive使用或建表出错read-only问题的解决:
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
进入:
/var/lib/hive/metastore/metastore_db
将里面lck的几个文件 rm -rf 掉
再运行就一切OK了。
后来发现Hbase运行时hbase shell命令,超时被kill也是因为这个原因。