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) ...
Category: bigdata
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 ...
PostgreSQL:Get the Day Name of Week with One SQLPostgreSQL:Get the Day Name of Week with One SQL
first show the sql, select (array['Sun' ,'Mon', 'Tue', 'Wed', 'Thur', 'Fri', 'Sat']) [extract(dow from now())+1]; dow means The day of ...