Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Hive Queries not responding


Copy link to this message
-
RE: Hive Queries not responding
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