We have a Server installed Windows 2008r2, and I have to use wireless. I have 3 optional solution, Xiaomi Mini Wifi adapter, does not work, maybe I forget enable VLAN Feature, will test again later. EDUP EP-N8508GS Mini WIFI adapter, no driver for EDUP EP-N8508GS, but EP-N8508GS Driver For Win 8/7/XP works. B-Link …
After installing SparkR, Let’s try to import data from PostgreSQL,
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 |
#tell the path of Spark Sys.setenv(SPARK_HOME="/Users/steven/Applications/spark2") .libPaths(c(file.path(Sys.getenv("SPARK_HOME"), "R", "lib"), .libPaths())) library(SparkR) d.pg="org.postgresql:postgresql:9.4.1209.jre7" sc <- sparkR.session(master="local[2]",sparkPackages=c(d.pg)) url<-"jdbc:postgresql://localhost:5432/steven?user=postgres&password=" driver<-"org.postgresql.Driver" df.pg <- read.jdbc(source="jdbc", url=url, tableName ="public.mtcars",driver=driver) printSchema(df.pg) collect(df.pg) #createOrReplaceTempView(df.pg,"mtcars") #sql("select * from mtcars") sparkR.session.stop() |
Install the last version R Dowload and install Spark（you can choose 1.6.2 or 2.0.0, it is also ok to keep both） Install RStudio(optional) Tell R …