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 , i m facing a problem lik

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: