[jira] [Updated] (HAWQ-147) Create Parquet table and insert data in template1 would cause CREATE DATABASE fail.

["Lirong Jian (JIRA)" <ji...@apache.org>]

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

Lirong Jian updated HAWQ-147:
-----------------------------
    Summary: Create Parquet table and insert data in template1 would cause CREATE DATABASE fail.  (was: pg_dumpall error when insert table into template1)

> Create Parquet table and insert data in template1 would cause CREATE DATABASE fail.
> -----------------------------------------------------------------------------------
>
>                 Key: HAWQ-147
>                 URL: https://issues.apache.org/jira/browse/HAWQ-147
>             Project: Apache HAWQ
>          Issue Type: Bug
>          Components: Command Line Tools
>            Reporter: Dong Li
>            Assignee: Lirong Jian
>
> When run commands below:
> mkdir cdbfast_pgbkup
> psql -d postgres
> {code}
> \c template1
> CREATE TABLE mpp7191 (a int, b date, c char,
>                      d char(4), e varchar(20), f timestamp)
> WITH (orientation=parquet,appendonly=true)
> partition by range (b)
> subpartition by list (a)
> subpartition template (
> subpartition l1 values (1,2,3,4,5),
> subpartition l2 values (6,7,8,9,10) ),
> subpartition by list (e)
> subpartition template (
> subpartition ll1 values ('Engineering'),
> subpartition ll2 values ('QA') ),
> subpartition by list (c)
> subpartition template (
> subpartition lll1 values ('M'),
> subpartition lll2 values ('F') )
> (
>   start (date '2007-01-01')
>   end (date '2010-01-01') every (interval '1 year')
> );
> insert into mpp7191 VALUES (1,'2007-01-01','M','11','QA','2001-02-16 20:38:40');
> {code}
> pg_dumpall > ./cdbfast_pgbkup/bkupall
> psql -d gptest -f  ./cdbfast_pgbkup/bkupall
>  ERROR:  Append-Only relation 'mpp7191' gp_relation_node entry for segment file #1 without an aoseg entry (case #2) (cdbdatabaseinfo.c:1537)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)