|
|
|
The RJDBC package enables an R application to use the Teradata JDBC Driver to access the Teradata Database.
,
17 Jun 2016
|
|
Aster R is easy for the intermediate R user to pick up and quickly begin data science on enterprise-level datasets.
,
16 May 2016
|
|
|
|
|
Overview This article describes how to combine exploratory analytics and operational analytics within the Teradata Unified Data architecture (UDA). The UDA is a logical and physical architecture that adds a data lake platform to complement the Teradata Integrated Data Warehouse. In the Teradata advocated solution, the data lake platform can either be Hadoop or a Teradata Integrated Big Data Platform optimized for storage and processing of big data. Query Grid is an orchestration mechanism that supports seamless integration of multiple types of purpose built analytic engines within the UDA.
,
20 Apr 2016
|
|
|
My company is running an R-Studio Server Pro on a Red Hat Linix 6 platform (64bit) and a Teradata 14 RDBMS. When trying to connect via RJDBC, I get an error that seems to be well known in the forums, but the standard recipes for resolving the issues don't help. Here is how I connect to the Teradata DB:
,
28 Aug 2015
| 3 comments
|
|
|
Analysts have deep knowledge of the procedures and reports their desktop tools currently use and produce, but can stumble when they need to get better insights fast on “too big” data.
,
15 May 2015
|
|
|
On the Teradata Connections website, a new group has been created to foster and encourage discussion, ideas exchange and help with issues on the topic of R and Python Analytics with the SCRIPT Table Operator. Visit:
,
17 Apr 2015
|
|
|
The R and Python programming languages are very popular for statistical and mathematical tasks, and notable examples of open source software for analytics.
,
03 Apr 2015
| 2 comments
|
|
|
Where can I get theAster ncluster odbc driver for mac os. I need the driver for RODBC connectivity.
,
21 Jan 2015
|
|
|
Where can I get theAster ncluster odbc driver for mac os. I need the driver for RODBC connectivity.
,
21 Jan 2015
| 1 comment
|
|
|
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:
,
28 Feb 2014
| 1 comment
|
|
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:
,
16 Dec 2013
| 2 comments
|
|
|
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:
,
13 Dec 2013
|
|
|
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.
,
06 Dec 2013
|
|
|
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.
,
04 Dec 2013
|
|
|
The following shows how to select rows from a database table using JDBC FastExport, which only works with JDBC PreparedStatement.
,
03 Dec 2013
|
|
|
The following shows how to batch 2 rows of data, then invoke JDBC PreparedStatement.executeBatch to INSERT them into a database table.
,
18 Nov 2013
| 2 comments
|
|
|
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
,
05 Jun 2013
| 18 comments
|
|
|
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)
,
06 Nov 2012
| 5 comments
|
|
|
Hi,
,
21 Sep 2012
| 2 comments
|
|
|
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:
,
11 Jun 2012
| 14 comments
|
|
|
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
,
23 Feb 2012
|
|
|
An updated version of the teradataR package is now available here. Enhancements included with this new 1.0.1 release include:
,
21 Dec 2011
| 1 comment
|
|
|
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:
,
21 Sep 2011
| 1 comment
|
|
|
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!
,
02 Nov 2010
| 9 comments
|
|
|
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.
,
26 Oct 2010
| 20 comments
|