starting hive gave me exception

Question

Hi everybody I just completed hive and apache derby installation and i started schematool successfuly but when i type  bin/hive
it gaves me the following exception

Exception in thread "main" java.lang.RuntimeException: Couldn't create directory /user/local/hive/tmp/java/f357efd5-2a26-47d5-bd43-d74f0a858e1e_resources

    at org.apache.hadoop.hive.ql.util.ResourceDownloader.ensureDirectory(ResourceDownloader.java:116)
    at org.apache.hadoop.hive.ql.util.ResourceDownloader.<init>(ResourceDownloader.java:47)
    at org.apache.hadoop.hive.ql.session.SessionState.<init>(SessionState.java:401)
    at org.apache.hadoop.hive.ql.session.SessionState.<init>(SessionState.java:372)
    at org.apache.hadoop.hive.cli.CliSessionState.<init>(CliSessionState.java:60)
    at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:708)
    at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:686)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.apache.hadoop.util.RunJar.run(RunJar.java:239)
    at org.apache.hadoop.util.RunJar.main(RunJar.java:153)

Answer 1

Hi@Hans,

You may got this error, if you didn't set the below properties in your hive-site.xml file.

  <property>
    <name>hive.downloaded.resources.dir</name>
    <value>${system:java.io.tmpdir}/${hive.session.id}_resources</value>
  </property>

  <property>
    <name>hive.metastore.warehouse.dir</name>
    <value>hdfs://user/hive/warehouse</value>
  </property>

Also make sure you have /user/hive/warehouse folder in hdfs cluster.

$ hdfs dfs -mkdir /user/hive/warehouse
$ hdfs dfs -chmod g+w /tmp
$ hdfs dfs -chmod g+w /user/hive/warehouse