无分区:
alter table credit_feature.20180824_morpho_label_df set serdeproperties(
'hdfs://wejoyservice/user/hive/warehouse/credit_feature.db/20180824_morpho_label_df'
);
有分区:
alter table tablename partition(dt=‘xxxx‘) set serdeproperties(‘field.delim‘=‘\t‘);
布置只有外部表可以指定location,内部表也可以指定location。
alter table table_name [partition(...)] set location ‘path‘
网友评论