@divya_thaore  1. If you are starting service via Ambari / Cloudera Manager UI then check the operation logs which are displayed in UI while you start the service     Please check for any errors in the logs clicking the service operational logs. 2. If you do not see any operational logs or any operation triggerred while you start/restart service then kindly restart agent service once [ambari agent/cloudera-scm-agent] 3. Else please check logs from cli as suggested by @Shelton    If you still need help please revert. ... View more

@mike_bronson7  The latest command you posted again has typo. "R" is missing at the end in below command -   >>curl -u admin:admin -H "X-Requested-By: ambari" -X DELETE "http://node02:8080/api/v1/clusters/HDP/hosts/node01/host_components/SPARK2_THRIFTSERVE"   Pls try and pass new error if any. ... View more

Hi Shelton,   The steps you provided worked perfectly.   Thanks! ... View more

Thank you for the info. Yes, I have created with backup with another directory and I was about to boot restart the namenode from that image. ... View more

Quick update: I worked with @fgarcia to edit the post in question. 🙂 ... View more

@deekshant    To debug Namenode issue you need to check below -   1. Check active namenode[NN] logs [for time when it got reboot] 2. Check active NN zkfc logs [same time - if you see any issue] 3. Check for standby NN logs at same time if you see any error 4. Check for standby NN zkfc logs for any error at same timestamp 5. Check for Active NN .out file for any warnings/error 6. Check for system logs "/var/log/message" for any issue at particular moment of time.   You will find error in one of the above file. accordingly you can go for RCA. Do revert if you need further help. ... View more

@Rak  You have a couple of errors in your sqoop syntax but you are almost there, please have a look at the below hints and retry after understanding and correcting them. 1. Sqoop import--connect This is wrong you need a space between the import and -- ie sqoop import --connect 2. 'jdbc:sqlserver'--username is also not correct you need a port number and databases name ie "jdbc:sqlserver://<Server_Host>:<Server_Port>;databaseName" 3. The quotes around the '2019-11-08'" is wrong too 3. All you -- should have a space before   sqoop import--connect 'jdbc:sqlserver'--username 'sa' -P--query "select * from dlyprice where $CONDITIONS AND `date`= '2019-11-08'"--split-by `date--target-dir /home/hduser2 -m 2   Try something like this ! sqoop import --connect --connect "jdbc:sqlserver://<Server_Host>:<Server_Port>;DB_Name>" \ --driver com.microsoft.sqlserver.jdbc.SQLServerDriver \ --username XXXX -P --query "select * from dlyprice  where $CONDITIONS AND `date`= '2019-11-08' \ --split-by `date`  --target-dir /home/hduser2 -m 2   The above isn't tested by I wanted to highlight some of your mistakes by making it work makes you a better hadooper !    Here is a link to Sqoop User Guide   Can you try out this syntax remember to replace the values with that  of your environment   sqoop import --connect "jdbc:sqlserver://hostname;username='sa';password='sa_password';database=yourDB" --driver com.microsoft.sqlserver.jdbc.SQLServerDriver --query "select * from dlyprice where \$CONDITIONS" --split-by date -m 2 --target-dir /home/hduser2   Please revert      ... View more

@wimster @Zeba    Surely thats great but during the webinar niether Lakshmi Randall, Wim Stoop nor Matthew could commit to Cloudera's release date hence the date before end of year 🙂 something understandable incase the release date is missed that won't be a good image. As an insider I am sure you have more information can you share the link to that release info I would like to test drive it this week. ... View more

@Manoj690  Can you check whether authorization has been delegated to Ranger/Kerbe/SQLAuth if you have Ranger plugin for Hive enabled then  the authorization has been delegated to Ranger the central authority.  You will need to enable the permissions through ranger for all hive database Hive > Configs > Settings > In Security it is set to ?   ... View more