查看表分区具体location
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'
;
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'
;
