交互模式 · Hadoop2.x

[TOC] # 1. Hive客戶端 **1. 進入hive客戶端工具** ```shell [root@hadoop101 /]# hive ``` **2. 查看所有數據庫** ```sql hive> show databases; ``` **3. 查看當前使用的數據庫** ```sql hive> select current_database(); ``` **4. 查看當前數據庫的所有數據表** ```sql hive> show tables; ``` **5. 查看hive_table表的描述信息** ```sql hive> desc hive_table; ``` **6. 執行Linux命令** ```sql hive> !ls /; bin boot data ``` **7. 執行hdfs命令** ```sql hive> dfs -ls /; drwxr-xr-x - root supergroup 0 2021-04-23 04:57 /hbase drwxrwxrwx - root supergroup 0 2021-03-04 03:33 /home ``` **8. 執行new_sql.sql文件** ```sql hive> source /opt/install/hive/mydata/new_sql.sql; ``` **9. 查看hive版本信息** ```sql hive> !hive --version; Hive 1.1.0-cdh5.14.2 ``` **10. 退出hive客戶端，執行 quit; 或者按Ctrl+C** ```sql hive> quit; ``` # 2. beeline客戶端 **1. 使用beeline客戶端需要提前開啟hiveserver2服務** ```shell -- 開啟方式1：該方式啟動會打印日志 [root@hadoop101 /]# hiveserver2 -- 開啟方式2：該方式啟動不會打印日志 [root@hadoop101 /]# nohup hive --service hiveserver2 & -- 開啟方式3：先開啟元數據服務器（這一步是非必須的），再開啟hiveserver2 [root@hadoop101 /]# nohup hive --service metastore & [root@hadoop101 /]# nohup hive --service hiveserver2 & ``` **2. 進入beeline客戶端工具** ```shell ### 進入方式1 ### [root@hadoop101 /]# beeline -- 10000 hive默認的連接端口 beeline> !connect jdbc:hive2://hadoop101:10000 -- root hdfs中Owner屬性的值，當你創建數據庫/表時為root擁有，如果直接回車默認為匿名用戶：anonymous Enter username for jdbc:hive2://hadoop101:10000: root -- 我沒有為hdfs設置密碼，直接回車即可 Enter password for jdbc:hive2://hadoop101:10000: ### 進入方式2 ### [root@hadoop101 /]# bin/beeline -u "jdbc:hive2://hadoop101:10000" -n "root" -p "" ``` **3. 查看當前使用的數據庫** ```sql 0: jdbc:hive2://hadoop101:10000> select current_database(); +----------+--+ | _c0 | +----------+--+ | default | +----------+--+ ``` **4. 查看當前數據庫的數據表** ```sql 0: jdbc:hive2://hadoop101:10000> !tables +------------+---------------+--------------------------+-------------+ | TABLE_CAT | TABLE_SCHEM | TABLE_NAME | TABLE_TYPE | +------------+---------------+--------------------------+-------------+ | | sales_rds | customer | TABLE | | | sales_rds | product | TABLE | ``` **5. 查看hive_table表的描述信息** ```sql 0: jdbc:hive2://hadoop101:10000> !column hive_table ``` **6. 執行Linux命令** ```sql 0: jdbc:hive2://hadoop101:10000> !sh ls / bin boot data ``` **7. 執行hdfs命令** ```sql 0: jdbc:hive2://hadoop101:10000> dfs -ls /; +----------------------------------------------------+--+ | DFS Output | +----------------------------------------------------+--+ | drwxr-xr-x - root supergroup 0 2021-03-09 18:59 /event | | drwxr-xr-x - root supergroup 0 2021-04-23 04:57 /hbase | | drwxrwxrwx - root supergroup 0 2021-03-04 03:33 /home | ``` **8. 執行new_sql.sql文件** ```sql 0: jdbc:hive2://hadoop101:10000> !run /opt/install/hive/mydata/new_sql.sql ``` **9. 查看Hive版本信息** ```sql 0: jdbc:hive2://hadoop101:10000> !dbinfo getDatabaseProductName Apache Hive getDatabaseProductVersion 1.1.0-cdh5.14.2 ``` **10. 退出hive客戶端，執行 !quit 或者按Ctrl+C** ```sql 0: jdbc:hive2://hadoop101:10000> !quit ``` **11. 去掉煩人的INFO信息** ```sql -- 未去掉前 0: jdbc:hive2://hadoop101:10000> show databases; INFO : Compiling command(queryId=root_20201208193434_971c2ddd-b798-40f7-9847-fb3d0675bef4): show databases INFO : Semantic Analysis Completed INFO : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:database_name, type:string, comment:from deserializer)], properties:null) INFO : Completed compiling command(queryId=root_20201208193434_971c2ddd-b798-40f7-9847-fb3d0675bef4); Time taken: 0.042 seconds INFO : Concurrency mode is disabled, not creating a lock manager INFO : Executing command(queryId=root_20201208193434_971c2ddd-b798-40f7-9847-fb3d0675bef4): show databases INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=root_20201208193434_971c2ddd-b798-40f7-9847-fb3d0675bef4); Time taken: 0.062 seconds INFO : OK +----------------+--+ | database_name | +----------------+--+ | default | | hivedb | | hivedb2 | +----------------+--+ -- 去掉INFO信息 0: jdbc:hive2://hadoop101:10000> set hive.server2.logging.operation.level=NONE; -- 去掉后 0: jdbc:hive2://hadoop101:10000> show databases; +----------------+--+ | database_name | +----------------+--+ | default | | hivedb | | hivedb2 | +----------------+--+ ``` 上面的`set`命令只在當前會話有效，要永久去掉INFO信息在`$hive/conf/hive-site.xml`中添加如下配置，然后重啟HiveServer2。 ```xml <property> <name>hive.server2.logging.operation.enabled</name> <value>true</value> </property> <property> <name>hive.server2.logging.operation.level</name> <value>NONE</value> </property> <property> <name>hive.server2.logging.operation.log.location</name> <value>/opt/log/hive/operation_logs</value> </property> ```