Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB