SparkR (version 2.1.2)

sql: SQL Query

Description

Executes a SQL query using Spark, returning the result as a SparkDataFrame.

Usage

# S3 method for default
sql(sqlQuery)

Arguments

sqlQuery

A character vector containing the SQL query

Value

SparkDataFrame

Examples

# NOT RUN {
sparkR.session()
path <- "path/to/file.json"
df <- read.json(path)
createOrReplaceTempView(df, "table")
new_df <- sql("SELECT * FROM table")
# }