记一次 Hadoop Hive 集群新建 Hive 表

小鱼儿 2022-12-29 14:06 171阅读 0赞

# 一、集群搭建 #

1、[基于 Hadoop 3.x 集群搭建部署 Hive][Hadoop 3.x _ Hive]  
2、[搭建部署 Hive 3.1.2 分布式集群][Hive 3.1.2]

# 二、启动 Hdfs、Yarn 服务 #

[root@master ~]# /usr/bigdata/hadoop-3.3.0/sbin/stop-dfs.sh
    [root@master ~]# /usr/bigdata/hadoop-3.3.0/sbin/start-yarn.sh

# 三、启动 Hive #

1、在任一 Hive 客户端节点启动 hive  
效果如下：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsd3kxNDI4_size_16_color_FFFFFF_t_70]  
2、查看数据库列表

hive (default)> show databases;
    OK
    database_name
    db_test
    default
    Time taken: 0.667 seconds, Fetched: 2 row(s)

![在这里插入图片描述][20201222225210658.png]  
3、选择数据库

hive (default)> use db_test;
    OK
    Time taken: 0.037 seconds

4、创建表 students、hive\_user

hive (db_test)> create table students(id int,name string,age int);
    OK
    Time taken: 0.534 seconds
    hive (db_test)> create table hive_user(id int,username string,passwd string);
    OK
    Time taken: 0.069 seconds

5、查看数据库列表

hive (db_test)> show tables;
    OK
    tab_name
    students
    hive_user
    Time taken: 0.052 seconds, Fetched: 1 row(s)

6、正则查看数据库列表

hive (db_test)> show tables'.*s';
    OK
    tab_name
    students
    Time taken: 0.035 seconds, Fetched: 1 row(s)

7、查看表结构

hive (db_test)> describe students;
    OK
    col_name	data_type	comment
    id                  	int                 	                    
    name                	string              	                    
    age                 	int                 	                    
    Time taken: 0.058 seconds, Fetched: 3 row(s)
    hive (db_test)> describe hive_user;
    OK
    col_name	data_type	comment
    id                  	int                 	                    
    username            	string              	                    
    passwd              	string              	                    
    Time taken: 0.065 seconds, Fetched: 3 row(s)

8、重命名指定表

hive (db_test)> alter table hive_user rename to hive_user_test;
    OK
    Time taken: 0.19 seconds
    hive (db_test)> show tables;
    OK
    tab_name
    hive_user_test
    students
    Time taken: 0.04 seconds, Fetched: 2 row(s)

9、查看制定表重命名后的表结构

hive (db_test)> describe hive_user_test;
    OK
    col_name	data_type	comment
    id                  	int                 	                    
    username            	string              	                    
    passwd              	string              	                    
    Time taken: 0.06 seconds, Fetched: 3 row(s)

10、对指定标增加列

hive (db_test)> alter table hive_user_test add columns(phone string);
    OK
    Time taken: 0.11 seconds
    hive (db_test)> describe hive_user_test;
    OK
    col_name	data_type	comment
    id                  	int                 	                    
    username            	string              	                    
    passwd              	string              	                    
    phone               	string              	                    
    Time taken: 0.06 seconds, Fetched: 4 row(s)

11、对指定表增加字段

hive (db_test)> alter table hive_user_test add columns(type string comment 'userType');
    OK
    Time taken: 0.107 seconds
    hive (db_test)> describe hive_user_test;
    OK
    col_name	data_type	comment
    id                  	int                 	                    
    username            	string              	                    
    passwd              	string              	                    
    phone               	string              	                    
    type                	string              	userType            
    Time taken: 0.058 seconds, Fetched: 5 row(s)

12、对指定表字段增加备注

hive (db_test)> alter table hive_user_test replace columns(id int,username string,passwd string,usertype string comment 'userType');
    OK
    Time taken: 0.101 seconds
    hive (db_test)> describe hive_user_test;
    OK
    col_name	data_type	comment
    id                  	int                 	                    
    username            	string              	                    
    passwd              	string              	                    
    usertype            	string              	userType            
    Time taken: 0.053 seconds, Fetched: 4 row(s)

13、删除指定表表

hive (db_test)> drop table students;
    OK
    Time taken: 0.244 seconds
    hive (db_test)> show tables;
    OK
    tab_name
    hive_user_test
    Time taken: 0.032 seconds, Fetched: 1 row(s)

以上是对 Hive 表的部分基础操作，后期会继续扩展！

[Hadoop 3.x _ Hive]: https://blog.csdn.net/llwy1428/article/details/111502413
[Hive 3.1.2]: https://blog.csdn.net/llwy1428/article/details/111568662
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xsd3kxNDI4_size_16_color_FFFFFF_t_70]: /images/20221120/9ff288f584254cc78e6d2c52d7dbd530.png
[20201222225210658.png]: /images/20221120/2a827e92ade142a1bd3d491e53efab8e.png