Hi R users,

I am using RMySQL to connect to a database in MySQL.

I have 3 questions.

 

1)When I give the following command

dbListTables(con)

 

I get the output 

 

stack imbalance in .Call, 142 then 143

stack imbalance in <-, 140 then 141

stack imbalance in {, 138 then 139

stack imbalance in standardGeneric, 126 then 127

stack imbalance in class, 121 then 122

stack imbalance in <-, 119 then 120

stack imbalance in {, 117 then 118

stack imbalance in <-, 111 then 112

stack imbalance in {, 109 then 110

 

[1] "newtable" "ravi"    

 

Could somebody tell me why it shows a stack imbalance?

 

2)For this command

testcmd1<-fetch(dbSendQuery(con,"select ticker from ravi where
banks>=100"))   

> dim(testcmd1)

The output is

[1] 500   1

However when I give the same command directly in MySQL command prompt I
get an output greater than 2000!! (Does fetch have a limitation?)

 

3) Also is it possible to get output where the NA values are removed?

 

Thanks in advance for the help

Ravi

 

 


	[[alternative HTML version deleted]]

