This R package provides a DBI client for the ClickHouse database
the latest development version from github with
R
devtools::install_github("hannesmuehleisen/clickhouse-r")
If you encounter a bug, please file a minimal reproducible example on github.
library(DBI)
con <- dbConnect(clickhouse::clickhouse(), host="localhost", port=8123L, user="default", password="")
dbWriteTable(con, "mtcars", mtcars)
dbListTables(con)
dbGetQuery(con, "SELECT COUNT(*) FROM mtcars")
d <- dbReadTable(con, "mtcars")
dbDisconnect(con)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.