Problem in Decommission of datanode(Urgent)

2011-09-20 Thread Vikas Srivastava
Hey!! i m using 0.20.2 Apache hadoop and hive 0.7.0 , i thing i would like to ask is that i have to do make exclude file on all the data-nodes or only on NAMENODE. if on NN then i did that but not working. i did that whatever u said but its not working actually Wat happen is all lives nodes wen

Live nodes also shows as dead node

2011-09-20 Thread Vikas Srivastava
Hey Folks, i m using hadoop 0.20.2 and hive 0.7 , i m facing a problem like in my web UI show the no of live node is same as the dead node(actually they are live). Ex: i have 12 node cluster * my live node :12 my dead node:12 * i m not getting it why it is showing live nodes as dead nodes !!!

Re: problems with indices

2011-09-20 Thread rohan monga
Hi Prajakta, Thanks, I was able to generate a plan which was using indices by following your advise. However, I want to group on one key and count the others "select count(id2) from table_t1 group by id1", would that not be possible ? Also, could you give me an example of using indices to speed up

Re: problems with indices

2011-09-20 Thread Prajakta Kalmegh
Hi Rohan I run your queries on the same version from trunk and did not get any errors. Not sure why you are getting a semantic analysis error. It would be good if you could send me a snapshot of the error message. About the second issue of getting the same plan even if you set hive.optimize.index

setting propagate

2011-09-20 Thread Wil -
Hi, I running a query in Hive that generates 2 map reduce job. However, I noticed that the settings are not propagated into the 2nd map reduce job. Is this a bug or am I issuing the query incorrectly? set hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat; set hive.exec.dynamic.par