我面临的问题是:每次登录HIVE CLI时,所有创建的数据库和表都消失了 . 我可以在Hadoop GUI的仓库目录中看到它们 . 然而,同样没有通过CLI反映出来 . 请帮我解决这个问题 .

我正在使用Hadoop - 1.0.4和Hive - 1.2.1 . 我根据文档配置了(仓库目录,临时目录,德比Metastore dir)inhive-site.xml .

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>