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

["Mark Grover (JIRA)" <ji...@apache.org>]

    [ 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