You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "Ruilong Huo (JIRA)" <ji...@apache.org> on 2019/07/23 08:29:00 UTC
[jira] [Updated] (HAWQ-1730) missing data when inserting into
external table select from internal table
[ https://issues.apache.org/jira/browse/HAWQ-1730?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ruilong Huo updated HAWQ-1730:
------------------------------
Description:
Step 1. create writable external table
{code}
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
{code}
Step 2. insert into external table select from internal table
{code}
test =# INSERT INTO orders_test_his_ext SELECT * FROM orders_test_his;
INSERT 0 16653485
Time: 141921.662 ms
{code}
Step 3. check data in external table
{code}
$ wc -l /data/hawq/orders_tests_his
6737 /data/hawq/orders_test_his
{code}
was:
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
```
> 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
> Priority: Major
>
> Step 1. create writable external table
> {code}
> 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
> {code}
> Step 2. insert into external table select from internal table
> {code}
> test =# INSERT INTO orders_test_his_ext SELECT * FROM orders_test_his;
> INSERT 0 16653485
> Time: 141921.662 ms
> {code}
> Step 3. check data in external table
> {code}
> $ wc -l /data/hawq/orders_tests_his
> 6737 /data/hawq/orders_test_his
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)