赞
踩
Hive对应的database 和 table都是对应分布式文件系统的一个路径:
(-) | 默认数据库default | 非default数据库 |
---|---|---|
数据库位置 | (-) | /user/hive/warehouse/数据库名字.db |
新创建的表位置 | /user/hive/warehouse/表名 | /user/hive/warehouse/数据库名字.db/表名 |
mysql> use myhive; // 在hive-site.xml配置的mysql数据库库名。 mysql> show tables; +-------------------------------+ | Tables_in_myhive | +-------------------------------+ | aux_table | | bucketing_cols | | cds | | columns_v2 | | compaction_queue | | completed_compactions | | completed_txn_components | | ctlgs | | database_params【存放元数据参数配置】 | | db_privs | | dbs 【存放metadata元数据】 | | delegation_tokens | | func_ru |
语法:
CREATE [REMOTE] (DATABASE|SCHEMA) [IF NOT EXISTS] database_name
[COMMENT database_comment]
[LOCATION hdfs_path]
[MANAGEDLOCATION hdfs_path]
[WITH DBPROPERTIES (property_name=property_value, …)];[] :可有可无
(DATABASE|SCHEMA) N选1操作
[xiaofeng@maggie101 ~]$ beeline.sh
// 切换到hiveserver2下面创建myhive_test1.db数据库
0: jdbc:hive2://localhost:10000/> Create database myhive_test1;
// 查看/user/hive/warehouse/路径下的文件
[xiaofeng@maggie101 ~]$ hadoop fs -ls /user/hive/warehouse/
Found 3 items
drwxr-xr-x - xiaofeng supergroup 0 2022-11-26 00:17 /user/hive/warehouse/myhive_test1.db
drwxr-xr-x - xiaofeng supergroup 0 2022-11-25 01:51 /user/hive/warehouse/test.db
drwxr-xr-x - xiaofeng supergroup 0 2022-11-25 11:04 /user/hive/warehouse/test_user
0: jdbc:hive2://localhost:10000/> Create database myhive_test1;
Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Database myhive_test1 already exists (state=42000,code=1)
0: jdbc:hive2://localhost:10000/> Create database IF NOT EXISTS myhive_test1;
No rows affected (0.03 seconds)
0: jdbc:hive2://localhost:10000/> Create database myhive_test3 LOCATION '/user/hive/myhive_test3';
Create database myhive_test4 COMMENT 'maggie创建的Hive测试数据库';
Create database myhive_test5 COMMENT 'maggie创建的Hive测试数据库5' WITH DBPROPERTIES ('cretor'='maggie', 'date'='2022-11-26');
0: jdbc:hive2://localhost:10000/> show databases; +----------------+ | database_name | +----------------+ | default | | myhive_test1 | | myhive_test2 | | myhive_test3 | | myhive_test4 | | myhive_test5 | | test | +----------------+ 7 rows selected (0.088 seconds) 0: jdbc:hive2://localhost:10000/> show databases like 'myhive*'; +----------------+ | database_name | +----------------+ | myhive_test1 | | myhive_test2 | | myhive_test3 | | myhive_test4 | | myhive_test5 | +----------------+ 5 rows selected (0.047 seconds)
0: jdbc:hive2://localhost:10000/> desc database myhive_test1;
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。