Re: Error while dropping the table.

2010-11-28 Thread Rekha Joshi
Hi Rahul, On a quick look, it feels like your javax.jdo.Query is not able to return the list of MPartition with the passed values of default(db), erer(table). You will need to write a small testcase and check if the below snippets work on your setup. Query query = pm.newQuery(MPartition.cl

Error while dropping the table.

2010-11-28 Thread Rahul Singh
Hi , We are using Postgres as Hive Meta Store. When we try to drop a table , It hangs. Below is the small dump Can any one help me in this regard 10/11/29 06:02:07 DEBUG metastore.ObjectStore: Overriding datanucleus.cache.level2.type value null from jpox.properties with SOFT 10/11/29 06:02:07 DE

hive not stable,weird exception

2010-11-28 Thread shangan
I use hive client through php, it always works quite well, but recently it sometimes throw a weird exception : [28-Nov-2010 05:01:04] PHP Fatal error: Uncaught exception 'HiveServerException' with message 'Query returned non-zero code: 9, cause: FAILED: Execution Error, return code 1 from org

tablesample with a nested query / table alias

2010-11-28 Thread Leo Alekseyev
The following query doesn't run with the error: FAILED: Parse Error: line 3:0 mismatched input 'tablesample' expecting EOF Am I doing something obviously wrong, or can you just not use tablesample like this? select * from (select user_agent, cookie, geoloc, flags from alogs_master where ds='2010-

ERROR metadata.Hive: NoSuchObjectException

2010-11-28 Thread Ray Duong
Hi, We just pushed Hive .7 and using Mysql has the HiveMetaStore backend into our ad-hoc cluster. There are large number of queries that are submitted in parallel against the Hive backend . Some of the Hive jobs seems to fail when the definition of the tables are not found. When we re-run the s