title: Run Spark with build-in Hive and Configuring a remote PostgreSQL database for the Hive Metastore
body: <p>I am running Spark v1.0.1 with build-in Hive (Spark install with SPARK_HIVE=true sbt/sbt assembly/assembly)</p>
  <p>I also config Hive to store Metastore in PostgreSQL database as instruction:</p>
  <p><a href="http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH4/4.2.0/CDH4-Installation-Guide/cdh4ig_topic_18_4.html" rel="nofollow noreferrer">http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH4/4.2.0/CDH4-Installation-Guide/cdh4ig_topic_18_4.html</a></p>
  <p>I could config Hive (not build-in with Spark) to use PostgreSQL but I don't know how to get it work with Hive in Spark</p>
  <p>In the instruction, I see that I need to put or link postgresql-jdbc.jar to hive/lib so that Hive could include the postgresql-jdbc when it run</p>
  <pre><code>$ sudo yum install postgresql-jdbc
  $ ln -s /usr/share/java/postgresql-jdbc.jar /usr/lib/hive/lib/postgresql-jdbc.jar
  </code></pre>
  <p>With Build-in Hive in Spark, where should I put the postgresql-jdbc.jar to get it work?</p>