Re: Hive metastore using Oracle

2015-07-13 Thread Jason Dere
Looks like it's having trouble with the hive.exec.local.scratchdir setting (which defaults to "${system:java.io.tmpdir}/${system:user.name}"). Is variable substitution disabled (hive.variable.substitute)? You might want to try explicitly setting hive.exec.local.scratchdir when running on the co

Hive metastore using Oracle

2015-07-13 Thread Garry Chen
Hi All, I am trying to setup a remote metastore for Hive using Oracle. The following is my steps and error message when try to start hive. Please help and thank you very much. Garry 1. Create a hive user in Oracle instance 2. Run hive-schema-0.14.0.oracle.sql as