ClickhouseDriver-class | R Documentation |
This driver never needs to be unloaded and hence dbUnload()
is a
null-op.
clickhouse()
## S4 method for signature 'ClickhouseDriver'
show(object)
## S4 method for signature 'ClickhouseDriver'
dbGetInfo(dbObj, ...)
## S4 method for signature 'ClickhouseDriver'
dbIsValid(dbObj, ...)
## S4 method for signature 'ClickhouseDriver'
dbUnloadDriver(drv, ...)
loadConfig(CONFIG_PATHS, DEFAULT_PARAMS, pre_config)
## S4 method for signature 'ClickhouseDriver'
dbConnect(
drv,
host = "localhost",
port = 9000,
dbname = "default",
user = "default",
password = "",
compression = "lz4",
config_paths = c("./RClickhouse.yaml", "~/.R/RClickhouse.yaml",
"/etc/RClickhouse.yaml"),
Int64 = c("integer64", "integer", "numeric", "character"),
toUTF8 = TRUE,
...
)
## S4 method for signature 'ClickhouseDriver'
dbDataType(dbObj, obj, ...)
drv |
ClickHouse database driver. |
CONFIG_PATHS |
a list of configuration paths |
DEFAULT_PARAMS |
a list of configuration defaults |
pre_config |
initialization set |
host |
name of the host on which the database is running. |
port |
port on which the database is listening. |
dbname |
name of the default database. |
user |
name of the user to connect as. |
password |
the user's password. |
compression |
the compression method for the connection (lz4 by default). |
config_paths |
paths where config files are searched for; order of paths denotes hierarchy (first string has highest priority etc.). |
Int64 |
The R type that 64-bit integer types should be mapped to, default is [bit64::integer64], which allows the full range of 64 bit integers. |
toUTF8 |
logical, should character variables be converted to UTF-8. Default is TRUE. |
a merged configuration
A database connection.
library(DBI)
RClickhouse::clickhouse()
## Not run:
conn <- dbConnect(RClickhouse::clickhouse(), host="localhost")
## End(Not run)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.