Skip to content

Latest commit

 

History

History
76 lines (66 loc) · 3 KB

README_DB.md

File metadata and controls

76 lines (66 loc) · 3 KB

How to setup Greenplum database

This readme describes how to setup Greenplum that is running inside docker.

Pre-requisites:

Verify the docker instance is running

Make sure the docker instances are running by running docker ps

  $ docker ps
CONTAINER ID        IMAGE                                COMMAND                  CREATED             STATUS              PORTS                                                                                                                                                        NAMES
95e091b03024        gettyimages/spark:2.1.1-hadoop-2.7   "bin/spark-class o..."   7 minutes ago       Up 7 minutes        7012-7016/tcp, 8881/tcp, 0.0.0.0:8081->8081/tcp                                                                                                              docker_worker_1
150ab427ab05        docker_gpdb                          "/bin/sh -c 'echo ..."   7 minutes ago       Up 6 minutes        0.0.0.0:5005->5005/tcp, 0.0.0.0:5010->5010/tcp, 0.0.0.0:5432->5432/tcp, 0.0.0.0:9090->9090/tcp, 0.0.0.0:40000-40002->40000-40002/tcp, 0.0.0.0:9022->22/tcp   docker_gpdb_1
a8bd0238cfab        gettyimages/spark:2.1.1-hadoop-2.7   "bin/spark-class o..."   7 minutes ago       Up 7 minutes        0.0.0.0:4040->4040/tcp, 0.0.0.0:6066->6066/tcp, 0.0.0.0:7077->7077/tcp, 0.0.0.0:8080->8080/tcp, 7001-7006/tcp                                                docker_master_1

How to run the setupDB.sh

  1. Connect to the GPDB docker image The Greenplum DB cluster will be running at docker_gpdb_1 with two segments. To access this docker instance, exec into a container:
  $ docker exec -it docker_gpdb_1 bin/bash
  1. Execute the command below to access the scripts folder under "/code/data"
[root@d632f535db87]# cd /code/data
  1. Run scripts/setupDB.sh, in order to create a database and table.
[root@d632f535db87 data]# scripts/setupDB.sh
psql:./sample_table.sql:1: NOTICE:  table "basictable" does not exist, skipping
DROP TABLE
psql:./sample_table.sql:5: NOTICE:  CREATE TABLE will create implicit sequence "basictable_id_seq" for serial column "basictable.id"
CREATE TABLE
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 9
INSERT 0 18
INSERT 0 36
INSERT 0 72
INSERT 0 144
INSERT 0 288
INSERT 0 576
INSERT 0 1152
INSERT 0 2304
INSERT 0 4608
  1. Run the following psql command to verify database (basic_db) and table (basictable) are created correctly.
[root@d632f535db87 data]# psql -h localhost -U gpadmin -d basic_db -c "\dt" -w pivotal
psql: warning: extra command-line argument "pivotal" ignored
           List of relations
 Schema |    Name    | Type  |  Owner
--------+------------+-------+---------
 public | basictable | table | gpadmin
(1 row)

[root@d632f535db87 data]# psql -h localhost -U gpadmin -d basic_db -c "select count(*) from basictable" -w pivotal
psql: warning: extra command-line argument "pivotal" ignored
 count
-------
  9216
(1 row)