Hi, Vinod,
Hope this will help you:
library(RJDBC)
#specify your mysql driver
drv <- JDBC("com.vertica.Driver", "../vertica_3.5_jdk_5.jar")
# specify your connection string
conn <- dbConnect(drv, "jdbc:<postgres>://<IP>:<port>/dbname", "login",
"password")
#list tables
dbListTables(conn)
#get your distances
dist<-dbGetQuery(conn, "select * from ...");
Good luck,
-Alex
________________________________________
From: r-help-boun...@r-project.org [r-help-boun...@r-project.org] on behalf of
Vinod Hegde [vinod.hegd...@gmail.com]
Sent: 27 March 2012 16:30
To: r-help@r-project.org
Subject: [R] Constructing Distance matrix for hclust
Hi,
I have similarity value between string pairs in a mysql database.
I need to construct the distance matrix which hclust can take and cluster
the strings. Most of the examples I came across show how to construct the
distance matrix using dist function.
How can I code to construct distance matrix using the data in mysql db.
Thanks a lot for any help.
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
