https://community.cloudera.com/t5/Support-Questions/query-hive-tables-with-spark-sql/m-p/145380#M107948 <P><A rel="user" href="https://community.cloudera.com/users/3093/oscaricardo4.html" nodeid="3093">@Jan J</A> </P><P>First you need to Create hive-site in the Spark conf directory:</P><P>As user root, create the file <CODE>SPARK_HOME/conf/hive-site.xml</CODE>. Edit the file to contain only the following configuration setting:</P><PRE>&lt;configuration&gt; &lt;property&gt; &lt;name&gt;hive.metastore.uris&lt;/name&gt; &lt;!--Make sure that &lt;value&gt; points to the Hive Metastore URI in your cluster --&gt; &lt;value&gt;thrift://sandbox.hortonworks.com:9083&lt;/value&gt; &lt;description&gt;URI for client to contact metastore server&lt;/description&gt; &lt;/property&gt; &lt;/configuration&gt; </PRE><H4>Set SPARK_HOME</H4><P>If you haven’t already, make sure to set <CODE>SPARK_HOME</CODE> before proceeding: </P><P>export SPARK_HOME=/usr/hdp/current/spark-client</P><H4>Create Hive Context</H4><P>At a <CODE>scala&gt;</CODE> REPL prompt type the following:</P><PRE>valhiveContext=neworg.apache.spark.sql.hive.HiveContext(sc) </PRE><H4>Create Hive Table</H4><PRE>hiveContext.sql("CREATE TABLE IF NOT EXISTS TestTable (key INT, value STRING)")</PRE><H4>Load example KV value data into Table</H4><PRE>hiveContext.sql("LOAD DATA LOCAL INPATH 'examples/src/main/resources/kv1.txt' INTO TABLE TestTable")</PRE><P>scala&gt; hiveCTX.hql("SHOW TABLES").collect().foreach(println) </P><P>scala&gt;hCTX.hql("DESCRIBE raw_users").collect().foreach(println)</P> Tue, 29 Mar 2016 23:46:19 GMT azeltov 2016-03-29T23:46:19Z