hdlee2u/gpdb-analytics

•Updated about 8 years ago

Greenplum Database on CentOS with MADlib, PL/R and PL/Python

Image

10K+

hdlee2u/gpdb-analytics repository overview

⁠Greenplum Database on CentOS with Pivotal Data Science Tool Kits, such as MADlib, PL/R and PL/Python

CentOS : release 7.4
Greenplum Database : ver 5.10.2
MADlib : ver 1.15
PL/R : 2.3.2
DataScienceR : 1.0.1
DataSciencePython : 1.1.1

⁠(1) Docker Image Pull

$ docker pull hdlee2u/gpdb-analytics
$ docker images

⁠(2) Docker Image Run(port 5432) -> Docker Container Creation

$ docker run -i -d -p 5432:5432 -p 28080:28080 --name gpdb-ds --hostname mdw hdlee2u/gpdb-analytics /usr/sbin/sshd -D
$ docker ps -a

⁠(3) To Start Greenplum Database and Use psql

$ docker exec -it gpdb-ds /bin/bash
[root@mdw /]# su - gpadmin
[gpadmin@mdw ~]$ gpstart -a
[gpadmin@mdw ~]$ psql
psql (8.3.23)
Type "help" for help.

gpadmin=# \dn
List of schemas
Name | Owner
--------------------+---------
gp_toolkit | gpadmin
information_schema | gpadmin
madlib | gpadmin
pg_aoseg | gpadmin
pg_bitmapindex | gpadmin
pg_catalog | gpadmin
pg_toast | gpadmin
public | gpadmin
(8 rows)

gpadmin=# \q

⁠(4) PGAdmin IV configuration for SQL query

Host : localhost
Port : 5432
Maintenance DB : gpadmin
Username : gpadmin
Password : pivotal
Group: Servers
Ternel port: 22

PGAdmin 4 download: https://www.pgadmin.org/download/⁠

⁠(5) Docker Container Stop, Restart

$ docker stop gpdb-ds
$ docker start gpdb-ds
$ docker ps

⁠(6) In case of 'Error response from daemon: driver failed programming external connectivity on endpoint gpdb-ds : Error starting userland proxy: Bind for 0.0.0.0:5432 failed: port is already allocated

check a running port

$ sudo lsof -i :5432

kill a port which is running

$ sudo kill -15 93

For more information on Greenplum Database https://greenplum.org/⁠ https://network.pivotal.io/⁠ http://rfriend.tistory.com/377⁠

⁠For more information

For more information on Apache MADlib (Big Data Machine Learning in SQL) http://madlib.apache.org/⁠
For more information on Greenplum PL/R Language Extension https://gpdb.docs.pivotal.io/590/ref_guide/extensions/pl_r.html⁠
For more information on Greenplum PL/Python Language Extension https://gpdb.docs.pivotal.io/590/ref_guide/extensions/pl_python.html⁠
For more information on Docker Install, GPDB start, PGAdmin setup, Jupyter Notebook setup http://rfriend.tistory.com/379⁠
For more information on 'Error starting userland proxy: Bind for 0.0.0.0:5432 failed: port is already allocated' http://rfriend.tistory.com/396⁠

** Thanks to SangHee, YoungHo, YounJin and Sangwon

Tag summary

Recent tags

Content type

Image

Digest

Size

2.2 GB

Last updated

about 8 years ago

docker pull hdlee2u/gpdb-analytics