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

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

     [ https://issues.apache.org/jira/browse/HAWQ-1730?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ruilong Huo reopened HAWQ-1730:
-------------------------------

> 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: Ruilong Huo
>            Priority: Major
>             Fix For: 2.5.0.0
>
>
> Step 1. create writable external table
> {code}
> 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 
> {code}
> Step 2. insert into external table select from internal table
> {code}
> test =# INSERT INTO orders_test_history_ext SELECT * FROM orders_test_history;
> INSERT 0 16653485
> Time: 141921.662 ms
> {code}
> Step 3. check data in external table
> {code}
> $ wc -l /data/hawq/orders_test_history_ext
> 6737 /data/hawq/orders_test_history_ext
> {code}



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