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 instances 637 Example 3—Multiple gpfdists instances 637 Example 4—Single gpfdist instance with error logging 637 Example 5—TEXT Format on a Hadoop Distributed File Server 638 Example 6—Multiple files

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 instances 608 Example 3—Multiple gpfdists instances 608 Example 4—Single gpfdist instance with error logging 608 Example 5—TEXT Format on a Hadoop Distributed File Server 609 Example 6—Multiple files

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 instances 630 Example 3—Multiple gpfdists instances 631 Example 4—Single gpfdist instance with error logging 631 Example 5—TEXT Format on a Hadoop Distributed File Server 632 Example 6—Multiple files

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 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 instances 608 Example 3—Multiple gpfdists instances 608 Example 4—Single gpfdist instance with error logging 608 Example 5—TEXT Format on a Hadoop Distributed File Server 609 Example 6—Multiple files

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 instances 605 Example 3—Multiple gpfdists instances 605 Example 4—Single gpfdist instance with error logging 606 Example 5—TEXT Format on a Hadoop Distributed File Server 606 Example 6—Multiple files

Issues 204 Release 6.0.0 205 New Features 205 PostgreSQL Core Features 206 INTERVAL Data Type Handling 206 Additional PostgreSQL Features 206 Zstandard Compression Algorithm 207 Relaxed Rules for 513 s3 Protocol Limitations 514 Using the gpcheckcloud Utility 514 Using a Custom Protocol 516 Handling Errors in External Table Data 516 Creating and Using External Web Tables 516 Command-based External instances 518 Example 3—Multiple gpfdists instances 518 Example 4—Single gpfdist instance with error logging 519 Example 5—TEXT Format on a Hadoop Distributed File Server 519 Example 6—Multiple files

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 instances 444 Example 3—Multiple gpfdists instances 444 Example 4—Single gpfdist instance with error logging 444 VMware Greenplum 7 Documentation VMware by Broadcom 18 Example 5—TEXT Format on a Hadoop Protocol 532 Handling Load Errors 533 Define an External Table with Single Row Error Isolation 534 Capture Row Formatting Errors and Declare a Reject Limit 535 Viewing Bad Rows in the Error Log 535 Moving