Description 590 Arguments 590 Exit Code 590 setup_plugin_for_backup 591 setup_plugin_for_backup 0 Synopsis 591 Description 591 Arguments 591 Exit Code 592 setup_plugin_for_restore 592 setup_plugin_for_restore is an arbitrary backup directory on the host. VMware Greenplum v6.19 Documentation VMware, Inc. 591 scope The execution scope value indicates the host and number of times the plugin command is run Enhanced seconds precision YES F561 Full value expressions YES F571 Truth value tests YES F591 Derived tables YES F611 Indicator data types YES F641 Row and table constructors NO F651 Catalog

Planning New Segment Initialization 590 Planning Mirror Segments 591 Increasing Segments Per Host 591 About the Expansion Schema 591 Planning Table Redistribution 592 Managing Redistribution in Large-Scale read and write operations during redistribution. VMware Greenplum v6.18 Documentation VMware, Inc. 591 move - Scan all the data and perform an UPDATE operation to move rows as needed to different segment Enhanced seconds precision YES F561 Full value expressions YES F571 Truth value tests YES F591 Derived tables YES F611 Indicator data types YES F641 Row and table constructors NO F651 Catalog

Creating a Sequence 590 Using a Sequence 591 Examining Sequence Attributes 591 Returning the Next Sequence Counter Value 591 Setting the Sequence Counter Value 591 Altering a Sequence 592 Dropping a Sequence statements if mirroring is enabled in Greenplum Database. VMware Greenplum 6 Documentation VMware, Inc 591 setval() has two function signatures: setval(sequence, start_val) and setval(sequence, start_val |F555|Enhanced seconds precision|YES| | |F561|Full value expressions|YES| | |F571|Truth value tests|YES| | |F591|Derived tables|YES| | |F611|Indicator data types|YES| | |F641|Row and table constructors|NO| | |F651|Catalog

Planning New Segment Initialization 590 Planning Mirror Segments 591 Increasing Segments Per Host 591 About the Expansion Schema 591 Planning Table Redistribution 592 Managing Redistribution in Large-Scale redistribution, an ACCESS EXCLUSIVE lock is VMware Tanzu Greenplum v6.20 Documentation VMware, Inc. 591 acquired on the table. In general, this method requires less disk space, however, it creates obsolete Enhanced seconds precision YES F561 Full value expressions YES F571 Truth value tests YES F591 Derived tables YES F611 Indicator data types YES F641 Row and table constructors NO F651 Catalog

Documentation VMware by Broadcom 28 Renaming a Partition 590 Adding a Default Partition 591 Dropping a Partition 591 Truncating a Partition 592 Exchanging a Partition 592 Splitting a Partition 593 Modifying TABLE sales_1_part_jan16... is not allowed. VMware Greenplum 6 Documentation VMware by Broadcom 591 Truncating a Partition You can truncate a partition using the ALTER TABLE command. When you truncate Documentation VMware by Broadcom 2376 ID Feature Supported Comments F571 Truth value tests YES F591 Derived tables YES F611 Indicator data types YES F641 Row and table constructors NO F651 Catalog

Protocol 588 pxf:// Protocol 590 s3:// Protocol 590 Configuring the s3 Protocol 591 Using s3 External Tables 591 About the s3 Protocol LOCATION URL 593 About Reading and Writing S3 Data Files 594 capabilities and limitations of s3 external tables: VMware Tanzu Greenplum 6 Documentation VMware, Inc. 591 1. Configure the s3 Protocol. 2. Create the s3 protocol configuration file: 1. Create a template Enhanced seconds precision YES F561 Full value expressions YES F571 Truth value tests YES F591 Derived tables YES F611 Indicator data types YES F641 Row and table constructors NO F651 Catalog

Best Practices for Roles and Privileges 590 Creating New Roles (Users) 590 Altering Role Attributes 591 Role Membership 592 Managing Object Privileges 593 Simulating Row Level Access Control 595 Encrypting and CREATEROLE to the admin role. If sally is VMware Greenplum v6.17 Documentation VMware, Inc. 591 a member of admin, she could issue the following command to assume the role attributes of the parent Enhanced seconds precision YES F561 Full value expressions YES F571 Truth value tests YES F591 Derived tables YES F611 Indicator data types YES F641 Row and table constructors NO F651 Catalog

Defining External Tables 587 file:// Protocol 590 gpfdist:// Protocol 590 gpfdists:// Protocol 591 VMware Tanzu Greenplum 6 Documentation VMware, Inc 25 pxf:// Protocol 592 s3:// Protocol 593 Configuring algorithm. SSL parameters cannot be changed. VMware Tanzu Greenplum 6 Documentation VMware, Inc 591 SSL renegotiation is supported. The SSL ignore host mismatch parameter is set to false. Private |F555|Enhanced seconds precision|YES| | |F561|Full value expressions|YES| | |F571|Truth value tests|YES| | |F591|Derived tables|YES| | |F611|Indicator data types|YES| | |F641|Row and table constructors|NO| | |F651|Catalog

select list of a SELECT command. For example: VMware Greenplum 7 Documentation VMware by Broadcom 591 SELECT count(*) OVER(PARTITION BY customer_id), * FROM sales; If FILTER is specified, then only the |F555|Enhanced seconds precision|YES| | |F561|Full value expressions|YES| | |F571|Truth value tests|YES| | |F591|Derived tables|YES| | |F611|Indicator data types|YES| | |F641|Row and table constructors|NO| | |F651|Catalog |T572|Multiset-returning external SQL-invoked functions|NO| | |T581|Regular expression substring function|YES| | |T591|UNIQUE constraints of possibly null columns|YES| | |T601|Local cursor references|NO| | |T611|Elementary

Features. Variable names are case-sensitive. VMware Tanzu Greenplum 6 Documentation VMware, Inc 591 Although you are welcome to set any variable to anything you want, psql treats several variables |F555|Enhanced seconds precision|YES| | |F561|Full value expressions|YES| | |F571|Truth value tests|YES| | |F591|Derived tables|YES| | |F611|Indicator data types|YES| | |F641|Row and table constructors|NO| | |F651|Catalog |T572|Multiset-returning external SQL- invoked functions|NO| | |T581|Regular expression substring function|YES| | |T591|UNIQUE constraints VMware Tanzu Greenplum 6 Documentation VMware, Inc 1978 of possibly null columns|YES|