title: How to connect to remote hive server from spark
body: <p>I'm running spark locally and want to to access Hive tables, which are located in the remote Hadoop cluster.</p>
  
  <p>I'm able to access the hive tables by lauching beeline under SPARK_HOME</p>
  
  <pre><code>[ml@master spark-2.0.0]$./bin/beeline 
  Beeline version 1.2.1.spark2 by Apache Hive
  beeline&gt; !connect jdbc:hive2://remote_hive:10000
  Connecting to jdbc:hive2://remote_hive:10000
  Enter username for jdbc:hive2://remote_hive:10000: root
  Enter password for jdbc:hive2://remote_hive:10000: ******
  SLF4J: Class path contains multiple SLF4J bindings.
  SLF4J: Found binding in [jar:file:/home/ml/spark/spark-2.0.0/jars/slf4j-log4j12-1.7.16.jar!/org/slf4j/impl/StaticLoggerBinder.class]
  SLF4J: Found binding in [jar:file:/usr/hadoop/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
  SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
  SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
  16/10/12 19:06:39 INFO jdbc.Utils: Supplied authorities: remote_hive:10000
  16/10/12 19:06:39 INFO jdbc.Utils: Resolved authority: remote_hive:10000
  16/10/12 19:06:39 INFO jdbc.HiveConnection: Will try to open client transport with JDBC Uri: jdbc:hive2://remote_hive:10000
  Connected to: Apache Hive (version 1.2.1000.2.4.2.0-258)
  Driver: Hive JDBC (version 1.2.1.spark2)
  Transaction isolation: TRANSACTION_REPEATABLE_READ
  0: jdbc:hive2://remote_hive:10000&gt;
  </code></pre>
  
  <p>how can I access the remote hive tables programmatically from spark?</p>