Rstats client for ClickHouse (https://clickhouse.yandex)
Switch branches/tags
Nothing to show
Clone or download
hannesmuehleisen Merge pull request #10 from mfiorani/patch-1
Added Date datatype to dbDataType method
Latest commit 33a0b7f Nov 8, 2018

README.md

clickhouse R DBI client

This R package provides a DBI client for the ClickHouse database

Installation

  • the latest development version from github with

    devtools::install_github("hannesmuehleisen/clickhouse-r")

If you encounter a bug, please file a minimal reproducible example on github.

Usage

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)