hive 导入csv文件

最新推荐文章于 2025-01-23 17:42:25 发布

weixin_30788731

最新推荐文章于 2025-01-23 17:42:25 发布

阅读量213

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/0xcafedaddy/p/8435614.html

创建hive表：

create table table_name(
id string,
name string,
age string
)
row format serde
'org.apache.hadoop.hive.serde2.OpenCSVSerde'
with
SERDEPROPERTIES
("separatorChar"=",","quotechar"="\"")
STORED AS TEXTFILE;

导入数据：

load data local inpath '/home/kyang/table_name.csv' overwrite into table table_name;

将表转换成ORC表：

create table table_name_orc(
id string,
name string,
age string
)row format delimited fields terminated by "\t" STORED AS ORC

insert overwrite table table_name_orc select * from table_name

转载于:https://www.cnblogs.com/0xcafedaddy/p/8435614.html