Re: Permissions preventing me from inserting data into table I have just created

2012-11-26 Thread yaboulna
I solved the problem by using a fully qualified path for hive.exec.scratchdir and then the umask trick worked. It turns out that hive was creating a different directory (on hdfs) than the one mapreduce was trying to write into, and that's why the umask didn't work. This remains a nasty work

JDOFatalInternalException: Error creating transactional connection factory

2012-11-26 Thread Barak Yaish
Hi, I’ve 2 nodes cluster of hadoop 1.0.4, and I’m trying making hive 0.90.0 works with it, so far no good. I was following the instructions listed here https://cwiki.apache.org/confluence/display/Hive/GettingStarted, but when trying to run any command in the shell, I’m getting: FAILED: Error

Re: Custom hive-site.xml is ignored, how to find out why

2012-11-26 Thread Stephen Boesch
Hi, The problem may not have to do with hive-site.xml. When I run hive client by itself it connects successfully to mysql and creates / reads metadataa. The problem comes in when i run the metastore/thrift servers via: hive --service metastore hive --service hiveserver. As soon as i do th

Re: Custom hive-site.xml is ignored, how to find out why

2012-11-26 Thread Shreepadma Venugopalan
Hi Stephen, If you wish to setup a mysql metastore, you need to have the following in your hive-site.xml, javax.jdo.option.ConnectionURL jdbc:mysql://MYHOST/metastore javax.jdo.option.ConnectionDriverName com.mysql.jdbc.Driver javax.jdo.option.ConnectionUserName hiveuser j

RE: Setting auxpath in Hue/Beeswax

2012-11-26 Thread Connell, Chuck
I believe there are some free Cloudera discussion boards/lists. Standard Cloudera support is a paid service. Chuck Connell Nuance R&D Data Team Burlington, MA From: Sadananda Hegde [mailto:saduhe...@gmail.com] Sent: Monday, November 26, 2012 2:42 PM To: user@hive.apache.org Subject: Re: Setting

Re: Setting auxpath in Hue/Beeswax

2012-11-26 Thread Sadananda Hegde
Thanks, Edward, I will contact Cloudera support then. Sadu On Mon, Nov 26, 2012 at 1:34 PM, Edward Capriolo wrote: > You are looking for support in the wrong place. Beeswacks is not a part of > hive thus only the cloudera folks will support it. > > > On Mon, Nov 26, 2012 at 1:51 PM, Sadananda H

Re: Setting auxpath in Hue/Beeswax

2012-11-26 Thread Edward Capriolo
You are looking for support in the wrong place. Beeswacks is not a part of hive thus only the cloudera folks will support it. On Mon, Nov 26, 2012 at 1:51 PM, Sadananda Hegde wrote: > Hello, > > > > I have copied jar file into /usr/lib/hive/lib folder on all the nodes. I > am able to use it on Hi

Re: Setting auxpath in Hue/Beeswax

2012-11-26 Thread Shreepadma Venugopalan
Hi Sadu, Can you please post this on the CDH forum? Thanks. Shreepadma On Mon, Nov 26, 2012 at 10:51 AM, Sadananda Hegde wrote: > Hello, > > > > I have copied jar file into /usr/lib/hive/lib folder on all the nodes. I > am able to use it on Hive CLI with the command > > > > hive --auxpath /usr

Setting auxpath in Hue/Beeswax

2012-11-26 Thread Sadananda Hegde
Hello, I have copied jar file into /usr/lib/hive/lib folder on all the nodes. I am able to use it on Hive CLI with the command hive --auxpath /usr/lib/hive/lib/ Then I am able to run my Hive SQLs successfully. But the same queries fail to run in Hue/Beeswax. It's not finding the jar fi

Re: Permissions preventing me from inserting data into table I have just created

2012-11-26 Thread yaboulna
Thanks for the reply Tim. It is writable to all (permission 777). As a side note, I have discovered now that the mapreduce task spawned by the RCFileOutputDriver is setting mapred.output.dir to a folder under file:// regardrless of the fs.default.name. This might be expected beahviour, but

Re: Permissions preventing me from inserting data into table I have just created

2012-11-26 Thread Tim Havens
make sure :/home/yaboulnaga/tmp/**hive-scratch/ is writeable by your processes. On Mon, Nov 26, 2012 at 10:07 AM, wrote: > Hello, > > I'm using Cloudera's CDH4 with Hive 0.9 and Hive Server 2. I am trying to > load data into hive using the JDBC driver (the one distributed with > Cloudera CDH4 "

Re: Permissions preventing me from inserting data into table I have just created

2012-11-26 Thread Edward Capriolo
You may have to go directly to cloudera support for this one. HiveServer2 is not officially part of hive yet so technically we should not be supporting it (yet). However someone on list might still answer you. On Mon, Nov 26, 2012 at 11:07 AM, wrote: > Hello, > > I'm using Cloudera's CDH4 with

Permissions preventing me from inserting data into table I have just created

2012-11-26 Thread yaboulna
Hello, I'm using Cloudera's CDH4 with Hive 0.9 and Hive Server 2. I am trying to load data into hive using the JDBC driver (the one distributed with Cloudera CDH4 "org.apache.hive.jdbc.HiveDriver". I can create the staging table and LOAD LOCAL into it. However when I try to insert data in