Re: Indexing Help

2011-08-05 Thread Shouguo Li
on a side note, i'm looking at adding indexes to our hive tables as well, is there a performance/space trade off comparison or metrics? thx! On Wed, Aug 3, 2011 at 10:52 AM, Siddharth Ramanan < siddharth.rama...@gmail.com> wrote: > Hi all, > I have used compact index for my table and th

Re: Indexing help

2011-08-01 Thread Siddharth Ramanan
The reduce percentage keeps fluctuating when, the alter index command is being keyed. The logs just give " out of memory error " after tweaking some properties, the earlier exceptions doesn't appear now. Can anyone guide me here? I have increased the heap space upto 4gb.. still, getting the same ex

Re: Indexing help

2011-07-28 Thread Siddharth Ramanan
Hi, I am adding the log information for a reduce task. I am running hadoop in standalone mode. 2011-07-28 19:16:42,621 ERROR org.apache.hadoop.hive.ql.stats.jdbc.JDBCStatsPublisher: Error during JDBC connection to jdbc:derby:;databaseName=TempStatsStore;create=true. java.lang.ClassNotFoundExc