**1. 創建 hivebook 數據庫** ```sql 0: jdbc:hive2://hadoop101:10000> create database hivebook; 0: jdbc:hive2://hadoop101:10000> create database if not exists hivebook; -- location 指定數據在hdfs上的存儲位置 0: jdbc:hive2://hadoop101:10000> create database if not exists hivebook location '/home/hive'; ``` **2. 選用 hivebook 數據庫** ```sql 0: jdbc:hive2://hadoop101:10000> use myhivebook; ``` **3. 查看 hivebook 數據庫的描述** ```sql -- （1）方式1 0: jdbc:hive2://hadoop101:10000> desc database hivebook; +-----------+----------+----------------------------------------------------+-------------+-------------+-------------+--+ | db_name | comment | location | owner_name | owner_type | parameters | +-----------+----------+----------------------------------------------------+-------------+-------------+-------------+--+ | hivebook | | hdfs://hadoop101:9000/home/hadoop/hive/warehouse/hivebook.db | root | USER | | +-----------+----------+----------------------------------------------------+-------------+-------------+-------------+--+ -- （2）方式2 0: jdbc:hive2://hadoop101:10000> describe database hivebook; +-----------+----------+----------------------------------------------------+-------------+-------------+-------------+--+ | db_name | comment | location | owner_name | owner_type | parameters | +-----------+----------+----------------------------------------------------+-------------+-------------+-------------+--+ | hivebook | | hdfs://hadoop101:9000/home/hadoop/hive/warehouse/hivebook.db | root | USER | | +-----------+----------+----------------------------------------------------+-------------+-------------+-------------+--+ -- （3）方式3 0: jdbc:hive2://hadoop101:10000> desc database extended hivbook; +-----------+----------+----------------------------------------------------+-------------+-------------+-------------+--+ | db_name | comment | location | owner_name | owner_type | parameters | +-----------+----------+----------------------------------------------------+-------------+-------------+-------------+--+ | hivebook | | hdfs://hadoop101:9000/home/hadoop/hive/warehouse/hivebook.db | root | USER | | +-----------+----------+----------------------------------------------------+-------------+-------------+-------------+--+ ``` **4. 改變 hivebook 數據庫的擁有者為 root** ```sql 0: jdbc:hive2://hadoop101:10000> alter database hivebook set owner user root; ``` 改變前為anonymouns擁有  改變后為root擁有。 <br/> **5. 刪除 hivebook2 數據庫** ```sql -- （1）方式1刪除：當數據庫為空時才能刪除 0: jdbc:hive2://hadoop101:10000> drop database if exists hivebook2; -- （2）方式2刪除：無論數據庫是否為空，強制刪除 0: jdbc:hive2://hadoop101:10000> drop database if exists hivebook2 cascade; ``` **6. 模糊查詢數據庫** ```sql 0: jdbc:hive2://hadoop101:10000> show databases like 'hive*'; +----------------+--+ | database_name | +----------------+--+ | hivebook | | hivedb | | hivedb2 | +----------------+--+ ``` **7. 查看當前所使用的數據庫** ```sql 0: jdbc:hive2://hadoop101:10000> select current_database(); +-----------+--+ | _c0 | +-----------+--+ | hivebook | +-----------+--+ ```