加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 百科 > 正文

Greenplum添加segment节点

发布时间:2020-12-13 17:02:52 所属栏目:百科 来源:网络整理
导读:注意:如果 master 配置了 standby master ,添加的 segment 必须要有 mirror segment 存在,否则报错。 1 查看某张表的数据分布情况 tutorial=# select gp_segment_id,count(*) from otp_r group by gp_segment_id; gp_segment_id | count ---------------+

注意:如果master配置了standby master,添加的segment必须要有mirror segment存在,否则报错。

1查看某张表的数据分布情况

tutorial=# select gp_segment_id,count(*) from otp_r group by gp_segment_id;
 gp_segment_id |  count  
---------------+---------
             0 | 1024552
(1 row)


2关闭iptablesselinux

3root用户配置ssh互信

4创建gpadmin用户

/usr/sbin/useradd gpadmin -d /home/gpadmin -s /bin/bash

5gpadmin用户配置ssh互信

6编辑new_hosts_file文件

该文件中仅包含新增节点主机名

7创建inputfile

[gpadmin@hadoop02 ~]$ gpexpand -f new_hosts_file -D gpadmin
20160928:17:04:09:015501 gpexpand:hadoop02:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 4.3.8.1 build 1'
20160928:17:04:09:015501 gpexpand:hadoop02:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.2.15 (Greenplum Database 4.3.8.1 build 1) on x86_64-unknown-linux-gnu,compiled by GCC gcc (GCC) 4.4.2 compiled on Apr 20 2016 08:08:56'
20160928:17:04:09:015501 gpexpand:hadoop02:gpadmin-[INFO]:-Querying gpexpand schema for current expansion state
 
System Expansion is used to add segments to an existing GPDB array.
gpexpand did not detect a System Expansion that is in progress.
 
Before initiating a System Expansion,you need to provision and burn-in
the new hardware.  Please be sure to run gpcheckperf/gpcheckos to make
sure the new hardware is working properly.
 
Please refer to the Admin Guide for more information.
 
Would you like to initiate a new System Expansion Yy|Nn (default=N):
> y
 
    By default,new hosts are configured with the same number of primary
    segments as existing hosts.  Optionally,you can increase the number
    of segments per host.
 
    For example,if existing hosts have two primary segments,entering a value
    of 2 will initialize two additional segments on existing hosts,and four
    segments on new hosts.  In addition,mirror segments will be added for
    these new primary segments if mirroring is enabled.
    
 
How many new primary segments per host do you want to add? (default=0):
>
 
Generating configuration file...
 
20160928:17:04:12:015501 gpexpand:hadoop02:gpadmin-[INFO]:-Generating input file...
 
Input configuration files were written to 'gpexpand_inputfile_20160928_170412' and 'None'.
Please review the file and make sure that it is correct then re-run
with: gpexpand -i gpexpand_inputfile_20160928_170412 -D gpadmin
                
20160928:17:04:12:015501 gpexpand:hadoop02:gpadmin-[INFO]:-Exiting...


8使用input file添加节点

