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
