Unable to get the data from select query using R script

Asked Jun 09 '15 at 08:57

Active Jun 09 '15 at 09:23

Viewed 817 times

I am using R studio to do analysis with data. Able to install RMYSQL libraries and connect to DB but when I am trying write select query I am unable to get the data. I had written script like below

> mydb <- dbConnect(MySQL(), user='user', password='password',
                    dbname='dbname', host='host')
> rs <- dbSendQuery(mydb, "select * from tableName")
> data <- fetch(rs, n=-1)
> dbHasCompleted(rs)

Getting the below error

> rs <- dbSendQuery(mydb, "select * from tableName")
> data <- fetch(rs, n=-1)
Error in (function (env, objName)  : 
  could not find function "object.size"
Error in (function (env, objName)  : 
  could not find function "object.size"

Can any one help to get the data from DB

edited Jun 09 '15 at 09:23

Backlin

14,612
2
49
81

asked Jun 09 '15 at 08:57

Madhu Nali

Works perfectly for me on a database of my own. How come you are writing out all the steps send, fetch, etc. instead of using `dbGetQuery` that does it all for you? – Backlin Jun 09 '15 at 09:19
Got the data thank you – Madhu Nali Jun 09 '15 at 09:27

Unable to get the data from select query using R script

0 Answers0