[gpadmin@hadoop02 ~]$ gpexpand -i gpexpand_inputfile_20160928_170412 -D gpadmin
20160928:17:04:49:015600 gpexpand:hadoop02:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 4.3.8.1 build 1'
20160928:17:04:49:015600 gpexpand:hadoop02:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.2.15 (Greenplum Database 4.3.8.1 build 1) on x86_64-unknown-linux-gnu,compiled by GCC gcc (GCC) 4.4.2 compiled on Apr 20 2016 08:08:56'
20160928:17:04:49:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Querying gpexpand schema for current expansion state
20160928:17:04:49:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Readying Greenplum Database for a new expansion
20160928:17:05:07:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Checking database gpadmin for unalterable tables...
20160928:17:05:07:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Checking database postgres for unalterable tables...
20160928:17:05:07:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Checking database tutorial for unalterable tables...
20160928:17:05:07:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Checking database template1 for unalterable tables...
20160928:17:05:07:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Checking database gpadmin for tables with unique indexes...
20160928:17:05:07:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Checking database postgres for tables with unique indexes...
20160928:17:05:07:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Checking database tutorial for tables with unique indexes...
20160928:17:05:07:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Checking database template1 for tables with unique indexes...
20160928:17:05:07:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Syncing Greenplum Database extensions
20160928:17:05:07:015600 gpexpand:hadoop02:gpadmin-[INFO]:-The packages on hadoop07 are consistent.
20160928:17:05:07:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Creating segment template
20160928:17:05:07:015600 gpexpand:hadoop02:gpadmin-[INFO]:-VACUUM FULL on the catalog tables
20160928:17:05:09:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Starting copy of segment dbid 1 to location /data/master/gpexpand_09282016_15600
20160928:17:05:09:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Copying postgresql.conf from existing segment into template
20160928:17:05:09:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Copying pg_hba.conf from existing segment into template
20160928:17:05:09:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Adding new segments into template pg_hba.conf
20160928:17:05:09:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Creating schema tar file
20160928:17:05:10:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Distributing template tar file to new hosts
20160928:17:05:17:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Configuring new segments (primary)
20160928:17:05:18:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Configuring new segments (mirror)
20160928:17:05:18:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Backing up pg_hba.conf file on original segments
20160928:17:05:18:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Copying new pg_hba.conf file to original segments
20160928:17:05:18:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Configuring original segments
20160928:17:05:18:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Cleaning up temporary template files
20160928:17:05:20:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Starting Greenplum Database in restricted mode
20160928:17:05:26:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Stopping database
20160928:17:05:42:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Checking if Transaction filespace was moved
20160928:17:05:42:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Checking if Temporary filespace was moved
20160928:17:05:42:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Configuring new segment filespaces
20160928:17:05:42:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Cleaning up databases in new segments.
20160928:17:05:42:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Starting master in utility mode
20160928:17:05:43:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Stopping master in utility mode
20160928:17:05:47:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Starting Greenplum Database in restricted mode
20160928:17:05:53:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Creating expansion schema
20160928:17:05:53:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Populating gpexpand.status_detail with data from database gpadmin
20160928:17:05:53:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Populating gpexpand.status_detail with data from database postgres
20160928:17:05:54:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Populating gpexpand.status_detail with data from database tutorial
20160928:17:05:55:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Populating gpexpand.status_detail with data from database template1
20160928:17:05:55:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Stopping Greenplum Database
20160928:17:06:12:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Starting Greenplum Database
20160928:17:06:17:015600 gpexpand:hadoop02:gpadmin-[INFO]:-************************************************
20160928:17:06:17:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Initialization of the system expansion complete.
20160928:17:06:17:015600 gpexpand:hadoop02:gpadmin-[INFO]:-To begin table expansion onto the new segments
20160928:17:06:17:015600 gpexpand:hadoop02:gpadmin-[INFO]:-rerun gpexpand
20160928:17:06:17:015600 gpexpand:hadoop02:gpadmin-[INFO]:-************************************************
20160928:17:06:17:015600 gpexpand:hadoop02:gpadmin-[INFO]:-Exiting...


节点添加成功,但数据没有重新分布。

tutorial=# select gp_segment_id,count(*) from otp_r group by gp_segment_id;
 gp_segment_id |  count  
---------------+---------
             0 | 1024552
(1 row)


9重新分布数据

