vertica_connect: Connect to Vertica
In cchoe/infoscout: R Functions commonly used for Data Scientists at InfoScout
Description
Usage
Arguments
Value
Examples
Description
This function creates a Vertica JDBC connection object for querying InfoScout tables directly from R.
Usage
1
vertica_connect(driver.path, user, pw)
Arguments
driver.path
Local path to the Vertica JDBC driver (.jar)
user
Database username
pw
Database password
Value
A Vertica connection object
Examples
1
2
3
driver.path = '/users/me/documents/drivers/vertica-jdbc-7.2.3-0.jar'
vertica <- vertica_connect(driver.path)
df <- dbGetQuery(vertica, 'SELECT * FROM us_tlog.d_user LIMIT 10;')
cchoe/infoscout documentation built on May 20, 2019, 5:42 p.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Description Usage Arguments Value Examples
Description
This function creates a Vertica JDBC connection object for querying InfoScout tables directly from R.
Usage
1 | vertica_connect(driver.path, user, pw)
|
Arguments
driver.path |
Local path to the Vertica JDBC driver (.jar) |
user |
Database username |
pw |
Database password |
Value
A Vertica connection object
Examples
1 2 3 | driver.path = '/users/me/documents/drivers/vertica-jdbc-7.2.3-0.jar'
vertica <- vertica_connect(driver.path)
df <- dbGetQuery(vertica, 'SELECT * FROM us_tlog.d_user LIMIT 10;')
|
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.