Lili Ma created HAWQ-1145:
-----------------------------
Summary: 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
Reporter: Lili Ma
Assignee: Lei Chang
Fix For: 2.0.1.0-incubating
Reproduce Steps:
1. Create a partition table
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'));
2. copy some data into it.
copy parquet_lineitem_uncompressed from '/Users/malili/tpch/lineitem_1g' with
delimiter '|';
3. extract the table out to a yaml configuration file
hawq extract -d postgres -o ~/partition.yml parquet_lineitem_uncompressed
4. register into a new table
hawq register -d postgres -c ~/partition.yml parquet2
5. select from the new table
select count(*) from parquet2;
6. insert new data into the new table
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..."
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
