RAthena_options()
provides a method to change the backend. This includes changing the file parser,
whether RAthena
should cache query ids locally and number of retries on a failed api call.
RAthena_options(
file_parser,
bigint,
binary,
json,
cache_size,
clear_cache,
retry,
retry_quiet,
unload,
clear_s3_resource,
verbose
)
RAthena_options()
returns the list
of athena option environment invisibly.
Method to read and write tables to Athena, currently default to "data.table"
. The file_parser also
determines the data format returned for example "data.table"
will return data.table
and "vroom"
will return tibble
.
The R type that 64-bit integer types should be mapped to (default: "integer64"
).
Inbuilt bigint
conversion types c("integer64", "integer", "numeric", "character")
.
The R type that "binary/varbinary" types should be mapped to (default "raw"
).
Inbuilt binary conversion types c("raw", "character")
.
Attempt to converts AWS Athena data types arrays, json using jsonlite:parse_json
(default: "auto"
).
Inbuilt json conversion types c("auto", "character")
.
Custom Json parsers can be provide by using a function with data frame parameter.
Number of queries to be cached. Currently only support caching up to 100 distinct queries (default: 0
).
Clears all previous cached query metadata
Maximum number of requests to attempt (default: 5
).
This method is deprecated please use verbose instead.
set AWS Athena unload functionality globally (default: FALSE
)
Clear down AWS Athena
AWS S3
resource (s3_staging_dir
location).
This is useful for users that don't have the AWS IAM role
permissions delete
from s3_staging_dir
(default: TRUE
)
print package info messages (default: TRUE
)
library(RAthena)
# change file parser from default data.table to vroom
RAthena_options("vroom")
# cache queries locally
RAthena_options(cache_size = 5)
Run the code above in your browser using DataLab