Re: [I] [Bug] Failed to load data with singlenode mode using `insert into ... select ...` [cloudberry]

["avamingli (via GitHub)" <gi...@apache.org>]

avamingli commented on issue #1045:
URL: https://github.com/apache/cloudberry/issues/1045#issuecomment-2887002682

   > postgres=# CREATE TABLE t1 (c1 int) with (appendonly=true, orientation=column);
   > CREATE TABLE
   > postgres=# CREATE EXTERNAL TABLE ext_t1 (like t1)
   > postgres-# LOCATION ('file://hashdata/home/gpadmin/data/data/tpcds10s/t1.dat')
   > postgres-# FORMAT 'TEXT' (DELIMITER '|' NULL AS '' ESCAPE AS E'\\');
   > CREATE EXTERNAL TABLE
   > postgres=# insert into t1 select * from ext_t1;
   > ERROR:  'ON COORDINATOR' is not supported by this protocol yet
   
   This is expected. 
   
   The file protocol is not supported on the master node. In a single-node deployment, CBDB operates similarly to a single master node.
   
   Recommended Solutions:
   1. Use the COPY command to import files when working on the master node or in single-node mode.
   2. If you must use a protocol, consider implementing a custom protocol instead.
   Reference: [contrib/extprotocol](https://github.com/apache/cloudberry/tree/9f9d297c83567bd78ca0488ecf6a8f9cbc7a15d3/contrib/extprotocol)
   


-- 
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: commits-unsubscribe@cloudberry.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cloudberry.apache.org
For additional commands, e-mail: commits-help@cloudberry.apache.org