I got some clue here, seems like the derby database is either read only or the user that i am using is read only. Got to know this from the hive query logs.
$ tail -f /srv/logs/hive/query_logs/<myuser>/hive.log 2014-09-11 15:21:30,664 WARN [main]: common.LogUtils (LogUtils.java:logConfigLocation(145)) - hive-site.xml not found on CLASSPATH 2014-09-11 15:21:30,796 INFO [main]: SessionState (SessionState.java:printInfo(543)) - Logging initialized using configuration in jar:file:/usr/lib/hive/lib/hive-common-0.13.1.jar!/hive-log4j.properties 2014-09-11 15:21:31,014 INFO [main]: metastore.HiveMetaStore (HiveMetaStore.java:newRawStore(496)) - 0: Opening raw store with implemenation class:org.apache.hadoop.hive.metastore.ObjectStore 2014-09-11 15:21:31,050 INFO [main]: metastore.ObjectStore (ObjectStore.java:initialize(246)) - ObjectStore, initialize called 2014-09-11 15:21:32,216 ERROR [BoneCP-pool-watch-thread]: bonecp.PoolWatchThread (PoolWatchThread.java:fillConnections(118)) - Error in trying to obtain a connection. Retrying in 7000ms java.sql.SQLException: *A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection.* at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.setReadOnly(Unknown Source) at com.jolbox.bonecp.ConnectionHandle.setReadOnly(ConnectionHandle.java:1324) at com.jolbox.bonecp.ConnectionHandle.<init>(ConnectionHandle.java:262) at com.jolbox.bonecp.PoolWatchThread.fillConnections(PoolWatchThread.java:115) at com.jolbox.bonecp.PoolWatchThread.run(PoolWatchThread.java:82) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) Caused by: java.sql.SQLException: A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) ... 13 more Caused by: ERROR 25505: A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.sql.conn.GenericAuthorizer.setReadOnlyConnection(Unknown Source) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.setReadOnly(Unknown Source) ... 8 more On Wed, Sep 10, 2014 at 6:17 PM, pratik khadloya <[email protected]> wrote: > Hello, > > My hive table import is getting stuck after the line which prints the > derby database classpath. > Am not sure what is missing here. Can anyone please give me some pointers. > > 4/09/10 21:11:52 INFO hive.HiveImport: Logging initialized using > configuration in > jar:file:/usr/lib/hive/lib/hive-common-0.13.1.jar!/hive-log4j.properties > 14/09/10 21:11:53 INFO hive.HiveImport: Wed Sep 10 21:11:53 EDT 2014 > Thread[main,5,main] java.io.FileNotFoundException: derby.log (Permission > denied) > 14/09/10 21:11:53 INFO hive.HiveImport: > ---------------------------------------------------------------- > 14/09/10 21:11:53 INFO hive.HiveImport: Wed Sep 10 21:11:53 EDT 2014: > 14/09/10 21:11:53 INFO hive.HiveImport: Booting Derby (version The Apache > Software Foundation - Apache Derby - 10.10.1.1 - (1458268)) instance > a816c00e-0148-6244-425a-000001726a08 > 14/09/10 21:11:53 INFO hive.HiveImport: on database directory > /home/pkhadloya/sqoop-2e1e094/metastore_db in READ ONLY mode with class > loader sun.misc.Launcher$AppClassLoader@77cde100. > 14/09/10 21:11:53 INFO hive.HiveImport: Loaded from > file:/usr/lib/hive/lib/derby-10.10.1.1.jar. > 14/09/10 21:11:53 INFO hive.HiveImport: java.vendor=Sun Microsystems Inc. > 14/09/10 21:11:53 INFO hive.HiveImport: java.runtime.version=1.6.0_16-b01 > 14/09/10 21:11:53 INFO hive.HiveImport: > user.dir=/home/pkhadloya/sqoop-2e1e094 > 14/09/10 21:11:53 INFO hive.HiveImport: os.name=Linux > 14/09/10 21:11:53 INFO hive.HiveImport: os.arch=amd64 > 14/09/10 21:11:53 INFO hive.HiveImport: > os.version=2.6.32-279.22.1.el6.x86_64 > 14/09/10 21:11:53 INFO hive.HiveImport: derby.system.home=null > 14/09/10 21:11:54 INFO hive.HiveImport: Database Class Loader started - > derby.database.classpath='' > > > Thanks, > Pratik >
