Re: ClassNotFoundException every time we run any hive query

2011-11-28 Thread Ghousia
Hi Chinna, I have the derby.jar in the lib folder, hive runs fine and we are able to execute the queries. Even then this error shows up in the logs, if the query execution is successful. If we closely see this db is for stats not for the actual metastore. -Ghousia. On Mon, Nov 28, 2011 at 11:49

RE: Hive console startup issue

2011-11-28 Thread Chinna Rao Lalam
Hi, java.lang.NoClassDefFoundError: jline/ArgumentCompletor$ArgumentDelimiter this class presents in the jline.jar. Check whether this jar is present in the distribution or not in {HIVE_HOME}/lib. If it presents which version it is? For ex: In trunk distribution jline-0.9.94.jar will

Hive Problem

2011-11-28 Thread Jurgen Van Gael
Hi, I am running the Cloudera CDH3 Hive distribution in pseudo-distributed mode on my local Mac OS Lion laptop. Hive generally works fine except when I use it together with Sqoop. A command like sqoop import --connect jdbc:mysql://localhost/db --username root --password foobar --table sometable

Re: How to trigger an query

2011-11-28 Thread Aniket Mokashi
You can take a look at -- https://issues.apache.org/jira/browse/HCATALOG-3 and https://issues.apache.org/jira/browse/HIVE-2038 Thanks, Aniket On Sun, Nov 27, 2011 at 11:41 PM, Ibrahim Acet ibrahim.a...@widas.dewrote: Hi, I was wondering if there is an option to trigger queries. I use

Is there a reason for the Hive remote metastore to execute commands as different users?

2011-11-28 Thread Alex Holmes
Hi, I'm running Hive 0.7.1 with a remote metastore (Derby) on Hadoop 0.20.2. Is there a reason that CREATE and DROP commands when translated into HDFS operations are run as the remote Hive metastore user, but a LOAD is translated into HDFS operations that are executed as the Hive client user?

Re: Is there a reason for the Hive remote metastore to execute commands as different users?

2011-11-28 Thread Alexander C.H. Lorenz
Derby depends on a local filestore, for more flexibility and security I suggest mysql as a metastore. - Alex On Tue, Nov 29, 2011 at 3:06 AM, Alex Holmes grep.a...@gmail.com wrote: Hi, I'm running Hive 0.7.1 with a remote metastore (Derby) on Hadoop 0.20.2. Is there a reason that CREATE