question Re: is there a way in hive to list all the table locations along with the partition location. in Archives of Support Questions (Read Only) https://community.cloudera.com/t5/Archives-of-Support-Questions/is-there-a-way-in-hive-to-list-all-the-table-locations-along/m-p/105667#M33473 <P>if you are using mysql database as metastore then you can use following query to get partition locations directly from metastore.</P><PRE>select TBLS.TBL_NAME,PARTITIONS.PART_NAME,SDS.LOCATIONfrom SDS,TBLS,PARTITIONSwhere PARTITIONS.SD_ID = SDS.SD_IDand TBLS.TBL_ID=PARTITIONS.TBL_IDorder by 1,2;</PRE> Thu, 30 Jun 2016 16:02:27 GMT rajkumar_singh 2016-06-30T16:02:27Z is there a way in hive to list all the table locations along with the partition location. https://community.cloudera.com/t5/Archives-of-Support-Questions/is-there-a-way-in-hive-to-list-all-the-table-locations-along/m-p/105666#M33472 Thu, 30 Jun 2016 15:57:31 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/is-there-a-way-in-hive-to-list-all-the-table-locations-along/m-p/105666#M33472 navitkumar_sing 2016-06-30T15:57:31Z Re: is there a way in hive to list all the table locations along with the partition location. https://community.cloudera.com/t5/Archives-of-Support-Questions/is-there-a-way-in-hive-to-list-all-the-table-locations-along/m-p/105667#M33473 <P>if you are using mysql database as metastore then you can use following query to get partition locations directly from metastore.</P><PRE>select TBLS.TBL_NAME,PARTITIONS.PART_NAME,SDS.LOCATIONfrom SDS,TBLS,PARTITIONSwhere PARTITIONS.SD_ID = SDS.SD_IDand TBLS.TBL_ID=PARTITIONS.TBL_IDorder by 1,2;</PRE> Thu, 30 Jun 2016 16:02:27 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/is-there-a-way-in-hive-to-list-all-the-table-locations-along/m-p/105667#M33473 rajkumar_singh 2016-06-30T16:02:27Z