1凌唬、顯示數(shù)據(jù)庫(kù)
1）顯示數(shù)據(jù)庫(kù)
hive> show databases;
2）過(guò)濾顯示查詢(xún)的數(shù)據(jù)庫(kù)
hive> show databases like 'db_hive*';
OK
db_hive
db_hive_1
2、顯示數(shù)據(jù)庫(kù)信息
1）顯示數(shù)據(jù)庫(kù)信息
hive> desc database db_hive;
OK
db_hive hdfs://node1:9000/user/hive/warehouse/db_hive.db victorUSER
2）顯示數(shù)據(jù)庫(kù)詳細(xì)信息笙瑟，extended
hive> desc database extended db_hive;
OK
db_hive hdfs://node1:9000/user/hive/warehouse/db_hive.db victorUSER
3述吸、使用數(shù)據(jù)庫(kù)
hive (default)> use db_hive;
