1.用hive语句 describe extended f_gameCenter_user_login_out_day partition(dt = '2014-03-19'); 2.用hive元数据库mysql查询 select a.LOCATION from SDS a left join PARTITIONS b on (a.SD_ID=b.SD_ID) left join TBLS c on (b.TBL_ID=c.TBL_ID) where c.TBL_NAME='f_gamecenter_user_login_out_day' and b.PART_NAME='dt=2014-03-19' ;