How to know location about partition in hive?
Do a describe on the partition instead of the full table.
This will show the linked location if it's an external table.
describe formatted tbl_name partition (dt='20131023')
If you have multiple nested partitions, the syntax is:
describe formatted table_name partition (day=123,hour=2);
show table extended like 'tbl_name' partition (dt='20131023');
Show Tables/Partitions Extended
SHOW TABLE EXTENDED
will list information for all tables matching the given regular expression. Users cannot use regular expression for table name if a partition specification is present. This command's output includes basic table information and file system information liketotalNumberFiles
,totalFileSize
,maxFileSize
,minFileSize
,lastAccessTime
, andlastUpdateTime
. If partition is present, it will output the given partition's file system information instead of table's file system information.