How to know location about partition in hive?
show table extended like 'tbl_name' partition (dt='20131023');Show Tables/Partitions Extended
SHOW TABLE EXTENDEDwill 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.