关于数据库: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;