Issues 207 Release 6.0.0 209 New Features 209 PostgreSQL Core Features 209 INTERVAL Data Type Handling 209 Additional PostgreSQL Features 210 Zstandard Compression Algorithm 210 Relaxed Rules for Software Package 435 Writing PL/Java functions 435 SQL Declaration 436 Type Mapping 436 NULL Handling 437 Complex Types 437 Returning Complex Types 438 Functions That Return Sets 438 Returning a Exception Handling 442 Savepoints 442 Logging 442 Security 0 Installation 443 Trusted Language 443 Some PL/Java Issues and Solutions 444 Multi-threading 444 Solution 444 Exception Handling 444 Solution

Issues 215 Release 6.0.0 216 New Features 217 PostgreSQL Core Features 217 INTERVAL Data Type Handling 217 Additional PostgreSQL Features 218 Zstandard Compression Algorithm 218 Relaxed Rules for Software Package 444 Writing PL/Java functions 445 SQL Declaration 445 Type Mapping 445 NULL Handling 446 Complex Types 447 Returning Complex Types 447 Functions That Return Sets 448 Returning a ResultSetProvider Interface 449 Using the ResultSetHandle Interface 450 Using JDBC 451 Exception Handling 451 Savepoints 452 VMware Greenplum v6.19 Documentation VMware, Inc. 22 Logging 452 Security

Issues 267 Release 6.0.0 269 New Features 269 PostgreSQL Core Features 269 INTERVAL Data Type Handling 269 Additional PostgreSQL Features 270 Zstandard Compression Algorithm 271 Relaxed Rules for 30 s3 Protocol Limitations 632 Using the gpcheckcloud Utility 632 Using a Custom Protocol 634 Handling Errors in External Table Data 634 Creating and Using External Web Tables 634 Command-based External – Create a writable external table with a \r\n line delimiter 736 Using a Custom Protocol 736 Handling Load Errors 738 Define an External Table with Single Row Error Isolation 739 Capture Row Formatting

Software Package 370 Writing PL/Java functions 370 SQL Declaration 371 Type Mapping 371 NULL Handling 372 Complex Types 372 Returning Complex Types 373 Functions That Return Sets 373 Returning a Exception Handling 377 Savepoints 377 Logging 377 Security 0 Installation 378 Trusted Language 378 Some PL/Java Issues and Solutions 379 Multi-threading 379 Solution 379 Exception Handling 379 Solution 399 VMware Greenplum v6.17 Documentation VMware, Inc. 19 plpy.execute 399 plpy.prepare 400 Handling Python Errors and Messages 400 Using the dictionary GD To Improve PL/Python Performance 401 Installing

Issues 254 Release 6.0.0 255 New Features 256 PostgreSQL Core Features 256 INTERVAL Data Type Handling 256 Additional PostgreSQL Features 257 Zstandard Compression Algorithm 257 Relaxed Rules for 602 s3 Protocol Limitations 603 Using the gpcheckcloud Utility 603 Using a Custom Protocol 605 Handling Errors in External Table Data 605 Creating and Using External Web Tables 605 VMware Greenplum – Create a writable external table with a \r\n line delimiter 707 Using a Custom Protocol 707 Handling Load Errors 708 Define an External Table with Single Row Error Isolation 709 Capture Row Formatting

Issues 212 Release 6.0.0 213 New Features 214 PostgreSQL Core Features 214 INTERVAL Data Type Handling 214 Additional PostgreSQL Features 215 Zstandard Compression Algorithm 215 Relaxed Rules for Software Package 439 Writing PL/Java functions 439 SQL Declaration 440 Type Mapping 440 NULL Handling 441 Complex Types 441 Returning Complex Types 442 Functions That Return Sets 442 Returning a Exception Handling 446 Savepoints 446 Logging 446 Security 447 Installation 447 Trusted Language 447 Some PL/Java Issues and Solutions 448 Multi-threading 448 Solution 448 Exception Handling 448 Solution

Issues 235 Release 6.0.0 237 New Features 237 PostgreSQL Core Features 237 INTERVAL Data Type Handling 237 Additional PostgreSQL Features 238 Zstandard Compression Algorithm 238 Relaxed Rules for 625 s3 Protocol Limitations 625 Using the gpcheckcloud Utility 626 Using a Custom Protocol 628 Handling Errors in External Table Data 628 Creating and Using External Web Tables 628 Command-based External – Create a writable external table with a \r\n line delimiter 728 Using a Custom Protocol 728 Handling Load Errors 729 Define an External Table with Single Row Error Isolation 730 Capture Row Formatting

Issues 228 Release 6.0.0 229 New Features 230 PostgreSQL Core Features 230 INTERVAL Data Type Handling 230 Additional PostgreSQL Features 231 Zstandard Compression Algorithm 231 Relaxed Rules for 602 s3 Protocol Limitations 603 Using the gpcheckcloud Utility 604 Using a Custom Protocol 605 Handling Errors in External Table Data 605 Creating and Using External Web Tables 606 Command-based External – Create a writable external table with a \r\n line delimiter 702 Using a Custom Protocol 702 Handling Load Errors 703 Define an External Table with Single Row Error Isolation 704 Capture Row Formatting

Issues 224 Release 6.0.0 226 New Features 226 PostgreSQL Core Features 227 INTERVAL Data Type Handling 227 Additional PostgreSQL Features 227 Zstandard Compression Algorithm 228 Relaxed Rules for 26 s3 Protocol Limitations 600 Using the gpcheckcloud Utility 601 Using a Custom Protocol 602 Handling Errors in External Table Data 603 Creating and Using External Web Tables 603 Command-based External – Create a writable external table with a \r\n line delimiter 700 Using a Custom Protocol 700 Handling Load Errors 702 Define an External Table with Single Row Error Isolation 703 Capture Row Formatting

s3 Protocol Limitations 439 Using the gpcheckcloud Utility 439 Creating a Custom Protocol 441 Handling Errors in External Table Data 441 Creating and Using External Web Tables 441 Command-based External – Create a writable external table with a \r\n line delimiter 532 Using a Custom Protocol 532 Handling Load Errors 533 Define an External Table with Single Row Error Isolation 534 Capture Row Formatting Transforms 628 jsonpath Type 628 Working with XML Data 630 Creating XML Values 630 Encoding Handling 631 Accessing XML Values 632 Processing XML 632 Mapping Tables to XML 633 XML Function Reference