[
https://issues.apache.org/jira/browse/HIVE-3885?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13579844#comment-13579844
]
Mark Grover commented on HIVE-3885:
-----------------------------------
Sanjay: I am replying to your question on the IRC channel.
I think this will be a good starting point,
https://github.com/apache/hive/blob/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/ShowPartitionsDesc.java
See who uses this class and how.
> 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
