@amira chaari you are using HDP 2.4 sandbox with maria_dev account. You need to use admin account to start/stop services in Ambari. Please follow the step by step guide in release notes to reset admin password and login with that account. Then turn off maintenance mode for HBase and you can start it. Here are instructions to reset password for admin. http://hortonworks.com/wp-content/uploads/2016/03/ReleaseNotes_3_3_2016.pdf ... View more

@Raja Ray can you provide more information? What's your location and company name? ... View more

do you have support account? I suggest you open up a ticket as it needs more exhaustive look at your environment. If you're saying you can't restart one RS, try my commands to kill the RS and start it with Ambari. Then make sure all configs are up to date and run a service check. This is a drastic measure so proceed with caution, at your own risk. @Raja Ray ... View more

@Raja Ray your regionserver log doesn't say anything, can you paste the ambari server logs errors when you try to restart this regionserver? ... View more

@Raja Ray please post regionserver logs for that node. Can you also consider upgrading to latest Ambari release as there are fixes on top of 2.0.0, at least 2.0.2 if not 2.1 or 2.2. You can also go to the node where regionserver does not restart and kill the service manually. ps aux | grep java find the pid associated with hbase regionserver then kill -9 hbasepidnumber ... View more

sorry auto-correct on my tablet. @Pradeep kumar I updated the answer with correct spelling. ... View more

That's a great question. I faced that choice when my DDL statement had reserved keywords like 'name'. It would not work without that property because name is now a reserved keyword and hive checks for that. Notice you have to always include it as even queries against tables that have these reserved words need to have this property unset SET hive.support.sql11.reserved.keywords=false; DROP TABLE IF EXISTS tweets; CREATE EXTERNAL TABLE tweets ( createddate string, geolocation string, tweetmessage string, `user` struct<geoenabled:boolean, id:int, name:string, screenname:string, userlocation:string>)ROW FORMAT SERDE 'org.apache.hive.hcatalog.data.JsonSerDe'LOCATION '/user/root/'; 2. SET hive.support.sql11.reserved.keywords=false;SELECT DISTINCT tweetmessage, user.name, createddateFROM tweets WHERE user.name = 'Hortonworks'ORDER BY createddate; ... View more

Did you install HBase? You need that for Phoenix to work. ... View more