@Saurabh You can try the following code: import java.io.*; import java.util.*; import java.net.*; import org.apache.hadoop.fs.*; import org.apache.hadoop.conf.*; import org.apache.hadoop.io.*; import org.apache.hadoop.mapred.*; import org.apache.hadoop.util.*; public class FileStatusChecker { public static void main (String [] args) throws Exception { try{ FileSystem fs = FileSystem.get(new Configuration()); FileStatus[] status = fs.listStatus(new Path("hdfs://sandbox.hortonworks.com:8020/testing/ambari-server.log")); // you need to pass in your hdfs path for (int i=0;i<status.length;i++){ String path = status[i].getPath().toString(); String owner = status[i].getOwner(); System.out.println("\n\t PATH: " + path + "\t OWNER: " +owner); } } catch(Exception e){ System.out.println("File not found"); e.printStackTrace(); } } } . Here in the above code you can pass either a specific file newPath("hdfs://sandbox.hortonworks.com:8020/testing/ambari-server.log") Or a directory as well: newPath("hdfs://sandbox.hortonworks.com:8020/testing") ... View more

@Anandha L Ranganathan The "MySQLSyntaxErrorException" looks strange here looks buggy. Which version of ambari are you using? . - However as a quick workaround you might want to try the following approach to delete the "PRESTO" service completely. 1. Stop ambari-server ambari-server stop 2. Take ambari Database backup for Safety. mysqldump $dbname >/tmp/ambari_db_dump.sql Exampel: mysqldump ambari >/tmp/ambari_db_dump.sql 3. Now in the ambari Database run the following commands. This will clear the PRESTO service entry from you ambari DB. delete from hostcomponentstate where service_name = 'PRESTO'; delete from hostcomponentdesiredstate where service_name = 'PRESTO'; delete from servicecomponentdesiredstate where service_name = 'PRESTO'; delete from servicedesiredstate where service_name = 'PRESTO'; delete from serviceconfighosts where service_config_id in (select service_config_id from serviceconfig where service_name = 'PRESTO'); delete from serviceconfigmapping where service_config_id in (select service_config_id from serviceconfig where service_name = 'PRESTO'); delete from serviceconfig where service_name = 'PRESTO'; delete from requestresourcefilter where service_name = 'PRESTO'; delete from requestoperationlevel where service_name = 'PRESTO'; delete from clusterservices where service_name ='PRESTO'; delete from clusterconfig where type_name like 'presto%'; delete from clusterconfigmapping where type_name like 'presto%'; 4. Now restart ambari-server ambari-server start . ... View more