Mapping 763 NULL Handling 764 Complex Types 765 Returning Complex Types 765 Functions That Return Sets 766 Returning a SETOF 766 Returning a SETOF 766 Using the ResultSetProvider result set. GPORCA now supports planning and running queries that you specify with multiple grouping sets. Append-Optimized Tables Altering a column type for AO/CO tables requires only rewriting the column frequencies (fractions of total row count) of the values in the stavalues array. The values are ordered in decreasing frequency. Since the arrays are variable-size, K can be chosen by the statistics collector

Mapping 962 NULL Handling 962 Complex Types 963 Returning Complex Types 963 Functions That Return Sets 964 Returning a SETOF 964 Returning a SETOF 965 Using the ResultSetProvider Interface 965 Using Supported Platforms 1007 Prerequisites 1007 Installing the Greenplum R Client 1008 Example Data Sets 1008 Using the Greenplum R Client 1009 Loading GreenplumR 1009 Connecting to Greenplum Database The gp_percentile_agg module has been updated fix a bug and to generate more performant plans for ordered-set aggregates with skewed data. If you are currently using this module, you must upgrade the module

Mapping 931 NULL Handling 932 Complex Types 933 Returning Complex Types 933 Functions That Return Sets 934 Returning a SETOF 934 Returning a SETOF 935 Using the ResultSetProvider Interface 935 Using 976 Supported Platforms 976 Prerequisites 976 Installing the Greenplum R Client 977 Example Data Sets 977 Using the Greenplum R Client 978 Loading GreenplumR 978 Connecting to Greenplum Database 978 The gp_percentile_agg module has been updated fix a bug and to generate more performant plans for ordered-set aggregates with skewed data. If you are currently using this module, you must upgrade the module

Mapping 927 NULL Handling 927 Complex Types 928 Returning Complex Types 928 Functions That Return Sets 929 VMware Tanzu Greenplum 6 Documentation VMware, Inc. 40 Returning a SETOF 929 971 Supported Platforms 971 Prerequisites 972 Installing the Greenplum R Client 972 Example Data Sets 973 Using the Greenplum R Client 973 Loading GreenplumR 973 Connecting to Greenplum Database 973 The gp_percentile_agg module has been updated fix a bug and to generate more performant plans for ordered-set aggregates with skewed data. If you are currently using this module, you must upgrade the module

Mapping 974 NULL Handling 975 Complex Types 976 Returning Complex Types 976 Functions That Return Sets 977 Returning a SETOF 977 Returning a SETOF 977 Using the ResultSetProvider Supported Platforms 1020 Prerequisites 1020 Installing the Greenplum R Client 1021 Example Data Sets 1022 Using the Greenplum R Client 1022 Loading GreenplumR 1022 VMware Greenplum 6 Documentation optimizer_penalize_broadcast_threshold GPORCA server configuration parameter is set to 0, GPORCA now sets the broadcast threshold to unlimited and never penalizes a broadcast VMware Greenplum 6 Documentation

Mapping 810 NULL Handling 810 Complex Types 811 Returning Complex Types 811 Functions That Return Sets 812 Returning a SETOF 812 Returning a SETOF 813 Using the ResultSetProvider Interface 813 Using 848 Supported Platforms 848 Prerequisites 849 Installing the Greenplum R Client 849 Example Data Sets 850 Using the Greenplum R Client 850 Loading GreenplumR 850 Connecting to Greenplum Database 850 gp_percentile_agg, that you can use to improve GPORCA plan generation performance for queries that include ordered-set aggregate functions such as percentile_cont(), percentile_disc(), and median(). Greenplum Database

Mapping 943 NULL Handling 944 Complex Types 944 Returning Complex Types 945 Functions That Return Sets 946 Returning a SETOF 946 Returning a SETOF 946 Using the ResultSetProvider 989 Supported Platforms 989 Prerequisites 989 Installing the Greenplum R Client 990 Example Data Sets 990 Using the Greenplum R Client 991 Loading GreenplumR 991 Connecting to Greenplum Database 991 optimizer_penalize_broadcast_threshold GPORCA server configuration parameter is set to 0, GPORCA now sets the broadcast threshold to unlimited and never penalizes a broadcast motion. Previously, when the

Mapping 436 NULL Handling 437 Complex Types 437 Returning Complex Types 438 Functions That Return Sets 438 Returning a SETOF 439 Returning a SETOF 439 Using the ResultSetProvider 480 Supported Platforms 480 Prerequisites 480 Installing the Greenplum R Client 481 Example Data Sets 482 Using the Greenplum R Client 482 Loading GreenplumR 482 Connecting to Greenplum Database 482 Backups with gpbackup and gprestore 0 About Incremental Backup Sets 552 Using Incremental Backups 553 Example Using Incremental Backup Sets 554 Creating an Incremental Backup with gpbackup 555 Restoring

Mapping 445 NULL Handling 446 Complex Types 447 Returning Complex Types 447 Functions That Return Sets 448 Returning a SETOF 448 Returning a SETOF 448 Using the ResultSetProvider 489 Supported Platforms 490 Prerequisites 490 Installing the Greenplum R Client 490 Example Data Sets 491 Using the Greenplum R Client 491 Loading GreenplumR 491 Connecting to Greenplum Database 492 Backups with gpbackup and gprestore 0 About Incremental Backup Sets 561 Using Incremental Backups 562 Example Using Incremental Backup Sets 563 Creating an Incremental Backup with gpbackup 564 Restoring

Mapping 371 NULL Handling 372 Complex Types 372 Returning Complex Types 373 Functions That Return Sets 373 Returning a SETOF 374 Returning a SETOF 374 Using the ResultSetProvider Documentation VMware, Inc. 20 Prerequisites 415 Installing the Greenplum R Client 416 Example Data Sets 417 Using the Greenplum R Client 417 Loading GreenplumR 417 Connecting to Greenplum Database 417 Backups with gpbackup and gprestore 0 About Incremental Backup Sets 484 Using Incremental Backups 485 Example Using Incremental Backup Sets 486 Creating an Incremental Backup with gpbackup 487 Restoring