Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
1.7k views
in Technique[技术] by (71.8m points)

azure sql database - R Session Aborted - Writing big dataframe to MS SQL Server using DBI::dbWriteTable

I would like to write my dataframe of 4 Mio. rows on MS SQL Server database. I am using the following function from DBI R Package -

dbWriteTable(dbHandle, "dbo.targetTable", finalOutputDataframe,
     append = FALSE, temporary = FALSE, row.names = FALSE, overwrite=TRUE )

When I use the above code to write up to 300,000 rows of the same dataframe, it works very well and my target table dbo.targetTableis created. But if I am writing all 4 Mio. rows at once then my R session is aborted. It does not throw any error that could allow me to debug the code. What am I doing wrong? Is there any limit to the number of rows that I could write at once? Thank you.

question from:https://stackoverflow.com/questions/65837987/r-session-aborted-writing-big-dataframe-to-ms-sql-server-using-dbidbwritetab

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)
Waitting for answers

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...