You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hawq.apache.org by "lynn (JIRA)" <ji...@apache.org> on 2017/11/10 07:24:00 UTC

[jira] [Created] (HAWQ-1546) The data files on hdfs after hawq load data were too large!!!

lynn created HAWQ-1546:
--------------------------

             Summary: The data files on hdfs after hawq load data were too large!!!
                 Key: HAWQ-1546
                 URL: https://issues.apache.org/jira/browse/HAWQ-1546
             Project: Apache HAWQ
          Issue Type: Bug
          Components: libhdfs
            Reporter: lynn
            Assignee: Radar Lei


create table person_l1 (id int, name varchar(20), age int, sex char(1))with(appendonly=true,orientation=parquet,compresstype=snappy);

create table person_l2 (id int, name varchar(20), age int, sex char(1))with(appendonly=true,orientation=parquet,compresstype=snappy);

执行480次插入语句:
sh insert.sh

执行1次插入语句:
1920条数据
 psql -d test -f i1.sql 

select sotdtablename, sotdsize from hawq_toolkit.hawq_size_of_table_disk where sotdtablename like 'person_%';





--
This message was sent by Atlassian JIRA
(v6.4.14#64029)