Hive学习笔记

45 阅读 0 评论 30 点赞

我是靠谱客的博主发嗲钢笔，最近开发中收集的这篇文章主要介绍Hive学习笔记，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

beeline可以用!connect jdbc:hive2://localhost:10000 用来连接hiveserver2启动的hive服务

建表操作

CREATE [EXTERNAL] TABLE [IF NOT EXISTS] table_name

[(col_name data_type [COMMENT col_comment], ...)]

[COMMENT table_comment]

[PARTITIONED BY (col_name data_type [COMMENT col_comment], ...)]

[CLUSTERED BY (col_name, col_name, ...)

[SORTED BY (col_name [ASC|DESC], ...)] INTO num_buckets BUCKETS]

[ROW FORMAT row_format]

[STORED AS file_format]

[LOCATION hdfs_path]

create external table t_sz_ex(id int,name string) row format delimited field terminated by 't' stored as textfile location '/sz_ex'; //建立一个外表

load data local inpath '/andy2.txt' into table t_sz_ex; //使用load名令将数据穿到指定位置

在hive里面可以直接用命令 dfs -ls 来查看Hadoop中的东西；

删数据的时候外部表的存储数据不会被删除，但是内部表会被删除

创建分区表

0: jdbc:hive2://localhost:10000> create table t_sz_part(id int,name string) ng) row format delimited field terminated by 't' stored as textfile location '/sz_ex';
0: jdbc:hive2://localhost:10000> partitioned by (country string)
0: jdbc:hive2://localhost:10000> row format delimited

0: jdbc:hive2://localhost:10000> fields terminated by ',';

将数据导入到分区表中并且指定分区表
0: jdbc:hive2://localhost:10000> load data local inpath '/root/andy2.txt' into table t_sz_part partition(country=China);