You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "Lili Ma (JIRA)" <ji...@apache.org> on 2016/11/03 09:03:59 UTC
[jira] [Updated] (HAWQ-1145) After registering a partition table,
if we want to insert some data into the table, it fails.
[ https://issues.apache.org/jira/browse/HAWQ-1145?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Lili Ma updated HAWQ-1145:
--------------------------
Assignee: Hubert Zhang (was: Lei Chang)
> 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: Hubert Zhang
> 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)