Hive load hdfs文件生成hive表

1、上传文件到hdfs

hdfs dfs -put ./user_id.csv /team/profile/test;

2、创建表(进入hive客户端)

create table tmp.profile_need_match_view_users(id string) row format delimited fields terminated by ',';

3、load到hive表

load data inpath '/team/profile/test/user_id.csv' into table tmp.profile_need_match_view_users;