生成hive外部表

最新推荐文章于 2023-08-06 15:29:21 发布

lrq3

最新推荐文章于 2023-08-06 15:29:21 发布

阅读量253

点赞数

本文链接：https://blog.csdn.net/lrq3/article/details/8523557

版权

建表：

create EXTERNAL table t_user_follower_all (user_id int, follower_id int,sms_flag int,mms_flag int, black_flag int, update
_time string,create_time string, status int, source int,load_time string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' LINES TERMI
NATED BY '\n' STORED AS TEXTFILE LOCATION '/user/data/t_user_follower_all';

load数据：

hadoop dfs -put ../datafile/user_follower_all.txt /user/data/t_user_follower_all

注意：分隔符是逗号