配置单元中不显示表

fzsnzjdm  于 2021-05-29  发布在  Hadoop
关注(0)|答案(0)|浏览(219)

我面临的问题是:每次登录到hivecli时,所有创建的数据库和表都不见了。我可以在hadoopgui的仓库目录中看到它们。然而,这并没有通过cli反映出来。请帮我解决这个问题。
我正在使用hadoop-1.0.4和hive-1.2.1。我已经按照文档在hive-site.xml中配置了(warehouse dir、temp dir、derby metastore dir)。

hive-site.xml中的属性

<property>
    <name>hive.exec.scratchdir</name>
    <value>/tmp/hive</value>
    <description>HDFS root scratch dir for Hive jobs which gets created with write all (733) permission. For each connecting user, an HDFS scratch dir: ${hive.exec.scratchdir}/&lt;username&gt; is created, with ${hive.scratch.dir.permission}.</description>
</property>

  <property>
    <name>hive.exec.local.scratchdir</name>
    <value>/tmp/hadoop/hive</value>
    <description>Local scratch space for Hive jobs</description>
  </property>

  <property>
    <name>hive.downloaded.resources.dir</name>
     <value>/tmp/hadoop/hive</value>
    <description>Temporary local directory for added resources in the remote file system.</description>
  </property>

  <property>
    <name>hive.scratch.dir.permission</name>
    <value>700</value>
    <description>The permission for the user specific scratch directories that get created.</description>
  </property>

  <property>
    <name>hive.metastore.warehouse.dir</name>
    <value>/user/hive/warehouse</value>
    <description>location of default database for the warehouse</description>
  </property>

  <property>
    <name>hive.metastore.uris</name>
    <value/>
    <description>Thrift URI for the remote metastore. Used by metastore client to connect to remote metastore.</description>
  </property>

  <property>
    <name>hive.metastore.connect.retries</name>
    <value>3</value>
    <description>Number of retries while opening a connection to metastore</description>
  </property>

  <property>
    <name>javax.jdo.option.ConnectionURL</name>
 <value>jdbc:derby:;databaseName=/usr/hadoop/metastore_db;create=true</value>
    <description>JDBC connect string for a JDBC metastore</description>
  </property>

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题