hawq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "lynn (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HAWQ-1546) The data files on hdfs after hawq load data were too large!!!
Date Fri, 10 Nov 2017 07:24:00 GMT
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)

Mime
View raw message