gpload ERROR: column p.attrnums does not exist

Products

• VMware Tanzu Greenplum

Issue/Introduction

In the environment GPDB 6x and gpload 5.x, the gpload is failing with the error message below:

2021-02-04 09:12:32|INFO|gpload session started 2021-02-04 09:12:32
2021-02-04 09:12:32|INFO|started gpfdist -p 8000 -P 9000 -f "/apps/infa/data/infa_shared/Temp/test_ddl_6x_w_gl_company_d_test_6x_0_pipe
0" -t 30 -m 32768
Traceback (most recent call last):
File "/apps/infa/svc_npbdlgdwinfadev/GPLOAD/bin/gpload.py", line 2690, in run
self.run2()
File "/apps/infa/svc_npbdlgdwinfadev/GPLOAD/bin/gpload.py", line 2674, in run2
self.do_method()
File "/apps/infa/svc_npbdlgdwinfadev/GPLOAD/bin/gpload.py", line 2644, in do_method
self.do_method_merge()
File "/apps/infa/svc_npbdlgdwinfadev/GPLOAD/bin/gpload.py", line 2553, in do_method_merge
self.table_supports_update()
File "/apps/infa/svc_npbdlgdwinfadev/GPLOAD/bin/gpload.py", line 2521, in table_supports_update
distKeyList = self.get_table_dist_key()
File "/apps/infa/svc_npbdlgdwinfadev/GPLOAD/bin/gpload.py", line 2510, in get_table_dist_key
resultList = self.db.query(sql.encode('utf-8')).getresult()
File "/apps/infa/svc_npbdlgdwinfadev/GPLOAD/bin/ext/pygresql/pg.py", line 313, in query
return self.db.query(qstr)
ProgrammingError: ERROR: column p.attrnums does not exist
LINE 1: ...d and a.attrelid = p.localoid and a.attnum = any (p.attrnums...

2021-02-04 09:12:32|ERROR|unexpected error -- backtrace written to log file 2021-02-04 09:12:32|INFO|rows Inserted = 0 2021-02-04 09:12:32|INFO|rows Updated = 0 2021-02-04 09:12:32|INFO|data formatting errors = 0 2021-02-04 09:12:32|INFO|gpload failed

Environment

Product Version: 6.12

Resolution

The gpload for 5.x and 4.x does not work with Greenplum 6, however the gpload for 6.x will work with 5.x and 6.x.

In 6.x, within the gp_distribution_policy system table, the attrnums column is renamed distkey and its data type is changed to int2vector. A backend function pg_get_table_distributedby() was added to get the distribution policy for a table as a string.

Please upgrade gpload to version 6.