blob: 7870b38031d6bd72d4fb52afd780f03ea08181e0 [file] [log] [blame]
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><head><title>R: SQL Query</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link rel="stylesheet" type="text/css" href="R.css">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/highlight.js/8.3/styles/github.min.css">
<script src="https://cdnjs.cloudflare.com/ajax/libs/highlight.js/8.3/highlight.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/highlight.js/8.3/languages/r.min.js"></script>
<script>hljs.initHighlightingOnLoad();</script>
</head><body>
<table width="100%" summary="page for sql {SparkR}"><tr><td>sql {SparkR}</td><td align="right">R Documentation</td></tr></table>
<h2>SQL Query</h2>
<h3>Description</h3>
<p>Executes a SQL query using Spark, returning the result as a DataFrame.
</p>
<h3>Usage</h3>
<pre>
sql(sqlContext, sqlQuery)
</pre>
<h3>Arguments</h3>
<table summary="R argblock">
<tr valign="top"><td><code>sqlContext</code></td>
<td>
<p>SQLContext to use</p>
</td></tr>
<tr valign="top"><td><code>sqlQuery</code></td>
<td>
<p>A character vector containing the SQL query</p>
</td></tr>
</table>
<h3>Value</h3>
<p>DataFrame
</p>
<h3>Examples</h3>
<pre><code class="r">## Not run:
##D sc &lt;- sparkR.init()
##D sqlContext &lt;- sparkRSQL.init(sc)
##D path &lt;- &quot;path/to/file.json&quot;
##D df &lt;- read.json(sqlContext, path)
##D registerTempTable(df, &quot;table&quot;)
##D new_df &lt;- sql(sqlContext, &quot;SELECT * FROM table&quot;)
## End(Not run)
</code></pre>
<hr><div align="center">[Package <em>SparkR</em> version 1.6.3 <a href="00Index.html">Index</a>]</div>
</body></html>