hive中建表并导入数据

create table test(day_id String,sale_nbr String,buy_nbr String,cnt String,round String) ROW format delimited fields terminated by ',' STORED AS TEXTFILE;

②导入数据:load data local inpath '/opt/module/data/0.csv' into table test;

③进入mysql:mysql -uroot -p000000

posted @ 2021-09-18 23:50  xjspyx  阅读(112)  评论(0编辑  收藏  举报