How to Connect Spark with PostgreSQL

After installing SparkR, Let’s try to import data from PostgreSQL,

 

the 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) Tell R where spark is installed

Enjoy it( Spark 2.0.0 example)

  reference, 最简便的SparkR安装方法

How to Get the Row numbers of all tables in PostgreSQL Database

Recently, I imported 25 Excels into PostgreSQL separate tables with R, after imported, I was told there existed two excel files …