hive> alter table wms_c_wlsydmx set location '/user/hive/warehouse/zwpdb.db/wms_c_wlsydmx1'
> ;
FAILED: Error in metadata: /user/hive/warehouse/zwpdb.db/wms_c_wlsydmx1 is not absolute or has no scheme information. Please specify a complete absolute uri with scheme information.
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
hive> alter table wms_c_wlsydmx set location 'hdfs://h252020:9000/user/hive/warehouse/zwpdb.db/wms_c_wlsydmx1'
> ;
OK
很明显,需要加上hdfs://h252020:9000
原文:https://blog.csdn.net/u010080235/article/details/8959522