[jira] [Created] (HIVE-3885) CLI command "SHOW PARTITIONS" could be extended to provide LOCATION information

["Sanjay Subramanian (JIRA)" <ji...@apache.org>]

Sanjay Subramanian created HIVE-3885:
----------------------------------------

             Summary: CLI command "SHOW PARTITIONS" could be extended to provide LOCATION information
                 Key: HIVE-3885
                 URL: https://issues.apache.org/jira/browse/HIVE-3885
             Project: Hive
          Issue Type: New Feature
            Reporter: Sanjay Subramanian
            Priority: Minor


SHOW PARTITIONS does not provide information on the HDFS location of the data. The workaround is to query the metadata DB. The following command will give you the HDFS file locations as stored in the metadata tables.
 
echo "select t.TBL_NAME, p.PART_NAME, s.LOCATION from PARTITIONS p, SDS s, TBLS t where t.TBL_ID=p.TBL_ID and p.SD_ID=s.SD_ID " |mysql -u<username> –p<password>  <hive_metastore_DB> |grep <HIVETABLENAME>|less

If this could be encapsulated in a CLI command SHOW LOCATIONS that displays
PARTITION_NAME        LOCATION

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira