tuhaihe commented on code in PR #52: URL: https://github.com/apache/cloudberry-pxf/pull/52#discussion_r2767345551
########## docs/content/hdfs_orc.html.md.erb: ########## @@ -137,7 +137,7 @@ FORMAT 'CUSTOM' (FORMATTER='pxfwritable_import'|'pxfwritable_export') [DISTRIBUTED BY (<column_name> [, ... ] ) | DISTRIBUTED RANDOMLY]; ``` -The specific keywords and values used in the Greenplum Database [CREATE EXTERNAL TABLE](https://docs.vmware.com/en/VMware-Greenplum/6/greenplum-database/ref_guide-sql_commands-CREATE_EXTERNAL_TABLE.html) command are described below. +The specific keywords and values used in the Apache Cloudberry Database [CREATE EXTERNAL TABLE](https://cloudberry.apache.org/docs/sql-stmts/create-external-table) command are described below. Review Comment: ```suggestion The specific keywords and values used in the Apache Cloudberry [CREATE EXTERNAL TABLE](https://cloudberry.apache.org/docs/sql-stmts/create-external-table) command are described below. ``` ########## docs/content/hdfs_orc.html.md.erb: ########## @@ -148,6 +148,31 @@ The specific keywords and values used in the Greenplum Database [CREATE EXTERNAL | FORMAT 'CUSTOM' | Use `FORMAT 'CUSTOM'`with `(FORMATTER='pxfwritable_export')` (write) or `(FORMATTER='pxfwritable_import')` (read). | | DISTRIBUTED BY | If you want to load data from an existing Greenplum Database table into the writable external table, consider specifying the same distribution policy or `<column_name>` on both tables. Doing so will avoid extra motion of data between segments on the load operation. | +## <a id="profile_cfdw"></a>Creating the Foreign Table + +The PXF HDFS `hdfs_pxf_fdw` foreign data wrapper supports reading and writing ORC-formatted HDFS files. When you insert records into a foreign table, the block(s) of data that you insert are written to one file per segment in the directory that you specified in the `resource` clause. + +Use the following syntax to create an Apache Cloudberry Database foreign table that references an HDFS file or directory: Review Comment: ```suggestion Use the following syntax to create an Apache Cloudberry foreign table that references an HDFS file or directory: ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
