#DateForumTypeThreadPost
1315 Jan 2016 @ 07:53 PSTExtensibilityReplyTable operator UDF - VARCHAR lengthThis 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 ...
1229 May 2013 @ 04:15 PDTAnalyticsReplyteradataR package and R 3.0.0It will work on any version >= 2.11 and < 3.0.0.
1129 May 2013 @ 02:58 PDTAnalyticsReplyTeradataR QuestionYou 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 <...
1029 May 2013 @ 02:54 PDTConnectivityReplyRODBC fails and teradataR crashes on RHEL6You 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...
929 May 2013 @ 02:44 PDTAnalyticsReplyTeradataR Question about kemans analysisActually 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...
814 Feb 2012 @ 11:40 PSTAnalyticsReplyneed 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 ...
714 Feb 2012 @ 10:27 PSTAnalyticsReplyneed 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...
613 Jan 2011 @ 10:35 PSTAnalyticsReplyFine tuning a queryHere 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...
511 Nov 2010 @ 10:44 PSTAnalyticsReplyTeradataR 1.0Quick 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...
404 Nov 2010 @ 07:13 PDTAnalyticsReplyTeradataR 1.0It 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...
303 Nov 2010 @ 10:46 PDTAnalyticsReplyTeradataR 1.0Hi 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...
202 Nov 2010 @ 12:08 PDTAnalyticsReplyWarehouse Miner Literal ParametersAs 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...
127 Oct 2010 @ 03:46 PDTAnalyticsReplyTemporary variable store in SQLNot 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...