hawq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lili Ma (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HAWQ-1145) After registering a partition table, if we want to insert some data into the table, it fails.
Date Thu, 03 Nov 2016 09:02:58 GMT
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)

Mime
View raw message