You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Shuja Rehman <sh...@gmail.com> on 2010/06/06 23:19:24 UTC
Hive Queries not responding
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
RE: Hive Queries not responding
Posted by Bennie Schut <bs...@ebuddy.com>.
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:shujamughal@gmail.com]
Sent: Tuesday, June 08, 2010 9:49 PM
To: hive-user@hadoop.apache.org
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 <nz...@facebook.com>> 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 <sh...@gmail.com>> 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
Re: Hive Queries not responding
Posted by Shuja Rehman <sh...@gmail.com>.
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 <nz...@facebook.com> 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 <sh...@gmail.com>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
Re: Hive Queries not responding
Posted by Ning Zhang <nz...@facebook.com>.
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 <sh...@gmail.com>> 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
Re: Hive Queries not responding
Posted by Shuja Rehman <sh...@gmail.com>.
Hi
Any update on this problem?
On Sun, Jun 6, 2010 at 11:19 PM, Shuja Rehman <sh...@gmail.com> 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