| <!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 <- sparkR.init() |
| ##D sqlContext <- sparkRSQL.init(sc) |
| ##D path <- "path/to/file.json" |
| ##D df <- read.json(sqlContext, path) |
| ##D registerTempTable(df, "table") |
| ##D new_df <- sql(sqlContext, "SELECT * FROM table") |
| ## 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> |