hive 2.1 创建表时被移动到回收站
hive> create table test (id int);
Moved: 'hdfs://mycluster/user/hive/warehouse/mybase.db/test' to trash at: hdfs://mycluster/user/hadoop/.Trash/Current
Moved: 'hdfs://mycluster/user/hive/warehouse/mybase.db/test' to trash at: hdfs://mycluster/user/hadoop/.Trash/Current
Moved: 'hdfs://mycluster/user/hive/warehouse/mybase.db/test' to trash at: hdfs://mycluster/user/hadoop/.Trash/Current
..
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:For direct MetaStore DB connections, we don't support retries at the client level.)
hive-site.xml中的配置:
<property>
<name>hive.server2.logging.operation.log.location</name>
<value>/data/hive/data/operation_logs</value>
<description>Top level directory where operation logs are stored if logging functionality is enable
d</description>
</property>
<property>
<name>hive.exec.local.scratchdir</name>
<value>/data/hive/data</value>
<description>Local scratch space for Hive jobs</description>
</property>
<property>
<name>hive.downloaded.resources.dir</name>
<value>/data/hive/data_resources</value>
<description>Temporary local directory for added resources in the remote file system.</description>
</property>
<property>
<name>hive.querylog.location</name>
<value>/data/hive/data</value>
<description>Location of Hive run time structured log file</description>
</property>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mariadb://localhost:3306/hive?create=true</value>
<description>JDBC connect string for a JDBC metastore</description>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>org.mariadb.jdbc.Driver</value>
<description>Driver class name for a JDBC metastore</description>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>hadoop</value>
<description>username to use against metastore database</description>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>hadoop</value>
<description>password to use against metastore database</description>
</property>
<property>
<name>hive.metastore.warehouse.dir</name>
<value>hdfs://mycluster/user/hive/warehouse</value>
<description>location of default database for the warehouse</description>
</property>