0 - 17 of 17 tags for r

I am adding another article about connecting to Teradata through R by using the teradataR package. The following comes from my experience working on a 64-bit Teradata Express Virtual Machine (TEVM), and complements the existing forum topic at:
http://forums.teradata.com/forum/analytics/connecting-to-teradata-in-r-via-the-teradatar-package

The following batches 5 rows of data, 2 of them with errors. The JDBC FastLoad PreparedStatement.executeBatch attempts to INSERT the batched rows into a database table but throws a JDBC SQLException. Here is how to capture the chain of JDBC FastLoad SQLException messages and stack trace from JDBC FastLoad PreparedStatement.executeBatch and the chain of JDBC FastLoad SQLWarning messages and stack trace from JDBC FastLoad Connection.rollback:

The following batches 5 rows of data, 2 of them with errors. The JDBC PreparedStatement.executeBatch attempts to INSERT the batched rows into a database table but throws a JDBC SQLException. Here is how to capture the chain of JDBC SQLException error messages and stack trace:

JDBC Connection parameter LOG=DEBUG prints error, timing, informational, and debug messages to Java System.out. The following shows how the messages can be captured with R.

The implementation of dbConnect in RJDBC version 0.1-5 thru 0.2-2 (http://www.rforge.net/RJDBC/news.html) erroneously creates two (duplicate) connections. The RJDBC version currently in use can be obtained by entering citation("RJDBC") at the R command prompt.

The following shows how to select rows from a database table using JDBC FastExport, which only works with JDBC PreparedStatement.

The following shows how to batch 2 rows of data, then invoke JDBC PreparedStatement.executeBatch to INSERT them into a database table.

JDBC support has been added to teradataR version 1.0.1 which provides the ability of using the Teradata JDBC Driver through teradataR to connect to the Teradata database.  teradataR allows R users to easily connect to a Teradata database and use statistical functions directly against the Teradata system without having to extract memory into data.  For mor

 

Hi,

 

I am trying to connect to TeraData from R.

 

RStudio v0.96 (R v2.15.1)

JDBC v14.00.00.21

JDK v1.7.0_07

Mac v10.7.4

 

...

library(DBI)

library(RJDBC)

library(rJava)

Hi,
 
I am trying to run some functions in R use TeradataR. IT seems like some of the funcitons does not work or limit the number of rows to top 50. HEre is one of the error which I am receiving 

It appears that I can successfully connect to Teradata via R, but when I try to perform some function on my td.data.frame, it provides the following error after the last line of my code:

 "42S02 -3807 [NCR][ODBC Teradata Driver][Teradata Database] Object 'my_sample_table' does not exist. "

My code:

A new R package for Red Hat Linux has been added to the teradataR 1.0.1 release. This new package provides the same functionality as in the previously released Windows and Mac OS X packages, but is built for Red Hat Linux. This version was built and tested on Red Hat Linux 6.2 32-bit. (The R version for Red Hat Linux is 2.14.1)

Installing this package is the same as any normal R package; just extract it into your R library area, or use the install.packages command with the file path.

Please note, we are no longer supporting teradataR since the decision was made for Teradata to focus on our partnership with Revolution for R integration with Teradata.

An updated version of the teradataR package is now available here.

Enhancements included with this new 1.0.1 release include:

I am unable to connect using the following snippet of code:

drv = JDBC("com.teradata.jdbc.TeraDriver","./TeraJDBC/terajdbc4.jar")

conn = dbConnect(drv,"jdbc:teradata://db1/TMODE=ANSI,CHARSET=UTF8",user="user1",password="pswrd1",dbname="test_db")

I get the following error messages:

 

I've found this package while researching a connection between R and teradata. Has anyone seen documentation/reference manual for the package? Since it's a 3rd party package (vs. residing in CRAN), I haven't found a lot of people talking about/using it.

Any experience with or knowledge about the TeradataR would be appreciated!

Thanks!

Please note, we are no longer supporting teradataR since the decision was made for Teradata to focus on our partnership with Revolution for R integration with Teradata.

R  is an open source language for statistical computing and graphics. R provides a wide variety of statistical (linear and nonlinear modeling, classical statistical tests, time-series analysis, classification, clustering) and graphical techniques, and is highly extensible. This free package is designed to allow users of R to interact with a Teradata database.  Users can use many statistical functions directly against the Teradata system without having to extract the data into memory.