hive建表并导入csv文件数据
文章目录
先是在的hive命令行建的表,成功导入了,但是impala客户端查不到,然后刷新了元数据(invalidate metadata 表名)
impala报错不支持org.apache.hadoop.hive.serde2.OpenCSVSerde
然后就选了第二种方法(注意分隔符)
一、建表
1.
create table if not exists test.product_browsing (
user_id STRING,
phone STRING,
goods_id STRING,
goods_name STRING,
view_date STRING,
view_time STRING
) row format serde
'org.apache.hadoop.hive.serde2.OpenCSVSerde'
with
SERDEPROPERTIES
("separatorChar"=",","quotechar"="\"")
STORED AS TEXTFILE;
2.
create table if not exists Impala.test.product_browsing (
user_id STRING,
phone STRING,
goods_id STRING,
goods_name STRING,
view_date STRING,
view_time STRING
) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE;
二、加载数据命令
load data local inpath '/home/data.csv' overwrite into table test.product_browsing;
评论
登录后参与技术讨论,分享你的经验与见解。
登录 / 注册暂无评论