How to pass multiple statements into Spark SQL HiveContext
<p>For example I have few Hive HQL statements which I want to pass into Spark SQL:</p>

<pre class="lang-sql prettyprint-override"><code>set parquet.compression=SNAPPY;
create table MY_TABLE stored as parquet as select * from ANOTHER_TABLE;
select * from MY_TABLE limit 5;
</code></pre>

<p>Following doesn't work:</p>

<pre class="lang-java prettyprint-override"><code>hiveContext.sql("set parquet.compression=SNAPPY; create table MY_TABLE stored as parquet as select * from ANOTHER_TABLE; select * from MY_TABLE limit 5;")
</code></pre>

<p>How to pass the statements into Spark SQL?</p>