关于数据库: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'withSERDEPROPERTIES("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;