sqlquery in R does not return all rows from query

Question

I am executing below commands in R:

dbhandle <- odbcDriverConnect('driver={SQL Server};server=serveripaddress;database=DBName;uid=sa;pwd=pwd;')

FactActivity <- sqlQuery(dbhandle, "SELECT DimCourseID,DimPatientID FROM DWH.FactActivity", as.is=TRUE)

nrow(FactActivity)

In my database I have total 238634 rows but in R I am getting total rows = 237652.

This is happening for all tables (I tried it for three tables).

Any idea what am I missing which is reducing no of rows in my resultset in R?

? nrow(FactActivity)

jogo
– jogo

2017-04-04 07:17:25 +00:00
Commented Apr 4, 2017 at 7:17 — jogo
– jogo, Commented Apr 4, 2017 at 7:17

WHoekstra · Accepted Answer · 2017-04-04 07:39:17Z

1

I had the same problem, couldn't solve it, eventually switched to using RJDBC with a Java driver to get around it.

answered Apr 4, 2017 at 7:39

WHoekstra

1737 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

WHoekstra Over a year ago

Yes it did. Would recommend this approach, since it also doesn't depend on local resources of the operating systems - it is portable across platforms (assuming you have access to a Java installation).

Collectives™ on Stack Overflow

sqlquery in R does not return all rows from query

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related