They are new to Ambari as well. Example : a new team would like to get into Ambari as well as Hive view. Currently i am doing 1) creating ambari user 2) Assign hive view. This works if users are countable. Now if i would like to do for 100/200 members, what approach should i follow ? @jonathan sneep ... View more

@Sagar Shimpi : will this process cleanup physical folders and dependencies automatically by running curl command or Ambari service deletion ? if not , do we need to delete manually ? thanks in advance. ... View more

Ambari is not writting any log information. even ambari-server.out is also not having error log for that period. ... View more

@amarnath reddy pappu - I don't see a log during failed period. is there a way to know why logs are not written ? ... View more

@Pedro Andrade @amarnath reddy pappu @Akhil S Naik - thanks for your quick reply. I am seeing below statements repeatedly. unable to get exact error phrase/word. any help please . thanks in advance [ambari-client-thread-9015] StackAdvisorRunner:** - Stack-advisor output=/var/run/ambari-server/stack-recommendations/2/stackadvisor.out, error=/var/run/ambari-server/stack-recommendations/2/stackadvisor.err Rest all statements are INFO/WARN no error. ... View more

Let me make it clear HDFS Level- we have only valid partitions (parition1,parition2) Table Level - we have both valid(parition1,partition2) and invalid partitions(partition3,partition4). I would like to drop only invalid partitions(partition3,partition4). -> Unable to drop by passing Url encoded characters & Timestamp. -> Created invalid partition at HDFS level, unable to drop. -> Issued MCSK REPAIR command , post success also unable to drop. Thanks ... View more

It is not working and notified to Hortonworks team. Soon I got the answer will post it here. ... View more

Adding to that , we are able to drop the partitions at HDFS level, but those invalid partitions were not dropped even after MCSK REPAIR TABLE command too. ... View more

Deepesh - it did not worked. Getting below error. With IF EXIST Error: Error while compiling statement: FAILED: ParseException line 1:75 mismatched input 'IF' expecting ( near 'PARTITION' in drop partition statement (state=42000,code=40000) Without IF EXIST - Error: Error while compiling statement: FAILED: SemanticException Unexpected unknown partitions for (load_s = 2017-02-22 12:21:39.0) (state=42000,code=40000) ... View more

@peeyush Thanks for your help. Followed the same and issue been resolved. ... View more

@Artem Ervits Thanks for your reply. I tried it but no results and no errors. ... View more

Thank you @Kuldeep Kulkarni ... View more

@Kuldeep Kulkarni - Thanks for your reply. Can you please help me with Oozie CLI to get the list of the jobs whose schdule is between 8AM-5pm EST. ... View more

@clukasik - Thanks for the reply. I tried your query and it worked , here is my observations. show partitions tablename; partition_dt=2017-01-03 10%3A20%3A13 partition_dt=2017-01-03 10%3A20%3A14 partition_dt=2017-01-03 10%3A20%3A15 select patition_dt, count(1) from tablename group by partition_dt; 2017-01-03 10:20:13.0 | 2191 2017-01-03 10:20:14.0 | 7888 2017-01-03 10:20:15.0 | 1647 Note: %3A should be replaced with : while quering. select count(1) from tablename where partition_dt="2017-01-03 10:20:13"; +-------+--+ | _c0 | +-------+--+ | 2191 | +-------+--+ 1 row selected (3.643 seconds) select count(1) from tablename where partition_dt="2017-01-03 10:20:14"; +-------+--+ | _c0 | +-------+--+ | 7888 | +-------+--+ 1 row selected (0.101 seconds) select count(1) from tablename where partition_dt="2017-01-03 10:20:15"; +-------+--+ | _c0 | +-------+--+ | 1647 | +-------+--+ 1 row selected (0.101 seconds) Sampling i used below query. select * from tablename where partition_dt="2017-01-03 10:20:15" limit 5; ... View more