[HAWQ-1730] missing data when inserting into external table select from internal table using gpfdist

• Type: Bug
• Status: Reopened
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: backlog
• Component/s: Query Execution, Storage
• Assignee: Ruilong Huo
• Reporter: Ruilong Huo
• Created: 23/Jul/19 08:28
• Updated: 31/Aug/21 01:07

Description

Step 1. create writable external table

test =# CREATE WRITABLE EXTERNAL TABLE public.orders_test_history_ext (LIKE public.orders_test_history) LOCATION ('gpfdist://localhost:8020/orders_test_history_ext') FORMAT
'TEXT'  (DELIMITER '^|^' NULL '');
NOTICE: Table doesn't have 'distributed by' clause, defaulting to distribution columns from LIKE table
CREATE EXTERNAL TABLE
Time: 803.315 ms 

Step 2. insert into external table select from internal table

test =# INSERT INTO orders_test_history_ext SELECT * FROM orders_test_history;
INSERT 0 16653485
Time: 141921.662 ms

Step 3. check data in external table

$ wc -l /data/hawq/orders_test_history_ext
6737 /data/hawq/orders_test_history_ext