Btree and Hash Indexes on jsonb Data 910 JSON Functions and Operators 910 JSON Operators 911 JSON Creation Functions 912 JSON Aggregate Functions 913 JSON Processing Functions 914 Working with XML Data Built-in Functions and Operators 1495 JSON Functions and Operators 1499 JSON Operators 1499 JSON Creation Functions 1501 JSON Aggregate Functions 1502 JSON Processing Functions 1502 Window Functions the view had a join between tables and any of the table had a column that was dropped after view creation. 31415 - Server : Resolved an issue in which REFRESH MATERIALIZED QUERY was failing if the WHERE

Btree and Hash Indexes on jsonb Data 919 JSON Functions and Operators 919 JSON Operators 920 JSON Creation Functions 921 JSON Aggregate Functions 922 JSON Processing Functions 923 Working with XML Data Built-in Functions and Operators 1504 JSON Functions and Operators 1508 JSON Operators 1508 JSON Creation Functions 1510 JSON Aggregate Functions 1511 JSON Processing Functions 1511 Window Functions the view had a join between tables and any of the table had a column that was dropped after view creation. 31415 - Server : Resolved an issue in which REFRESH MATERIALIZED QUERY was failing if the WHERE

Btree and Hash Indexes on jsonb Data 842 JSON Functions and Operators 842 JSON Operators 843 JSON Creation Functions 844 JSON Aggregate Functions 845 JSON Processing Functions 846 Working with XML Data Built-in Functions and Operators 1431 JSON Functions and Operators 1435 JSON Operators 1435 JSON Creation Functions 1437 JSON Aggregate Functions 1438 JSON Processing Functions 1438 Window Functions relationship to/from another table that was assigned via an ALTER TABLE ... INHERIT statement after table creation. Workaround: Use the following SQL commands to determine if Greenplum Database includes any replicated

Btree and Hash Indexes on jsonb Data 910 JSON Functions and Operators 911 JSON Operators 911 JSON Creation Functions 913 JSON Aggregate Functions 914 JSON Processing Functions 914 VMware Tanzu Greenplum Built-in Functions and Operators 1498 JSON Functions and Operators 1502 JSON Operators 1502 JSON Creation Functions 1504 JSON Aggregate Functions 1505 JSON Processing Functions 1505 Window Functions the view had a join between tables and any of the table had a column that was dropped after view creation. 31415 - Server : Resolved an issue in which REFRESH MATERIALIZED QUERY was failing if the WHERE

Functions and Operators 1584 Processing and Creating JSON Data 1584 JSON Operators 1584 JSON Creation Functions 1586 JSON Aggregate Functions 1588 JSON Processing Functions 1588 Table 8. JSON Processing SEQUENCE AS allows you to create a sequence matching an integer data type. This simplifies the creation of sequences matching the range of base columns. Some DDL commands now accept the current user pinitsys tem \ -s --mirror-mode=spread During a new cluster creation, you may use the -O output\_configuration\_file option to save the cluster configuration details

Btree and Hash Indexes on jsonb Data 830 JSON Functions and Operators 830 JSON Operators 831 JSON Creation Functions 832 JSON Aggregate Functions 833 JSON Processing Functions 834 Working with XML Data Built-in Functions and Operators 1769 JSON Functions and Operators 1774 JSON Operators 1774 JSON Creation Functions 1775 JSON Aggregate Functions 1777 JSON Processing Functions 1777 Window Functions reporting the error failed to acquire resources on one or more segments. Now Greenplum retries gang creation by default for non-recovery failures. 365700 Resolves an issue where reads of append-optimized

Btree and Hash Indexes on jsonb Data 821 JSON Functions and Operators 821 JSON Operators 822 JSON Creation Functions 823 JSON Aggregate Functions 824 JSON Processing Functions 825 Working with XML Data Built-in Functions and Operators 1743 JSON Functions and Operators 1747 JSON Operators 1748 JSON Creation Functions 1749 JSON Aggregate Functions 1751 JSON Processing Functions 1751 Window Functions additional VMware Greenplum 6 Documentation VMware, Inc 141 information about worker process (gang) creation during query execution. gp_max_parallel_cursors - limits the number of active parallel retrieve

Btree and Hash Indexes on jsonb Data 792 JSON Functions and Operators 793 JSON Operators 793 JSON Creation Functions 795 JSON Aggregate Functions 796 VMware Tanzu Greenplum 6 Documentation VMware, Inc Built-in Functions and Operators 1696 JSON Functions and Operators 1700 JSON Operators 1701 JSON Creation Functions 1702 JSON Aggregate Functions 1703 JSON Processing Functions 1703 Table 8. JSON Processing gp_print_create_gang_time - directs Greenplum Database to log additional information about worker process (gang) creation during query execution. gp_max_parallel_cursors - limits the number of active parallel retrieve

Btree and Hash Indexes on jsonb Data 685 JSON Functions and Operators 685 JSON Operators 685 JSON Creation Functions 687 JSON Aggregate Functions 689 JSON Processing Functions 689 Table 7. JSON Processing Built-in Functions and Operators 1494 JSON Functions and Operators 1497 JSON Operators 1498 JSON Creation Functions 1499 JSON Aggregate Functions 1501 JSON Processing Functions 1501 Table 8. JSON Processing to upgrade your existing Greenplum software. Release 6.21 Release 6.21.2 Server 32358 Index creation is now allowed on partitioned tables containing external partitions. Creating a non-unique index

Btree and Hash Indexes on jsonb Data 801 JSON Functions and Operators 801 JSON Operators 802 JSON Creation Functions 803 JSON Aggregate Functions 804 JSON Processing Functions 805 Working with XML Data Built-in Functions and Operators 1732 JSON Functions and Operators 1737 JSON Operators 1737 JSON Creation Functions 1738 JSON Aggregate Functions 1740 JSON Processing Functions 1740 Window Functions 33019 Resolves an issue where recursive CTE (Common Table Expression) errored out due to the creation of an incorrect or non-executable plan. 32958 Resolves an issue where unique key index order affected