I am trying to run Spark on my R Studio in connecting to MS SQL Server with an ODBC Data source but facing issues. What am I doing wrong?
The goal of my current project is to load almost 31M rows of dataset into R studio where I want to conduct Exploratory Analysis and conduct research. I cannot use advanced statistical analysis on just SQL server so I have to use R programming language to complete my research.