GitPlanet

Cheap and reliable Node.js hosting starts at $3/month, and $1/month static HTML hosting

Created with love in Canada, visit hostnodejs.com today

Feel like to post an Ad? Learn Details
All Projects → exasol → r-exasol

exasol / r-exasol

Licence: BSD-3-Clause license
The EXASOL package for R provides an interface to the EXASOL database.

Programming Languages

C++
36643 projects - #6 most used programming language
r
7636 projects
python
139335 projects - #7 most used programming language
shell
77523 projects
M4
1887 projects
Dockerfile
14818 projects

Labels

driverr-languageexasolexasol-integration

Projects that are alternatives of or similar to r-exasol

spark-connector
A connector for Apache Spark to access Exasol
Stars: ✭ 13 (-40.91%)
Mutual labels:  exasol, exasol-integration
virtual-schemas
Entry point repository for the EXASOL Virtual Schemas
Stars: ✭ 24 (+9.09%)
Mutual labels:  exasol, exasol-integration
hadoop-etl-udfs
The Hadoop ETL UDFs are the main way to load data from Hadoop into EXASOL
Stars: ✭ 17 (-22.73%)
Mutual labels:  exasol, exasol-integration
sqlalchemy exasol
SQLAlchemy dialect for EXASOL
Stars: ✭ 34 (+54.55%)
Mutual labels:  exasol, exasol-integration
embedded-sht
Embedded SHT Drivers for Sensirion Temperature and Humidity Sensors - Download the Zip Package from the Release Page
Stars: ✭ 53 (+140.91%)
Mutual labels:  driver
athenadriver
A fully-featured AWS Athena database driver (+ athenareader https://github.com/uber/athenadriver/tree/master/athenareader)
Stars: ✭ 116 (+427.27%)
Mutual labels:  driver
dragon
A host-based framework that transparently extends the GPU addressable global memory space beyond the host memory using NVM-backed data pointers
Stars: ✭ 49 (+122.73%)
Mutual labels:  driver
mongosh
The MongoDB Shell
Stars: ✭ 215 (+877.27%)
Mutual labels:  driver
faunadb-csharp
C# driver for FaunaDB
Stars: ✭ 55 (+150%)
Mutual labels:  driver
stm32f7-qspi
QSPI serial flash driver for the STM32F7xx family of controllers
Stars: ✭ 14 (-36.36%)
Mutual labels:  driver
Driver-Collider
Blocks drivers from loading by using a name collision technique. #nsacyber
Stars: ✭ 40 (+81.82%)
Mutual labels:  driver
iomemory-vsl4
Updated Fusion-io iomemory VSL4 Linux (version 4.3.7) driver for recent kernels.
Stars: ✭ 42 (+90.91%)
Mutual labels:  driver
Kaggle
Kaggle Kernels (Python, R, Jupyter Notebooks)
Stars: ✭ 26 (+18.18%)
Mutual labels:  r-language
lr1110 driver
Driver for LR1110 radio
Stars: ✭ 23 (+4.55%)
Mutual labels:  driver
rtl8822bu
RTL8822BU Wireless Driver for Linux
Stars: ✭ 59 (+168.18%)
Mutual labels:  driver
grabbitmq
A high-level RabbitMQ driver for Golang.
Stars: ✭ 16 (-27.27%)
Mutual labels:  driver
laravel-sybase
Connection and Laravel Eloquent driver for Sybase
Stars: ✭ 29 (+31.82%)
Mutual labels:  driver
sx126x driver
Driver for SX126x radio
Stars: ✭ 41 (+86.36%)
Mutual labels:  driver
mongodb-php-lib
MongoDB driver library for PHP
Stars: ✭ 16 (-27.27%)
Mutual labels:  driver
r-whatsapp-analysis-parte1
Análisis de texto y visualización de datos con R, de conversaciones de WhatsApp, primer parte. Uso de librería rwhatsapp.
Stars: ✭ 22 (+0%)
Mutual labels:  r-language
View All Similar Projects ➔

R Interface & SDK for the EXASOL Database

Build Status

Please note that this is an open source project which is officially supported by Exasol. For any question, you can contact our support team.

Description

The Exasol R Package offers interface functionality such as connecting to, querying and writing into an Exasol Database (version 5 onwards). It is optimized for fast reading & writing from and to a multinode cluster. Implemented are DBI compliant methods for database access, querying and modification. The package integrates with Exasol's in-DB R UDF capabilities, which allows to deploy and execute R code dynamically from an R application running on a client.

Exasol is an in-memory RDBMS that runs in a MPP cluster (shared-nothing) environment. Leading the TPC-H benchmark, it is considered the fastest analytical data warehouse available.

The community edition can be downloaded for free from the Exasol Community Portal.

Status

The package gets tested in Github against 4.0, 4.1 and 4.2 (and 3.5/3.6 for Linux!). For R 3.6 and earlier, an older RODBC package is necessary, the newer versions (1.3-17 and upwards) only support R 4.0. You can use the remotes package to install specific versions of RODBC. The packages DBI 0.3.1 and a fork of DBItest 1.0-1 are not the current versions. The Exasol R package may however work with DBI 0.4.1, but until this is resolved the fitting older packages can be loaded from here:

For Windows only:

  • As this package uses C++14 code, it needs at least RTools >= 4.0.0. Hence, it works only on R >= 4.0.0.
  • Please note that the version of RTools must match the installed version of R (RTools 4.2 for R >= 4.2, RTools 4.0 for R4.0/4.1), check https://cran.r-project.org/bin/windows/Rtools/ for further information

The low-level methods such as regards exa.readData, exa.writeData and exa.createScript may work as expected, so should the DBI connection methods (dbConnect, etc.; all tests passed). DBI querying methods also get close to being production ready.

Following test were implemented:

  • Unit tests for the C++ high speed data transfer layer
  • Integration test (which require a local Exasol db running, and therefore are not activated by default). These leverage the DBItest package.

dplyr methods have been moved to a separate package.

Known issues

  1. ODBC drivers 7.1.1 & 7.1.2 under MacOsX BigSur have a dependency issue. If you have problems under MacOsX and see an error message like ...libexaodbc-io418sys.dylib not found, please update to the latest ODBC driver, version 7.1.3 works fine.
  2. The Exasol ODBC driver does not support encoding of curly braces for passwords in the connection string: You can use curly braces to encode semicolons in passwords in the connection string, like ...,PWD={he;llo},.... However, passwords like he{{;o are currently not supported.

Getting started

Prerequisites

  1. Install developer extensions for R to be able to build from sources

    For Windows: Install Rtools matching your version of R from here, but at least version 4.0.0.

    For Linux: Install the R-base-devel (RPM) or r-base-dev (Debian) package.

    For MacOsX: If you install R via Homebrew, use the CASK version: brew install --cask r. (The normal version, brew install r will only install packages via source, which will require additional dependencies)

    The packages might change over time, so generally you can go to the official R-project website download section for your OS to find the package that are needed to build packages.

  2. Make sure you have ODBC and Exasol ODBC installed and configured on your system. Go to the download page and select your Exasol version in the left menu. Then scroll down to 'Download ODBC Driver' and choose the appropriate version.

    Once installed, we recommend to create a DSN pointing to your database instance. Read the README of Exasol's ODBC driver package for details.

    Important: Since v6.1.0 the Exasol ODBC driver for Linux and MacOsX are not bundled anymore in r-exasol and you need to configure properly the ODBC driver on your system. If you do not indicate a DSN calling dbConnect, r-exasol will look for a Data Source named "EXASolution Driver" and you must have the respective driver configured properly, for example the following line in your /etc/odbcinst.ini:

    [EXASolution Driver]
Driver=/usr/lib/libexaodbc-uo2214lv2.so

    (This change does not affect Windows: Under Windows the ODBC driver already had to be configured on previous versions.)

    Linux

    On Linux, you also need to install the development files for ODBC. Therefore please install unixodbc-devel (RPM) or unixodbc-dev (Debian) package.

    MacOsX

    On MacOsX you can install unixodbc with Homebrew: brew install unixodbc

  3. The R package devtools must be available as it contains the install_github() method and the things needed to build the package.

    You can install it in R with: install.packages("devtools"). If you followed step 1., this installation should work on Linux/Windows. Under MacOsX you might need to install additional dependencies, please check the devtools page

  4. OpenSSL For Windows: The package downloads the required DLL's during the installation process.

    For Linux: Install using the common package manager, for example: apt install libssl-dev

    For MacOsX: Install via brew: brew install openssl.

  5. Install the necessary dependencies, such as RODBC or the DBI packages. For the versions of these package, checkout the section Status. Have a look into the Github Actions Docker, if you look for an example, how to install the necessary dependencies.

Installation

To load the Exasol package from GitHub and have R compile and build the package for use:

devtools::install_github("EXASOL/r-exasol")

Loading the package

To use the package import it as follows:

library(exasol)

Use

devtools::install_github("exasol/r-exasol")
library(exasol)

# display package documentation with examples for each method
?exasol
# display documentation of individual commands with Exasol-specific parameters
?dbConnect

# connect to Exasol DB with an ODBC DSN
con <- dbConnect("exa", dsn="ExaSolo", schema="test")
# OR connect to Exasol DB running on default port (8563) with a hostname, default 'sys' user and default schema ('SYS'), using an encryption channel
con <- dbConnect("exa", exahost = "<hostname>:8563", uid = "sys", pwd = "<password>", encryption = "Y")

# list all tables in Exasol (returns a character vector).
dbListTables(con)

# send a query and read the result into a data.frame
df <- dbGetQuery(con, "SELECT * FROM test.mytab")

#send a query and return a result set handler, then fetch 2 rows
res <- dbSendQuery(con, "SELECT * FROM test.mytab")
df <- dbFetch(res, 2)

# disconnect
dbDisconnect(con)

Documentation

The package comes with documentation accessible from R via the command ?exasol.

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].