@Shravan Kumar, Can you please run this command and check the output. If it is kerberized environment , run kinit before running the command oozie admin -oozie http://{oozie-host}:11000/oozie -shareliblist If the above command doesn't return output like below then run the below mentioned commands as well. Make sure that the below list is returned [Available ShareLib] hive distcp mapreduce-streaming spark oozie hcatalog hive2 sqoop pig spark_orig Create the share lib # /usr/hdp/<HDP Version>/oozie/bin/oozie-setup.sh sharelib create -fs hdfs://${NAMENODE-HOST}:8020 Update Sharelib # oozie admin -oozie http://{oozie-host}:11000/oozie -sharelibupdate Thanks, Aditya ... View more

@Shravan Kumar, I see that you created tables using hbase shell and trying to access it using phoenix (sqlline.py). When you run using hbase shell, the tables wont be registered in SYSTEM.CATALOG table of phoenix which maintains the table metadata. So you wont be able to see the table in phoenix. If you want to access it via hbase, you can map the hbase table to phoenix . You can create a view in phoenix. To confirm this , you can run the below query /usr/hdp/current/phoenix-client/bin/sqlline.py zookeeper-test-1:2181/hbase-unsecure select distinct(TABLE_NAME) from SYSTEM.CATALOG; ---- > This will not return the table name. One more solution is to create the table via phoenix client . Then you can access it using phoenix and hbase shell. Thanks, Aditya ... View more

@Shravan Kumar, You can use the below API for Turn ON and Turn OFF respectively curl -k -u <username>:<password> -H "X-Requested-By:ambari" -i -X PUT -d '{"RequestInfo":{"context":"Turn On Maintenance Mode for SNameNode"},"Body":{"HostRoles":{"maintenance_state":"ON"}}}' http://{ambari-host}:{ambari-port}/api/v1/clusters/{clustername}/hosts/{hostname}/host_components/SECONDARY_NAMENODE curl -k -u <username>:<password> -H "X-Requested-By:ambari" -i -X PUT -d '{"RequestInfo":{"context":"Turn Off Maintenance Mode for SNameNode"},"Body":{"HostRoles":{"maintenance_state":"OFF"}}}' http://{ambari-host}:{ambari-port}/api/v1/clusters/{clustername}/hosts/{hostname}/host_components/SECONDARY_NAMENODE Replace the ambari-host,ambari-port , clustername and hostname placeholders with the original value. Thanks, Aditya ... View more