Custom Data Access Protocol 728 Notes 729 Installing the External Table Protocol 729 gpextprotocal.c 730 Querying Data 735 About Greenplum Query Processing 736 Understanding Query Planning and Dispatch define the structure of the record with an AS clause. select * from json_to_record(‘{“a”:1,“b”:[1,2,3],“c”:“bar”}’) as x(a int, b text, d text) a | b | d —+———+— 1 | [1,2,3] | json_to_recordset(json) jsonb structure of the record with an AS clause. select * from json_to_recordset(‘[{“a”:1,“b”:“foo”},{“a”:“2”,“c”:“bar”}]’) as x(a int, b text); a | b —+—– 1 | foo 2 | Note: The examples for the functions json_populate_record()

Custom Data Access Protocol 755 Notes 756 Installing the External Table Protocol 756 gpextprotocal.c 757 Querying Data 762 About Greenplum Query Processing 763 Understanding Query Planning and Dispatch truncation during a segment upgrade. 13706 Resolves an error, FATAL: Unexpected internal error (list.c:395), that could occur when creating a plan for a correlated subquery against a partitioned table. master. 13669 Resolved an assertion failure, "FATAL" error "Unexpected internal error (vmem_tracker.c:436)","Process 399817 will wait for gp_debug_linger=120 seconds before termination, that could occur

Custom Data Access Protocol 558 Notes 559 Installing the External Table Protocol 559 gpextprotocal.c 560 Querying Data 565 About Greenplum Query Processing 566 Understanding Query Planning and Dispatch json_populate_record(null::myrowtype, ‘{“a”: 1, “b”: [“2”, “a b”], “c”: {“d”: 4, “e”: “a b c”}}’) a | b | c —+———–+————- 1 | {2,“a b”} | (4,“a b c”) json_populate_recordset(base anyelement, from_json json) “b”:[1,2,3], “c”:[1,2,3],“e”:“bar”,“r”: {“a”: 123, “b”: “a b c”}}’) as x(a int, b text, c int[], d text, r myrowtype) a | b | c | d | r —+———+———+—+————— 1 | [1,2,3] | {1,2,3} | | (123,“a b c”) json_to_recordset(json)

Custom Data Access Protocol 764 Notes 764 Installing the External Table Protocol 765 gpextprotocal.c 765 Querying Data 770 About Greenplum Query Processing 771 Understanding Query Planning and Dispatch Documentation VMware by Broadcom 184 13706 Resolves an error, FATAL: Unexpected internal error (list.c:395), that could occur when creating a plan for a correlated subquery against a partitioned table. master. 13669 Resolved an assertion failure, "FATAL" error "Unexpected internal error (vmem_tracker.c:436)","Process 399817 will wait for gp_debug_linger=120 seconds before termination, that could occur

Greenplum 6 Documentation VMware, Inc. 34 Installing the External Table Protocol 735 gpextprotocal.c 736 Querying Data 741 About Greenplum Query Processing 742 Understanding Query Planning and Dispatch truncation during a segment upgrade. 13706 Resolves an error, FATAL: Unexpected internal error (list.c:395), that could occur when creating a plan for a correlated subquery against a partitioned table. master. 13669 Resolved an assertion failure, "FATAL" error "Unexpected internal error (vmem_tracker.c:436)","Process 399817 will wait for gp_debug_linger=120 seconds before termination, that could occur

Custom Data Access Protocol 727 Notes 727 Installing the External Table Protocol 728 gpextprotocal.c 729 Querying Data 734 About Greenplum Query Processing 735 Understanding Query Planning and Dispatch truncation during a segment upgrade. 13706 Resolves an error, FATAL: Unexpected internal error (list.c:395), that could occur when creating a plan for a correlated subquery against a partitioned table. master. 13669 Resolved an assertion failure, "FATAL" error "Unexpected internal error (vmem_tracker.c:436)","Process 399817 will wait for gp_debug_linger=120 seconds before termination, that could occur

Custom Data Access Protocol 627 Notes 627 Installing the External Table Protocol 628 gpextprotocal.c 629 Querying Data 633 About Greenplum Query Processing 634 Understanding Query Planning and Dispatch define the structure of the record with an AS clause. select * from json_to_record(‘{“a”:1,“b”:[1,2,3],“c”:“bar”}’) as x(a int, b text, d text) a | b | d —+ ———+— 1 | [1,2,3] | json_to_recordset(json) json structure of the record with an AS clause. select * from json_to_recordset(‘[{“a”:1,“b”:“foo”},{“a”:“2”,“c”:“bar”}]’) as x(a int, b text); a | b —+—– 1 | foo 2 | Note: The examples for the functions json_populate_record()

the External Table Protocol 845 Installing the External Table Protocol 0 gpextprotocal.c 846 gpextprotocal.c 0 Querying Data 852 Querying Data 0 About Greenplum Query Processing 853 About Greenplum process was searching for a file that had been rightfully deleted. 12670 : Introduces a contentId (%c) parameter to the WAL archive_command and restore_command; this parameter identifies a WAL stream from "22023","recovery command file ""recovery.conf"" request for standby mode not specified",,,,,,,0,,"xlog.c",5465 Greenplum Database now supports server recovery in a non-continuous mode using standby_mode=on

the External Table Protocol 854 Installing the External Table Protocol 0 gpextprotocal.c 855 gpextprotocal.c 0 Querying Data 861 Querying Data 0 About Greenplum Query Processing 862 About Greenplum process was searching for a file that had been rightfully deleted. 12670 : Introduces a contentId (%c) parameter to the WAL archive_command and restore_command; this parameter identifies a WAL stream from "22023","recovery command file ""recovery.conf"" request for standby mode not specified",,,,,,,0,,"xlog.c",5465 Greenplum Database now supports server recovery in a non-continuous mode using standby_mode=on

Custom Data Access Protocol 844 Notes 845 Installing the External Table Protocol 845 gpextprotocal.c 846 Querying Data 852 About Greenplum Query Processing 853 Understanding Query Planning and Dispatch strict function with zero arguments was used as a filter for NULL rejection. 181646913 : Resolves a C++ compiler and nullptr usage mismatch by using NULL instead. VMware Tanzu Greenplum v6.20 Documentation process was searching for a file that had been rightfully deleted. 12670 : Introduces a contentId (%c) parameter to the WAL archive_command and restore_command; this parameter identifies a WAL stream from