[gpadmin@hadoop02 ~]$ gpexpand -d 60:00:00 -D gpadmin
20160928:17:11:42:017026 gpexpand:hadoop02:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 4.3.8.1 build 1'
20160928:17:11:42:017026 gpexpand:hadoop02:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.2.15 (Greenplum Database 4.3.8.1 build 1) on x86_64-unknown-linux-gnu,compiled by GCC gcc (GCC) 4.4.2 compiled on Apr 20 2016 08:08:56'
20160928:17:11:42:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Querying gpexpand schema for current expansion state
20160928:17:11:43:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.hdfs01 is 'id'
20160928:17:11:43:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.hdfs01
20160928:17:11:43:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.hdfs01
20160928:17:11:44:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.faa_load_errors is 'None'
20160928:17:11:44:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.faa_load_errors
20160928:17:11:44:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.faa_load_errors
20160928:17:11:44:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.faa_otp_load is 'flt_year,flt_month,flt_dayofmonth'
20160928:17:11:44:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.faa_otp_load
20160928:17:11:54:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.faa_otp_load
20160928:17:11:54:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.otp_r is 'uniquecarrier,flightnum'
20160928:17:11:54:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.otp_r
20160928:17:12:01:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.otp_r
20160928:17:12:02:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.d_airports is 'airport_code'
20160928:17:12:02:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.d_airports
20160928:17:12:02:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.d_airports
20160928:17:12:02:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.d_wac is 'wac'
20160928:17:12:02:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.d_wac
20160928:17:12:02:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.d_wac
20160928:17:12:02:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.d_airlines is 'airlineid'
20160928:17:12:02:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.d_airlines
20160928:17:12:03:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.d_airlines
20160928:17:12:03:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.d_cancellation_codes is 'cancel_code'
20160928:17:12:03:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.d_cancellation_codes
20160928:17:12:03:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.d_cancellation_codes
20160928:17:12:03:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.d_delay_groups is 'delay_group_code'
20160928:17:12:03:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.d_delay_groups
20160928:17:12:03:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.d_delay_groups
20160928:17:12:04:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.d_distance_groups is 'distance_group_code'
20160928:17:12:04:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.d_distance_groups
20160928:17:12:04:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.d_distance_groups
20160928:17:12:04:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.otp_c_1_prt_mth_17 is 'uniquecarrier,flightnum'
20160928:17:12:04:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.otp_c_1_prt_mth_17
20160928:17:12:04:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.otp_c_1_prt_mth_17
20160928:17:12:04:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.otp_c_1_prt_mth_16 is 'uniquecarrier,flightnum'
20160928:17:12:04:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.otp_c_1_prt_mth_16
20160928:17:12:04:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.otp_c_1_prt_mth_16
20160928:17:12:05:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.otp_c_1_prt_mth_15 is 'uniquecarrier,flightnum'
20160928:17:12:05:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.otp_c_1_prt_mth_15
20160928:17:12:05:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.otp_c_1_prt_mth_15
20160928:17:12:05:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.otp_c_1_prt_mth_14 is 'uniquecarrier,flightnum'
20160928:17:12:05:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.otp_c_1_prt_mth_14
20160928:17:12:05:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.otp_c_1_prt_mth_14
20160928:17:12:06:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.otp_c_1_prt_mth_13 is 'uniquecarrier,flightnum'
20160928:17:12:06:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.otp_c_1_prt_mth_13
20160928:17:12:06:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.otp_c_1_prt_mth_13
20160928:17:12:06:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.otp_c_1_prt_mth_12 is 'uniquecarrier,flightnum'
20160928:17:12:06:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.otp_c_1_prt_mth_12
20160928:17:12:06:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.otp_c_1_prt_mth_12
20160928:17:12:06:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.otp_c_1_prt_mth_11 is 'uniquecarrier,flightnum'
20160928:17:12:06:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.otp_c_1_prt_mth_11
20160928:17:12:06:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.otp_c_1_prt_mth_11
20160928:17:12:07:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.otp_c_1_prt_mth_10 is 'uniquecarrier,flightnum'
20160928:17:12:07:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.otp_c_1_prt_mth_10
20160928:17:12:07:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.otp_c_1_prt_mth_10
20160928:17:12:07:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.otp_c_1_prt_mth_9 is 'uniquecarrier,flightnum'
20160928:17:12:07:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.otp_c_1_prt_mth_9
20160928:17:12:07:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.otp_c_1_prt_mth_9
20160928:17:12:08:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.otp_c_1_prt_mth_8 is 'uniquecarrier,flightnum'
20160928:17:12:08:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.otp_c_1_prt_mth_8
20160928:17:12:12:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.otp_c_1_prt_mth_8
20160928:17:12:12:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.otp_c_1_prt_mth_7 is 'uniquecarrier,flightnum'
20160928:17:12:12:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.otp_c_1_prt_mth_7
20160928:17:12:17:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.otp_c_1_prt_mth_7
20160928:17:12:17:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.otp_c_1_prt_mth_6 is 'uniquecarrier,flightnum'
20160928:17:12:17:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.otp_c_1_prt_mth_6
20160928:17:12:17:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.otp_c_1_prt_mth_6
20160928:17:12:18:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.otp_c_1_prt_mth_5 is 'uniquecarrier,flightnum'
20160928:17:12:18:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.otp_c_1_prt_mth_5
20160928:17:12:18:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.otp_c_1_prt_mth_5
20160928:17:12:18:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.otp_c_1_prt_mth_4 is 'uniquecarrier,flightnum'
20160928:17:12:18:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.otp_c_1_prt_mth_4
20160928:17:12:18:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.otp_c_1_prt_mth_4
20160928:17:12:18:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.otp_c_1_prt_mth_3 is 'uniquecarrier,flightnum'
20160928:17:12:18:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.otp_c_1_prt_mth_3
20160928:17:12:18:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.otp_c_1_prt_mth_3
20160928:17:12:19:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.otp_c_1_prt_mth_2 is 'uniquecarrier,flightnum'
20160928:17:12:19:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.otp_c_1_prt_mth_2
20160928:17:12:19:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.otp_c_1_prt_mth_2
20160928:17:12:19:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.otp_c_1_prt_mth_1 is 'uniquecarrier,flightnum'
20160928:17:12:19:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.otp_c_1_prt_mth_1
20160928:17:12:19:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.otp_c_1_prt_mth_1
20160928:17:12:20:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Distribution policy for table faa.sample is 'id'
20160928:17:12:20:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Expanding tutorial.faa.sample
20160928:17:12:23:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Finished expanding tutorial.faa.sample
20160928:17:12:28:017026 gpexpand:hadoop02:gpadmin-[INFO]:-EXPANSION COMPLETED SUCCESSFULLY
20160928:17:12:28:017026 gpexpand:hadoop02:gpadmin-[INFO]:-Exiting...
 


