第一步:从Teradata官方网站现在JDBC driver
第二步:把Driver放在一个目录下(我放在C:\JDBC)
第三步:为R按照RJDBC package
install.packages("RJDBC")
安装成功后,可以键入如下代码进行连接Teradata
> library(RJDBC)
> jdbc.drv
> jdbc.conn
> dbGetQuery(jdbc.conn, "select current_date, user, session")
Date User Session
1 2012-05-14 GUANWANG 188541253
> df
> str(df)
'data.frame': 1 obs. of 3 variables:
$ Date : chr "2012-05-14"
$ User : chr "GUANWANG"
$ Session: num 1.89e+08
> df[,1]
[1] "2012-05-14"
> df[,"User"]
[1] "GUANWANG"
> df
Date User Session
1 2012-05-14 GUANWANG 188541253
> dbDisconnect(jdbc.conn) #关闭连接
[1] TRUE
> dbGetQuery(jdbc.conn, "select current_date, user, session")
Error in .verify.JDBC.result(s, "Unable to execute JDBC statement ", statement) :
Unable to execute JDBC statement select current_date, user, session ([Teradata JDBC Driver] [TeraJDBC 13.10.00.18] [Error 1095] [SQLState HY000] Cannot call a method on closed connection)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26935210/viewspace-723545/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26935210/viewspace-723545/