RE: Failures with DELETEME tables

2011-07-11 Thread Steven Wong
Bugs in DataNucleus and MySQL Connector! Any Hive user will potentially hit the problem. My SELECT query got incorrect results because JDOQLQuery.compileQueryFull swallowed the fatal datastore exception when it called RDBMSQueryUtils.getStatementForCandidates. This is a bug in RDBMSQueryUtils.

Re: Hue not starting jobsubd and besswax server on RHEL 5 64 bit

2011-07-11 Thread Vinithra Varadharajan
bcc: user@hive.apache.org +hue-u...@cloudera.org Sanjeev, Redirecting this to the hue-user mailing list as this is completely and only related to Hue. It seems like the beeswax and jobsubd packages did not get installed. Could you provide the output of: ./hue/tools/app_reg/app_reg.py --list Tha

Top N by Group Query

2011-07-11 Thread Vipul Patel
Hi, I'm trying to run a query that will return the top 50 results within each group. The table contains millions of records and there are over 100 unique values in the field I wish to group by -- consequently using UNION to string together subqueries won't be very efficient. Any suggestions would

Hue not starting jobsubd and besswax server on RHEL 5 64 bit

2011-07-11 Thread sanjeev sagar
Hello All, I'm using CDH 3 and Hue 1.2 on RHEL5 64 bit with mysql db based metastore. I'm running into a issue where Hue is showing any app in the browser. After checking the log files, it looks like it's not even starting jobsubd and besswax server at all. From the log file: [11/Jul/201

Hive authorization error

2011-07-11 Thread Juwon Lee
Hello, I am running into an exception when executing a simple query with authorization enabled. I have tried different authorization settings as well as metastore configuration, but without success. Also, the communication itself between Hive client and metastore DB (postgres) seems fine. Any