13 | 15 Jan 2016 @ 07:53 PST | Extensibility | Reply | Table operator UDF - VARCHAR length | This is an old question but thought I'd share an answer in case others happen upon it this thread with the same question. Instead of using the bytesize variable which is for fixed length ... |
12 | 29 May 2013 @ 04:15 PDT | Analytics | Reply | teradataR package and R 3.0.0 | It will work on any version >= 2.11 and < 3.0.0.
|
11 | 29 May 2013 @ 02:58 PDT | Analytics | Reply | TeradataR Question | You should be able to use as.data.frame with a td.data.frame as input to retrieve rows from the database into R. It would look like this:
tdf <- td.data.frame('mytable');
df <... |
10 | 29 May 2013 @ 02:54 PDT | Connectivity | Reply | RODBC fails and teradataR crashes on RHEL6 | You actually need to compile RODBC with teradata to get this to work...try the following in R:
install.packages('RODBC', configure.args=c('--with-odbc-include=/opt/teradata/cli... |
9 | 29 May 2013 @ 02:44 PDT | Analytics | Reply | TeradataR Question about kemans analysis | Actually the td.kmeans function takes a td.data.frame as input and td.data.frames can be used almost identically to a regular R data.frame. cbind won't work because it doesn't know ab... |
8 | 14 Feb 2012 @ 11:40 PST | Analytics | Reply | need the syntax for the tdQuery function in teradataR 1.0.1 |
Alan,
You should also be able to use the subset command to accomplish this. So if you have a td.data.frame(tdf) that points to a table you could do...
newTdf ... |
7 | 14 Feb 2012 @ 10:27 PST | Analytics | Reply | need the syntax for the tdQuery function in teradataR 1.0.1 |
The tdQuery function simply takes the query you want to run as a parameter so it would be like this:
res <- tdQuery("select * from table where age > 35")
res will contain... |
6 | 13 Jan 2011 @ 10:35 PST | Analytics | Reply | Fine tuning a query | Here is something you could try. If your 50 queries are all inserting into that same table "DB.MAIN" the queries will lock that table and run sequentially. If you could change the queries to writ... |
5 | 11 Nov 2010 @ 10:44 PST | Analytics | Reply | TeradataR 1.0 | Quick note on installation. It appears R has a slight bug with the name of the zip file hence the reason it won't install with the install.packages command. So to install you either need to just un... |
4 | 04 Nov 2010 @ 07:13 PDT | Analytics | Reply | TeradataR 1.0 | It is self-contained and uses SQL against the database. For some of the statistical functions like shapiro.wilk, lilliefors, and several others it does require you to create the statistical tables... |
3 | 03 Nov 2010 @ 10:46 PDT | Analytics | Reply | TeradataR 1.0 | Hi andeek,
Right now the only docs for this package are through the R help facility. So you can do help(teradataR) in R and then search the index for help on each individual function in the pac... |
2 | 02 Nov 2010 @ 12:08 PDT | Analytics | Reply | Warehouse Miner Literal Parameters | As of now you cannot set the literal parameters dynamically via a value from a prior analysis. One place that you are allowed to set a value for a literal is through the batch interface. You coul... |
1 | 27 Oct 2010 @ 03:46 PDT | Analytics | Reply | Temporary variable store in SQL | Not sure if this is what you are looking for, but you could create a view and define y as C1*a1+C2*a2 and then just reference your view in the select. If you are looking to keep changing y then yo... |