查看数据分布情况

tutorial=# select gp_segment_id,count(*) from otp_r group by gp_segment_id;
 gp_segment_id | count  
---------------+--------
             1 | 510480
             0 | 514072
(2 rows)

发现已均匀分部在各个节点

10清理expansion schema

[gpadmin@hadoop02 ~]$ gpexpand -c -D gpadmin
20160928:17:15:14:018434 gpexpand:hadoop02:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 4.3.8.1 build 1'
20160928:17:15:14:018434 gpexpand:hadoop02:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.2.15 (Greenplum Database 4.3.8.1 build 1) on x86_64-unknown-linux-gnu,compiled by GCC gcc (GCC) 4.4.2 compiled on Apr 20 2016 08:08:56'
20160928:17:15:14:018434 gpexpand:hadoop02:gpadmin-[INFO]:-Querying gpexpand schema for current expansion state
 
 
Do you want to dump the gpexpand.status_detail table to file? Yy|Nn (default=Y):
> y
20160928:17:15:16:018434 gpexpand:hadoop02:gpadmin-[INFO]:-Dumping gpexpand.status_detail to /data/master/gpseg-1/gpexpand.status_detail
20160928:17:15:16:018434 gpexpand:hadoop02:gpadmin-[INFO]:-Removing gpexpand schema
20160928:17:15:16:018434 gpexpand:hadoop02:gpadmin-[INFO]:-Cleanup Finished.  exiting...
 


(编辑:李大同)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章
      热点阅读