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:

install.packages("RTD")

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")