Re: Hive Problem

Hi, please check also the permissions in hdfs for hive warehouse-dirs. best, Alex On Tue, Nov 29, 2011 at 12:44 AM, arv...@cloudera.com wrote: > Hi Jurgen, > > What version of Hive and Sqoop are you using? Also, please look under > /tmp/${USER}/hive.log file which will have more detailed infor

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

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 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 and DROP commands

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

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? If

Re: How to trigger an query

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 wrote: > Hi, > > I was wondering if there is an option to trigger queries. I use cloudera > CDH3. >

Re: Hive Problem

Hi Jurgen, What version of Hive and Sqoop are you using? Also, please look under /tmp/${USER}/hive.log file which will have more detailed information on what may be going wrong. Thanks, Arvind On Mon, Nov 28, 2011 at 3:17 PM, Jurgen Van Gael wrote: > Hi, > I am running the Cloudera CDH3 Hive di

Hive Problem

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: Hive console startup issue

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 wi

Re: ClassNotFoundException every time we run any hive query

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