After installing SparkR, Let’s try to import data from PostgreSQL, #tell the path of Spark Sys.setenv(SPARK_HOME="/Users/steven/Applications/spark2") .libPaths(c(file.path(Sys.getenv("SPARK_HOME"), "R", "lib"), .libPaths())) ...
Day: August 31, 2016
the Easiest Way to Install SparkRthe Easiest Way to Install SparkR
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) ...
How to Get the Row numbers of all tables in PostgreSQL DatabaseHow to Get the Row numbers of all tables in PostgreSQL Database
SELECT schemaname,relname,n_live_tup FROM pg_stat_user_tables ORDER BY n_live_tup DESC; Recently, I imported 25 Excels into PostgreSQL separate tables with R, after ...