(1) The R language needs to be connected to the MySQL database with ODBC. Need to compile RODBC
The error is as follows:
Configure1747: $? =2Configure:1770: Checking forC compiler default outputfilenameconfigure:1774: $CC-o conftest$ac_exeext $CFLAGS $CPPFLAGS $LDFLAGS conftest. $ac _ext $LIBS >&5Checking forC compiler default outputfilenameconfigure:1775:/usr/bin/make64 mac= --s-f/usr/local/lib64/r/etc/makeconf-f/usr/local/lib64/r/share/ Make/CONFIG.MK Print r_home=/usr/local/lib64/r var=CCGCC-std=gnu99 = = =/usr/bin/make64 mac= --s-f/usr/local/lib64/r/etc/makeconf-f/usr/local/lib64/r/share/ Make/CONFIG.MK Print r_home=/usr/local/lib64/r var=CFLAGS-G-o2configure:1776:/usr/bin/make64 mac= --s-f/usr/local/lib64/r/etc/makeconf-f/usr/local/lib64/r/share/ Make/CONFIG.MK Print r_home=/usr/local/lib64/r var=CCGCC-std=gnu99/usr/bin/make64 mac= --s-f/usr/local/lib64/r/etc/makeconf-f/usr/local/lib64/r/share/ Make/CONFIG.MK Print r_home=/usr/local/lib64/r var=CFLAGS-g-o2/usr/bin/make64 mac= --s-f/usr/local/lib64/r/etc/makeconf-f/usr/local/lib64/r/share/ Make/CONFIG.MK Print r_home=/usr/local/lib64/r var=Cppflags-i/usr/local/include-i. Conftest.c >&5/usr/bin/make64:invalid Option--'='/usr/bin/make64:invalid Option--'g'/usr/bin/make64:invalid Option--'u'/usr/bin/make64:invalid Option--'9'/usr/bin/make64:invalid Option--'9'/usr/bin/make64:invalid Option--'g'/usr/bin/make64:invalid Option--'O'/usr/bin/make64:invalid Option--'2'usage:make64 [options] [target] ...
The following causes are resolved:
Cc=eval '"${r_home}/bin/r" CMD config CC ' CPP=eval '"${r_home}/bin/ R" cmd config CPP ' CFLAGS=eval '"${r_home}/bin/r" cmd config CFLAGS ' cppflags=eval '"${r_home}/bin/r" CMD config cppflags '
The debug commands you need to use are as follows:
Export R_share_dir=/usr/local/lib64/r/share
Problems encountered with R language usage