Re: Question of Hive Partitioning

2010-12-27 Thread yongqiang he
Can you post your query? Is there " or " connecting the partitions' predicate with others? Thanks Yongqiang On Mon, Dec 27, 2010 at 11:09 PM, Narendra wrote: > Hi, > > Hive wiki says "Hive currently does input pruning only if the partition > predicates are specified in the WHERE clause closest to

Question of Hive Partitioning

2010-12-27 Thread Narendra
Hi, Hive wiki says "Hive currently does input pruning only if the partition predicates are specified in the WHERE clause closest to the table_reference in the FROM clause..." what does this mean? I have a query in which I am joining 4 tables two of which need to be pruned by partition. The partit

Re: Using a SQL-esque program to run Hive jobs?

2010-12-27 Thread Kirk True
Hi Jon, On 12/27/10 6:56 AM, Jonathan Coveney wrote: I apologize in advance if this is a basic question... I haven't found a straight answer to the question, though, and am new to Hive so forgive the ignorance. I've done some searching around, and it looks like HUE may be one solution, but p

Re: Using a SQL-esque program to run Hive jobs?

2010-12-27 Thread Edward Capriolo
On Mon, Dec 27, 2010 at 9:56 AM, Jonathan Coveney wrote: > I apologize in advance if this is a basic question... I haven't found a > straight answer to the question, though, and am new to Hive so forgive the > ignorance. > I've done some searching around, and it looks like HUE may be one solution,

Using a SQL-esque program to run Hive jobs?

2010-12-27 Thread Jonathan Coveney
I apologize in advance if this is a basic question... I haven't found a straight answer to the question, though, and am new to Hive so forgive the ignorance. I've done some searching around, and it looks like HUE may be one solution, but pending looking into that, I was wondering if anyone has use