GitHub - treasure-data/RTD: Simple R client for Treasure Data (original) (raw)

RTD

RTD is an official R client for Arm Treasure Data. It aims to make it simple to handle or connect from R to TD.

Since RTD covers only basic execution on TD, we recommend to use RPresto or RJDBC for querying.

Requirements

To upload data.frame from R, there are two options:

1. embulk
2. bulk-import

If you want to use embulk, ensure you've installed embulk and set PATH for it.

• embulk
• embulk-output-td

Install

As of version 0.4.1, RTD has been back to CRAN. You can install RTD as:

You can install via devtools::install_github for the latest development version.

install.packages("devtools") # Install devtools if needed devtools::install_github("treasure-data/RTD@v0.4.1")

Or, you can use install-github.me instead like:

source("https://install-github.me/treasure-data/RTD@v0.4.1")

Example

See also RTD_example.Rmd or RPubs.

library(RTD)

client <- Td(apikey=Sys.getenv("TD_API_KEY"), endpoint=Sys.getenv("TD_API_SERVER"))

Show list of databases

list_databases(client)

Create database

create_database(client, "test")

Craete table

create_table(client, "test", "example")

Delete table

delete_table(client, "test", "example")

Upload data.frame. Target database and table will be created automatically.

td_upload(client, "test", "mtcars", mtcars)

Drop database

delete_database(client, "test")