Hive表创建并导入CSV文件数据

最新推荐文章于 2025-04-02 10:30:57 发布

双响の炮

最新推荐文章于 2025-04-02 10:30:57 发布

阅读量975

点赞数 4

文章标签： hive

本文链接：https://blog.csdn.net/qq_41875060/article/details/143595930

版权

一、建表
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;

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;

一、建表
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;

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;