Hi, I ran in to a similar problem on trunk with mysql as a metastore. For now I try to workaround it by setting this: <property> <name>hive.metastore.ds.retry.attempts</name> <value>3</value> <description>The number of times to retry a metastore call if there were a connection error</description> </property>
You can create a file called "hive-site.xml" in the same directory as the hive-default.xml file start with: <?xml version="1.0"?> <?xml-stylesheet type="text/xsl" href="configuration.xsl"?> <configuration> add the/any properties here en then end with: </configuration> In my case I have a hunch it's related to mysql timing out idle connections after 8h on default. I've been trying to set parameters like "org.jpox.connectionPool.minEvictableIdleTimeMillis" but I'm not sure it's picking up settings like that. Bennie. ________________________________ From: Shuja Rehman [mailto:[email protected]] Sent: Tuesday, June 08, 2010 9:49 PM To: [email protected] Subject: Re: Hive Queries not responding Hi I have checked the config folder. I did not have any hive-site.xml but i found hive-default.xml file. I have attach this file. Kindly let me know if i need to change anything is this file. Thanks On Mon, Jun 7, 2010 at 7:52 PM, Ning Zhang <[email protected]<mailto:[email protected]>> wrote: This is caused by the last error message indcated: 2010-06-06 23:17:24,919 ERROR metastore.HiveMetaStore (HiveMetaStore.java:executeWithRetry(243)) - JDO datastore error. Retrying metastore command after 1000 ms (attempt 1 of 1) Please check your metastore connection (should be in hive-site.xml or hive-default.xml). On Jun 7, 2010, at 1:57 AM, Shuja Rehman wrote: Hi Any update on this problem? On Sun, Jun 6, 2010 at 11:19 PM, Shuja Rehman <[email protected]<mailto:[email protected]>> wrote: Hi When i try to run hive queries like show tables, then the query did not respond, i have checked the hive log file in tmp/root/hive.log. it contains the following information. 2010-06-06 23:17:21,612 ERROR DataNucleus.Plugin (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires "org.eclipse.core.resources" but it cannot be resolved. 2010-06-06 23:17:21,612 ERROR DataNucleus.Plugin (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires "org.eclipse.core.resources" but it cannot be resolved. 2010-06-06 23:17:21,616 ERROR DataNucleus.Plugin (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires "org.eclipse.core.runtime" but it cannot be resolved. 2010-06-06 23:17:21,616 ERROR DataNucleus.Plugin (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires "org.eclipse.core.runtime" but it cannot be resolved. 2010-06-06 23:17:21,617 ERROR DataNucleus.Plugin (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires "org.eclipse.text" but it cannot be resolved. 2010-06-06 23:17:21,617 ERROR DataNucleus.Plugin (Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires "org.eclipse.text" but it cannot be resolved. 2010-06-06 23:17:24,919 ERROR metastore.HiveMetaStore (HiveMetaStore.java:executeWithRetry(243)) - JDO datastore error. Retrying metastore command after 1000 ms (attempt 1 of 1) Kindly let me know what could be the solution. Thanks -- Regards Shuja-ur-Rehman Baig _________________________________ MS CS - School of Science and Engineering Lahore University of Management Sciences (LUMS) Sector U, DHA, Lahore, 54792, Pakistan Cell: +92 3214207445 -- Regards Shuja-ur-Rehman Baig _________________________________ MS CS - School of Science and Engineering Lahore University of Management Sciences (LUMS) Sector U, DHA, Lahore, 54792, Pakistan Cell: +92 3214207445 -- Regards Shuja-ur-Rehman Baig _________________________________ MS CS - School of Science and Engineering Lahore University of Management Sciences (LUMS) Sector U, DHA, Lahore, 54792, Pakistan Cell: +92 3214207445
