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)

Reply via email to