Amazon Athena JDBC Driver Wrapper Supporting the 'metis' Package
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

README.md 2.6KB

3 years ago
1 year ago
1 year ago
1 year ago
2 years ago
1 year ago
3 years ago
2 years ago
3 years ago
1 year ago
3 years ago
1 year ago
1 year ago
2 years ago
3 years ago
1 year ago
2 years ago
3 years ago
1 year ago
1 year ago
1 year ago
3 years ago
2 years ago
3 years ago
1 year ago
3 years ago
1 year ago
2 years ago
7 months ago
2 years ago
1 year ago
7 months ago
1 year ago
1 year ago
1 year ago
7 months ago
2 years ago
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990
  1. [![Travis-CI Build
  2. Status](https://travis-ci.org/hrbrmstr/metis-jars.svg?branch=master)](https://travis-ci.org/hrbrmstr/metis-jars)
  3. [![Coverage
  4. Status](https://codecov.io/gh/hrbrmstr/metis-jars/branch/master/graph/badge.svg)](https://codecov.io/gh/hrbrmstr/metis-jars)
  5. [![CRAN\_Status\_Badge](http://www.r-pkg.org/badges/version/metis-jars)](https://cran.r-project.org/package=metis.jars)
  6. # metis.jars
  7. Amazon Athena JDBC Driver Wrapper Supporting the ‘metis’ Package
  8. ## Description
  9. Contents of the Amazon Athena JDBC Driver
  10. <https://docs.aws.amazon.com/athena/latest/ug/connect-with-jdbc.html>
  11. provided to support functions in the ‘metis’ package. Version number
  12. reflects the version number of the included ‘JAR’ file.
  13. ## IMPORTANT
  14. Until a release of ‘rJava’ newer than ‘0.9.10’ is on CRAN signals sent
  15. from interrupting Athena JDBC calls crash the R interpreter. You
  16. therefore need to set the `-Xrs` option to avoid signals being passed on
  17. to the JVM owner. That has to be done *before* `rJava` is loaded so you
  18. either need to remember to put it at the top of all scripts *or* stick
  19. this in your local `~/.Rprofile` and/or sitewide `Rprofile`:
  20. ``` r
  21. options(
  22. "java.parameters" = c(getOption("java.parameters", default = NULL), "-Xrs")
  23. )
  24. ```
  25. ## What’s Inside The Tin?
  26. The following functions are implemented:
  27. - `athena_supported_types`: Retrieve the current supported type names
  28. in Athena
  29. - `metis_jar_path()` : Retrieve the fully-qualified path to the
  30. included Athena JAR file
  31. - `simba_driver_version`: Retrieve the version of the Simba Athena
  32. JDBC driver included with the package
  33. ## Installation
  34. ``` r
  35. devtools::install_git("https://git.sr.ht/~hrbrmstr/metis-jars")
  36. # OR
  37. devtools::install_gitlab("hrbrmstr/metis-jars")
  38. # OR
  39. devtools::install_github("hrbrmstr/metis-jars")
  40. ```
  41. ## Usage
  42. ``` r
  43. library(metis.jars)
  44. # current verison
  45. packageVersion("metis.jars")
  46. ```
  47. ## [1] '2.0.9'
  48. ``` r
  49. simba_driver_version()
  50. ```
  51. ## [1] "02.00.09.1018"
  52. ``` r
  53. athena_supported_types()
  54. ```
  55. ## [1] "BOOLEAN" "TINYINT" "SMALLINT" "INT" "INTEGER" "BIGINT" "REAL" "FLOAT" "DOUBLE"
  56. ## [10] "DECIMAL" "DATE" "TIMESTAMP" "BINARY" "VARBINARY" "CHAR" "VARCHAR" "STRING" "ARRAY"
  57. ## [19] "MAP" "ROW" "STRUCT"
  58. ``` r
  59. metis_jar_path()
  60. ```
  61. ## [1] "/Library/Frameworks/R.framework/Versions/3.6/Resources/library/metis.jars/java/AthenaJDBC42_2.0.9.jar"
  62. ## Code of Conduct
  63. Please note that this project is released with a [Contributor Code of
  64. Conduct](CONDUCT.md). By participating in this project you agree to
  65. abide by its terms.