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)