[jira] [Created] (HAWQ-1730) missing data when inserting into external table select from internal table

["Ruilong Huo (JIRA)" <ji...@apache.org>]

Ruilong Huo created HAWQ-1730:
---------------------------------

             Summary: missing data when inserting into external table select from internal table
                 Key: HAWQ-1730
                 URL: https://issues.apache.org/jira/browse/HAWQ-1730
             Project: Apache HAWQ
          Issue Type: Bug
          Components: Query Execution, Storage
            Reporter: Ruilong Huo
            Assignee: Lei Chang


Step 1. create writable external table
```
test =# CREATE WRITABLE EXTERNAL TABLE public.orders_test_history_ext (LIKE public.orders_test_his) LOCATION ('gpfdist://localhost:8020/orders_test_his') 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_his_ext SELECT * FROM orders_test_his;
INSERT 0 16653485
Time: 141921.662 ms
```
Step 3. check data in external table
```
$ wc -l /data/hawq/orders_tests_his
6737 /data/hawq/orders_test_his
```



--
This message was sent by Atlassian JIRA
(v7.6.14#76016)