User Guide Table of contents General User Guide DBeaver User Guide 23.0. Page 3 of 451. SQL Formatting SQL Execution SQL Terminal Variables panel Query Execution Plan Visual Query Builder Script ER Diagrams Database Structure Diagrams Custom Diagrams Edit mode Search File Search DB Full-Text Search DB Metadata Search Schema compare Data compare MockData generation Dashboards, DB monitoring parts of the SQL code and apply generic commands such as copy-paste or SQL-specific commands like formatting – using the context menu. To open the context menu, right-click the SQL code. See for information

Formats Virtual column expressions SQL Editor SQL Templates SQL Assist and Auto-Complete SQL Formatting User Guide Table of contents General User Guide DBeaver User Guide 22.3. Page 3 of 425. SQL ER Diagrams Database Structure Diagrams Custom Diagrams Edit mode Search File Search DB Full-Text Search DB Metadata Search Schema compare Data compare MockData generation Dashboards, DB monitoring parts of the SQL code and apply generic commands such as copy-paste or SQL-specific commands like formatting – using the context menu. To open the context menu, right-click the SQL code. See for information

Formats Virtual column expressions SQL Editor SQL Templates SQL Assist and Auto-Complete SQL Formatting User Guide Table of contents General User Guide DBeaver User Guide 22.2. Page 3 of 423. SQL ER Diagrams Database Structure Diagrams Custom Diagrams Edit mode Search File Search DB Full-Text Search DB Metadata Search Schema compare Data compare MockData generation Dashboards, DB monitoring parts of the SQL code and apply generic commands such as copy-paste or SQL-specific commands like formatting – using the context menu. To open the context menu, right-click the SQL code. See for information

Formats Virtual column expressions SQL Editor SQL Templates SQL Assist and Auto-Complete SQL Formatting User Guide Table of contents General User Guide DBeaver User Guide 22.1. Page 3 of 403. SQL ER Diagrams Database Structure Diagrams Custom Diagrams Edit mode Search File Search DB Full-Text Search DB Metadata Search Schema compare Data compare MockData generation Dashboards, DB monitoring parts of the SQL code and apply generic commands such as copy-paste or SQL-specific commands like formatting – using the context menu. To open the context menu, right-click the SQL code. See for information

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