Hive 查找属性

可以使用如下命令查找特定的属性配置

hive -S -e "set" | grep warehouse

[hadoop@s201 ~]$hive -S -e "set" | grep warehouse
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/soft/apache-hive-2.1.0-bin/lib/log4j-slf4j-impl-2.4.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/soft/hbase-1.2.6/lib/phoenix-4.10.0-HBase-1.2-client.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/soft/hadoop-2.7.3/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
hive.metastore.warehouse.dir=/user/hive/warehouse
hive.warehouse.subdir.inherit.perms=true

说明hive创建的表元数据，默认的存储目录是/user/hive/warsehouse 目录下.

当然，用户创建hive数据库时，可以通过如下命令修改这个默认的配置

create  database ts  location  '/user/my'  

hive> create database ts
    > location '/user/my';
OK

此时，hdfs 目录会出现 my 这个目录.