title: How to get hive table name based on HDFS location path? with out connecting to metastore
body: <p>I know how to get hive table name based on HDFS location through Meta-store. For example, if I need to get table name for the HDFS location <code>hdfs://xyz.com:8020/user/hive/warehouse/test</code> </p>
  
  <ol>
  <li>I will connect to hive metastore using JDBC.</li>
  <li>Run a query against tables <code>TBLS</code> and <code>SDS</code>, <code>SDS.location</code> will have location value of table, and get <code>TBLS.tbl_name</code>.</li>
  </ol>
  
  <p>But, I need other ways to get table name?</p>
  
  <p>Is it possible?</p>