修改impala表location

两种方式:

一、通过修改表DDL:

alter table t_m_cc set location 'hdfs://heracles/user/video-mvc/hive/warehouse/t_m_cc'

二、直接修改hive 的meta info:

update `DBS` set `DB_LOCATION_URI` = replace(DB_LOCATION_URI,"oldpath","newpath")
 
update SDS  set location =replace(location,'oldpath,'newpath')

posted @ 2017-10-16 16:41  RoyFans  阅读(1676)  评论(0编辑  收藏  举报