32-bit database driver with 64-bit R for big query data
I have a HortonWorks Hadoop / Hive 32 bit database that I can query in 32 bit R using RODBC
.
When trying to connect to a database in 64 bit R, I get this error:
[RODBC] ERROR: state IM014, code 0, message [Microsoft][ODBC Driver Manager]
The specified DSN contains an architecture mismatch between the Driver and Application
However, the large data size requires me to use 64-bit R due to memory limitations on 32-bit Windows.
Is there a job?
source to share
You need to map odbc 32bit drivers to 32bit R and the same for 64bit R. I had a similar problem using 64bit R with 32bit office.
In my case, I used a 32 bit R installation (on my 64 bit windows) to use RODBC with a data connection configured using 32 bit drivers (see this file: odbcad32.exe - this will bring up the 32 bit ODBC Data Source Administrator ). In my case, I save the data as .rdata and then continue to 64 bit R, but if you have to constantly read and write to the data source, it might not be possible to use both.
See this post>
http://r.789695.n4.nabble.com/RODBC-for-64-bit-R-with-32-bit-Access-td3093030.html
And this answer: Manual installation of 64-bit ODBC drivers to access MS Access when using 32-bit Office
source to share