Extensions Compatibility 252 Client Tools 252 Extensions 253 Data Connectors 253 Tanzu Greenplum Text 254 Greenplum Command Center 255 VMware Tanzu Greenplum 6 Documentation VMware, Inc 10 Hadoop Clause 457 Mapping the FORMAT Options 459 Example gphdfs to pxf External Table Mapping for an HDFS Text File 459 Verifying Access with PXF 460 Removing the gphdfs External Tables 460 Revoking Privileges 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 in CSV format with header

Extensions Compatibility 290 Client Tools 290 Extensions 290 Data Connectors 291 VMware Greenplum Text 292 Greenplum Command Center 293 Hardware Requirements 293 VMware Greenplum on DCA Systems 293 Clause 468 Mapping the FORMAT Options 469 Example gphdfs to pxf External Table Mapping for an HDFS Text File 470 Verifying Access with PXF 470 Removing the gphdfs External Tables 470 Revoking Privileges 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 in CSV format with header

Extensions Compatibility 260 Client Tools 260 Extensions 261 Data Connectors 261 VMware Greenplum Text 262 Greenplum Command Center 263 Hadoop Distributions 263 Public Cloud Requirements 263 Operating Clause 474 Mapping the FORMAT Options 475 Example gphdfs to pxf External Table Mapping for an HDFS Text File 475 Verifying Access with PXF 476 Removing the gphdfs External Tables 476 Revoking Privileges 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 in CSV format with header

Extensions Compatibility 278 Client Tools 278 Extensions 279 Data Connectors 279 VMware Greenplum Text 281 Greenplum Command Center 281 Hadoop Distributions 281 Public Cloud Requirements 281 Operating Clause 449 Mapping the FORMAT Options 450 Example gphdfs to pxf External Table Mapping for an HDFS Text File 451 Verifying Access with PXF 451 Removing the gphdfs External Tables 451 Revoking Privileges 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 in CSV format with header

Extensions Compatibility 248 Client Tools 248 Extensions 249 Data Connectors 250 Tanzu Greenplum Text 251 Greenplum Command Center 251 Hadoop Distributions 251 Greenplum Database Cloud Technical Recommendations Clause 455 Mapping the FORMAT Options 456 Example gphdfs to pxf External Table Mapping for an HDFS Text File 456 Verifying Access with PXF 457 Removing the gphdfs External Tables 457 Revoking Privileges 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 in CSV format with header

Extensions Compatibility 0 Client Tools 147 Extensions 147 Data Connectors 148 Tanzu Greenplum Text 149 Greenplum Command Center 149 Hadoop Distributions 149 VMware Tanzu Greenplum 6.x Release Notes Integrated Analytics Ecosystem 392 Machine Learning and Deep Learning 392 Geospatial Analytics 393 Text Analytics 393 Programming Language Extensions 393 Why Greenplum Database in Integrated Analytics Checking the PostGIS Version 424 Notes 425 Text Analytics and Search 425 Text Analytics and Search 0 Greenplum Database Full Text Search 425 Tanzu Greenplum Text 425 Procedural Languages 425 Procedural

Extensions Compatibility 0 Client Tools 146 Extensions 146 Data Connectors 147 Tanzu Greenplum Text 148 Greenplum Command Center 148 Hadoop Distributions 148 VMware Tanzu Greenplum 6.x Release Notes Integrated Analytics Ecosystem 383 Machine Learning and Deep Learning 383 Geospatial Analytics 384 Text Analytics 384 Programming Language Extensions 384 Why Greenplum Database in Integrated Analytics Checking the PostGIS Version 415 Notes 416 Text Analytics and Search 416 Text Analytics and Search 0 Greenplum Database Full Text Search 416 Tanzu Greenplum Text 416 Procedural Languages 416 Procedural

Extensions Compatibility 225 Client Tools 226 Extensions 226 Data Connectors 227 Tanzu Greenplum Text 228 Greenplum Command Center 228 Hadoop Distributions 228 Greenplum Database Cloud Technical Recommendations Clause 384 Mapping the FORMAT Options 385 Example gphdfs to pxf External Table Mapping for an HDFS Text File 385 Verifying Access with PXF 386 Removing the gphdfs External Tables 386 Revoking Privileges 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 in CSV format with header

Extensions Compatibility 140 Client Tools 141 Extensions 141 Data Connectors 142 Tanzu Greenplum Text 143 Greenplum Command Center 143 Hadoop Distributions 143 VMware Tanzu Greenplum 6.17 Release Notes Integrated Analytics Ecosystem 318 Machine Learning and Deep Learning 318 Geospatial Analytics 319 Text Analytics 319 Programming Language Extensions 319 Why Greenplum Database in Integrated Analytics Notes 351 Text Analytics and Search 351 Text Analytics and Search 0 VMware Greenplum v6.17 Documentation VMware, Inc. 16 Greenplum Database Full Text Search 351 Tanzu Greenplum Text 351 Procedural

instance with error logging 444 VMware Greenplum 7 Documentation VMware by Broadcom 18 Example 5—TEXT Format on a Hadoop Distributed File Server 445 Example 6—Multiple files in CSV format with header 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 Data between 554 Formatting Data Files 554 Formatting Rows 555 Formatting Columns 555 VMware Greenplum 7 Documentation VMware by Broadcom 23 Representing NULL Values 555 Escaping 555 Escaping in Text Formatted