[
https://issues.apache.org/jira/browse/HAWQ-1145?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Chunling Wang closed HAWQ-1145.
-------------------------------
> After registering a partition table, if we want to insert some data into the
> table, it fails.
> ---------------------------------------------------------------------------------------------
>
> Key: HAWQ-1145
> URL: https://issues.apache.org/jira/browse/HAWQ-1145
> Project: Apache HAWQ
> Issue Type: Bug
> Components: Command Line Tools
> Affects Versions: 2.1.0.0-incubating
> Reporter: Lili Ma
> Assignee: Chunling Wang
> Fix For: 2.1.0.0-incubating
>
> Attachments: dbgen, dists.dss
>
>
> Reproduce Steps:
> 1. Create a partition table
> {code}
> CREATE TABLE parquet_LINEITEM_uncompressed(
>
>
>
> L_ORDERKEY INT8,
>
>
>
> L_PARTKEY BIGINT,
>
>
>
> L_SUPPKEY BIGINT,
>
>
>
> L_LINENUMBER BIGINT,
>
>
>
> L_QUANTITY decimal,
>
>
>
> L_EXTENDEDPRICE decimal,
>
>
>
> L_DISCOUNT decimal,
>
>
>
> L_TAX decimal,
>
>
>
> L_RETURNFLAG CHAR(1),
>
>
>
> L_LINESTATUS
> CHAR(1),
>
>
>
> L_SHIPDATE date,
>
>
>
> L_COMMITDATE date,
>
>
>
> L_RECEIPTDATE date,
>
>
>
> L_SHIPINSTRUCT CHAR(25),
>
>
>
> L_SHIPMODE CHAR(10),
>
>
>
> L_COMMENT VARCHAR(44)
>
>
>
> )
>
>
>
> with (appendonly=true, orientation=parquet)
>
>
>
> partition by range (l_commitdate) (start('1992-01-31') end('1998-11-01')
> every(interval '1 years'));
> {code}
> 2. copy some data into it.
> {code}
> copy parquet_lineitem_uncompressed from '/Users/malili/tpch/lineitem_1g' with
> delimiter '|';
> {code}
> 3. extract the table out to a yaml configuration file
> {code}
> hawq extract -d postgres -o ~/partition.yml parquet_lineitem_uncompressed
> {code}
> 4. register into a new table
> {code}
> hawq register -d postgres -c ~/partition.yml parquet2
> {code}
> 5. select from the new table
> {code}
> select count(*) from parquet2;
> {code}
> 6. insert new data into the new table
> {code}
> postgres=# copy parquet2 from '/Users/malili/tpch/lineitem_1g' with delimiter
> '|';
> ERROR: Unexpected internal error (cdbparquetstoragewrite.c:840) (seg0
> localhost:40000 pid=60757)
> CONTEXT: COPY parquet2, line 6:
> "1|15635|638|6|32|49620.16|0.07|0.02|N|O|1996-01-30|1996-02-07|1996-02-03|DELIVER
> IN PERSON|MAIL|aref..."
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
