Description Usage Arguments Details See Also Examples
Read Treasure Data data from Presto via api-presto gateway
1 | spark_execute_td_presto(sc, source, query, options = list())
|
sc |
A |
source |
Data base name of the table on TD. Example: "sample_datasets" |
query |
A SQL to execute |
options |
A list of strings with additional options. |
You can execute queries to TD through td-spark. You have to set spark.td.apikey
,
spark.serializer
appropreately.
Other Spark serialization routines: spark_read_td_presto
,
spark_read_td_query
,
spark_read_td
, spark_write_td
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | ## Not run:
library(dplyr)
config <- spark_config()
config$spark.td.apikey <- Sys.getenv("TD_API_KEY")
config$spark.serializer <- "org.apache.spark.serializer.KryoSerializer"
config$spark.sql.execution.arrow.enabled <- "true"
sc <- spark_connect(master = "local", config = config)
spark_execute_td_presto(sc,
"sample_datasets",
"create table if not exists orders (key bigint, status varchar, price double)")
## End(Not run)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.