Re: Exception while running simple hive query

2012-05-07 Thread kulkarni.swar...@gmail.com
Thanks Shashwat. That did work. However I do find this behavior very weird that it is able to find all other libs at their proper location on local filesystem but searches for this particular one on HDFS. I'll try to dig deeper into the code to see if I can find a cause for this happening. On Mon

Re: Exception while running simple hive query

2012-05-07 Thread shashwat shriparv
Do one thing create the same structure /Users/testuser/hive-0.9.0/ lib/hive-builtins-0.9.0.jar on the hadoop file system and den try.. will work Shashwat Shriparv On Mon, May 7, 2012 at 11:57 PM, kulkarni.swar...@gmail.com < kulkarni.swar...@gmail.com> wrote: > Thanks for the reply. > > Assumi

Re: Exception while running simple hive query

2012-05-07 Thread kulkarni.swar...@gmail.com
Thanks for the reply. Assuming that you mean for permissions within the HIVE_HOME, they all look ok to me. Is there anywhere else too you want me to check? On Mon, May 7, 2012 at 11:16 AM, hadoop hive wrote: > check for the permission.. > > > On Mon, May 7, 2012 at 7:30 PM, kulkarni.swar...@gma

Re: Exception while running simple hive query

2012-05-07 Thread hadoop hive
check for the permission.. On Mon, May 7, 2012 at 7:30 PM, kulkarni.swar...@gmail.com < kulkarni.swar...@gmail.com> wrote: > I created a very simple hive table and then ran the following query that > should run a M/R job to return the results. > > hive> SELECT COUNT(*) FROM invites; > > But I am

Re: error in running simple Hive Query

2012-03-28 Thread Bejoy Ks
Kirk True To: user@hive.apache.org Cc: Manish Bhoge Sent: Wednesday, March 28, 2012 10:54 AM Subject: Re: error in running simple Hive Query It looks like your "+" in the JAR name is being replaced in the file/URL as " ". Hive 0.5 is old. If possible, consider upgrading

Re: error in running simple Hive Query

2012-03-27 Thread Kirk True
ve.apache.org *Subject: *error in running simple Hive Query I'm using Hive distribution from CDH v0.5.0+32 and was able to run a simple query "select * from country;" But when I try to run "select * from country where code = 'US', I get the error below: hive-exec-0.

Re: error in running simple Hive Query

2012-03-27 Thread Kirk True
ubject: *error in running simple Hive Query I'm using Hive distribution from CDH v0.5.0+32 and was able to run a simple query "select * from country;" But when I try to run "select * from country where code = 'US', I get the error below: hive-exec-0.5.0+32.jar doe

Re: error in running simple Hive Query

2012-03-27 Thread Manish Bhoge
To: user@hive.apache.org Reply-To: user@hive.apache.org Subject: error in running simple Hive Query I'm using Hive distribution from CDH v0.5.0+32 and was able to run a simple query "select * from country;" But when I try to run "select * from country where code = 'US'

error in running simple Hive Query

2012-03-27 Thread Nguyen, Khoa
I'm using Hive distribution from CDH v0.5.0+32 and was able to run a simple query "select * from country;" But when I try to run "select * from country where code = 'US', I get the error below: hive-exec-0.5.0+32.jar does exist under /usr/local/cdh_hive-0.5.0 32/lib hadoop@Frankenbox2:/usr/loca

RE: Simple Hive Query

2012-03-05 Thread Hamilton, Robert (Austin)
Hi Vikas. You might review your logic. You probably want 'and' instead of 'or' in your where clause. From: hadoop hive [mailto:hadooph...@gmail.com] Sent: Monday, March 05, 2012 5:55 AM To: d...@hive.apache.org; user@hive.apache.org Subject: Simple Hive Query Hi Folks ,

Re: Simple Hive Query

2012-03-05 Thread Wouter de Bie
Hi, Your table specifies 3 ints, however, some of your rows contain strings. If you specify you table as strings and then later parse the fields to an int (by doing some replacements and casting it to an int), it should work. // Wouter On Monday, March 5, 2012 at 12:55 PM, hadoop hive wrote:

Simple Hive Query

2012-03-05 Thread hadoop hive
Hi Folks , i m facing a problem like i have a table a(k1 int ,k2 int ,k3 int ); and data present is like *9,*1,*3 3,4,5 12,32,54 *9,12,32 12,*9,21 i need row which doesn't have *9 in any fields. i wrote a query 1: select k1,k2,k3 from a where (k1<>'\*9' or k2<>'\*9' or k3<>'\*9'); 2: selec