You should be able to drop table using phoenix sqlline. https://phoenix.apache.org/language/#drop_table sqlline.py hostname.com /location/of/file/drop_table.sql ... View more

https://hortonworks.com/blog/apache-hadoop-yarn-concepts-and-applications/ Above link has good overview of how YARN works and the algorithms used ( capacity and fair scheduler ) by Resource manager for scheduling. Yarn capacity scheduler config tutorial is available at https://hortonworks.com/hadoop-tutorial/configuring-yarn-capacity-scheduler-ambari/ Does this help? ... View more

@uri ben-ari you need to look at those services that are failing and look at the log file to understand why they are failing and fix those issues. you can always revert back to the working config from the amabri UI. you can also perform restart of all the components required from the Ambari UI under Add Services -> Restart All affected ... View more

@Rohit Khose YARN is resource negotiator for your cluster. Spark ( like other hadoop application) requests YARN for resources specified by the user and if available it will use them. You can enable spark dynamic allocation so the spark application can scale up/down executors depending on the need. https://spark.apache.org/docs/1.6.1/configuration.html#dynamic-allocation ... View more

you can look into turning on `spark.dynamicAllocation.enabled` setting, this setting will release any un-unsed executors back to the cluster and request when they are needed link https://spark.apache.org/docs/latest/configuration.html#dynamic-allocation or after you have completed your analysis, you can restart the spark interpreter in zeppelin, due to lazy evaluation zeppelin will only start the spark context when you need it. ... View more

@Krishna Kumar you dont need to stop spark context when you are using zeppelin. can you remove sc.stop() line and try again? ... View more