hawq-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From George Lu <luwenbin...@gmail.com>
Subject Re: HAWQ register error if create table DDL without specifying distributed by (column)
Date Sat, 10 Dec 2016 04:31:58 GMT
Hi Lili and Hong,

Thanks a lot for your help!
I tried the SQL to get bucket num. The result is 42.

Thanks for the code explanation also.

Regards,
Lu Wenbin

On Sat, Dec 10, 2016 at 11:38 AM, Hong Wu <xunzhangthu@gmail.com> wrote:

> Hi Wenbin,
>
> So glad that you are using the very fresh feature inside HDB 2.1.0!
> "hawqregister" supports registering a one-level partition table in this
> release. You can register a hash distributed table to a hash distributed
> table, a randomly distributed table to a randomly distributed table, a hash
> distributed table to a hash distributed table. But you can not register a
> randomly distributed table to a hash distributed table.
>
> For your case, the usage is exactly correct. According to your log file,
> it says
> "gpadmin-[ERROR]:-Bucket number of public.sales6_1_prt_1 is not
> consistent with previous bucket number." This is a pre-check in
> hawqregister, making sure that the bucketnum value from yaml file is
> consistent with destination table. For a randomly distributed table, this
> value is meaningless and in fact this check is unnecessary. But current
> implement also does the check in this case, using default values'
> consistency.
>
> I noticed that in your extracted yaml file "sales3.yml", the bucketnum is
> 42 so I guess in your environment, the default bucketnum is 42. Please
> check it with following SQLs:
>
> postgres=# select oid from pg_class where relnamespace='2200' and relname
> = 'sales2';
>
> postgres=# select bucketnum from gp_distribution_policy where localoid =
> 'oid';
>
> I think the output should be 42(the default bucket number guc value). To
> conclude, I think it is a bug of hawqregister code here
> <https://github.com/apache/incubator-hawq/blob/master/tools/bin/hawqregister#L530>.
> For randomly distributed table, the source bucket_num check value is set
> with fixed 6. We should modify it with the value in different HAWQ
> environment, or we can remove this check for registering randomly
> distributed table. I will do that fix asap.
> Thanks,
> Hong
>
> 2016-12-09 15:34 GMT+08:00 George Lu <luwenbin888@gmail.com>:
>
>> Dear all,
>>
>>
>>
>> I had a problem in hawq register in HDB 2.1.0 backed by Isilon HDFS on
>> HDP 2.5
>>
>>
>>
>> I created a one-level partitioned table:
>>
>> create table sales2( amount numeric(10,2), year integer)
>> with(appendonly=true) distributed randomly partition by range(year)
>> (start(2014) end (2016) every(1));
>>
>> then insert two records into that.
>>
>>
>>
>> After that, I use "hawq extract -d testdb -o sales2.yml sale2" to extract
>> the table metadata.
>>
>>
>>
>> Then I use "hawq register -d testdb --config sales2.yml sales6" to
>> register the HDFS into a new (not existing) table sales6.
>>
>> I met below errors:
>>
>> 20161209:07:07:10:081923 hawqregister:kevi41hwxworker0:gpadmin-[INFO]:-try
>> to connect database localhost:5432 testdb
>>
>> 20161209:07:07:10:081923 hawqregister:kevi41hwxworker0:gpadmin-[INFO]:-Files
>> check...
>>
>> 20161209:07:07:13:081923 hawqregister:kevi41hwxworker0:gpadmin-[INFO]:-Files
>> check done.
>>
>> 20161209:07:07:13:081923 hawqregister:kevi41hwxworker0:gpadmin-[INFO]:-Files
>> check for table sales2_1_prt_1...
>>
>> 20161209:07:07:15:081923 hawqregister:kevi41hwxworker0:gpadmin-[INFO]:-Files
>> check done for table sales2_1_prt_1.
>>
>> 20161209:07:07:15:081923 hawqregister:kevi41hwxworker0:gpadmin-[INFO]:-Files
>> check for table sales2_1_prt_2...
>>
>> 20161209:07:07:17:081923 hawqregister:kevi41hwxworker0:gpadmin-[INFO]:-Files
>> check done for table sales2_1_prt_2.
>>
>> 20161209:07:07:22:081923 hawqregister:kevi41hwxworker0:gpadmin-[INFO]:-New
>> file(s) to be registered: ['hdfs://kevinhwx12061712.bdl0
>> 2.shanghai.dev:8020/hawq_default/16385/16508/16910/1']
>>
>> 20161209:07:07:25:081923 hawqregister:kevi41hwxworker0:gpadmin-[ERROR]:-Bucket
>> number of public.sales6_1_prt_1 is not consistent with previous bucket
>> number.
>>
>> 20161209:07:07:25:081923 hawqregister:kevi41hwxworker0:gpadmin-[INFO]:-Error
>> found, Hawqregister starts to rollback...
>>
>> 20161209:07:07:25:081923 hawqregister:kevi41hwxworker0:gpadmin-[INFO]:-Hawq
>> Register Rollback Finished.
>>
>>
>>
>> *However*, if I created the table like:
>>
>> create table sales3(id int, amount numeric(10,2), year integer)
>> with(appendonly=true) *distributed by* (id) partition by range(year)
>> (start(2014) end (2016) every(1));
>>
>> And the extract and register works properly.
>>
>> I have pasted the sales3.yml in below.
>>
>>
>>
>> Please kindly help to check what is the problem and do I need to specify
>> the distributed by (column) in the Create Table DDL if I want to use hawq
>> register for one-level partitioned table?
>>
>>
>>
>> Thanks!
>>
>>
>>
>> Regards,
>>
>> Lu Wenbin
>>
>>
>>
>> ============================================================
>> ===============
>>
>> 1) Sales schema by pg_dump -d testdb -t sales2 --schema-only
>>
>> --inserts is preferred over -d.  -d is deprecated.
>>
>> --
>>
>> -- Greenplum Database database dump
>>
>> --
>>
>>
>>
>> SET statement_timeout = 0;
>>
>> SET client_encoding = 'UTF8';
>>
>> SET standard_conforming_strings = off;
>>
>> SET check_function_bodies = false;
>>
>> SET client_min_messages = warning;
>>
>> SET escape_string_warning = off;
>>
>> SET gp_enable_column_oriented_table = true;
>>
>>
>>
>> SET default_with_oids = false;
>>
>>
>>
>> --
>>
>> -- Name: GPDUMPGUC; Type: INTERNAL GUC; Schema: -; Owner:
>>
>> --
>>
>>
>>
>> SET gp_called_by_pgdump = true;
>>
>>
>>
>>
>>
>> SET search_path = public, pg_catalog;
>>
>>
>>
>> SET default_tablespace = '';
>>
>>
>>
>> --
>>
>> -- Name: sales2; Type: TABLE; Schema: public; Owner: gpadmin; Tablespace:
>>
>> --
>>
>>
>>
>> CREATE TABLE sales2 (
>>
>>     amount numeric(10,2),
>>
>>     year integer
>>
>> )
>>
>> WITH (appendonly=true) DISTRIBUTED RANDOMLY PARTITION BY RANGE(year)
>>
>>           (
>>
>>           START (2014) END (2015) EVERY (1) WITH
>> (tablename='sales2_1_prt_1', orientation=row , appendonly=true ),
>>
>>           START (2015) END (2016) EVERY (1) WITH
>> (tablename='sales2_1_prt_2', orientation=row , appendonly=true )
>>
>>           );
>>
>>
>>
>>
>>
>> ALTER TABLE public.sales2 OWNER TO gpadmin;
>>
>>
>>
>> --
>>
>> -- Greenplum Database database dump complete
>>
>> --
>>
>>
>>
>> 2) Sales2.yml
>>
>> AO_FileLocations:
>>
>>   Blocksize: 32768
>>
>>   Checksum: false
>>
>>   CompressionLevel: 0
>>
>>   CompressionType: null
>>
>>   Files:
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16910/1
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   PartitionBy: PARTITION BY range (year)
>>
>>   Partitions:
>>
>>   - Blocksize: 32768
>>
>>     Checksum: false
>>
>>     CompressionLevel: 0
>>
>>     CompressionType: null
>>
>>     Constraint: START (2014) END (2015) EVERY (1) WITH (appendonly=true)
>>
>>     Files:
>>
>>     - eofuncompressed: 32
>>
>>       path: /hawq_default/16385/16508/16915/1
>>
>>       size: 32
>>
>>       tupcount: 1
>>
>>       varblockcount: 1
>>
>>     Name: sales2_1_prt_1
>>
>>   - Blocksize: 32768
>>
>>     Checksum: false
>>
>>     CompressionLevel: 0
>>
>>     CompressionType: null
>>
>>     Constraint: START (2015) END (2016) EVERY (1) WITH (appendonly=true)
>>
>>     Files:
>>
>>     - eofuncompressed: 32
>>
>>       path: /hawq_default/16385/16508/16921/1
>>
>>       size: 32
>>
>>       tupcount: 1
>>
>>       varblockcount: 1
>>
>>     Name: sales2_1_prt_2
>>
>> AO_Schema:
>>
>> - name: amount
>>
>>   type: numeric
>>
>> - name: year
>>
>>   type: int4
>>
>> DBVersion: PostgreSQL 8.2.15 (Greenplum Database 4.2.0 build 1) (HAWQ
>> 2.1.0.0 build
>>
>>   2490) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.8.2
>> 20140120 (Red
>>
>>   Hat 4.8.2-15) compiled on Nov 30 2016 03:44:46
>>
>> DFS_URL: hdfs://kevinhwx12061712.bdl02.shanghai.dev:8020
>>
>> Distribution_Policy: DISTRIBUTED RANDOMLY
>>
>> Encoding: UTF8
>>
>> FileFormat: AO
>>
>> TableName: public.sales2
>>
>> Version: 1.0.0
>>
>>
>>
>> 3) sales3 schema
>>
>>  --inserts is preferred over -d.  -d is deprecated.
>>
>> --
>>
>> -- Greenplum Database database dump
>>
>> --
>>
>>
>>
>> SET statement_timeout = 0;
>>
>> SET client_encoding = 'UTF8';
>>
>> SET standard_conforming_strings = off;
>>
>> SET check_function_bodies = false;
>>
>> SET client_min_messages = warning;
>>
>> SET escape_string_warning = off;
>>
>> SET gp_enable_column_oriented_table = true;
>>
>>
>>
>> SET default_with_oids = false;
>>
>>
>>
>> --
>>
>> -- Name: GPDUMPGUC; Type: INTERNAL GUC; Schema: -; Owner:
>>
>> --
>>
>>
>>
>> SET gp_called_by_pgdump = true;
>>
>>
>>
>>
>>
>> SET search_path = public, pg_catalog;
>>
>>
>>
>> SET default_tablespace = '';
>>
>>
>>
>> --
>>
>> -- Name: sales3; Type: TABLE; Schema: public; Owner: gpadmin; Tablespace:
>>
>> --
>>
>>
>>
>> CREATE TABLE sales3 (
>>
>>     id integer,
>>
>>     amount numeric(10,2),
>>
>>     year integer
>>
>> )
>>
>> WITH (appendonly=true) DISTRIBUTED BY (id) PARTITION BY RANGE(year)
>>
>>           (
>>
>>           START (2014) END (2015) EVERY (1) WITH
>> (tablename='sales3_1_prt_1', orientation=row , appendonly=true ),
>>
>>           START (2015) END (2016) EVERY (1) WITH
>> (tablename='sales3_1_prt_2', orientation=row , appendonly=true )
>>
>>           );
>>
>>
>>
>>
>>
>> ALTER TABLE public.sales3 OWNER TO gpadmin;
>>
>>
>>
>> --
>>
>> -- Greenplum Database database dump complete
>>
>> --
>>
>>
>>
>> 4) sales3.yml
>>
>> AO_FileLocations:
>>
>>   Blocksize: 32768
>>
>>   Checksum: false
>>
>>   CompressionLevel: 0
>>
>>   CompressionType: null
>>
>>   Files:
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/1
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/2
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/3
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/4
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/5
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/6
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/7
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/8
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/9
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/10
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/11
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/12
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/13
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/14
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/15
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/16
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/17
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/18
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/19
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/20
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/21
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/22
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/23
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/24
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/25
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/26
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/27
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/28
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/29
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/30
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/31
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/32
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/33
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/34
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/35
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/36
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/37
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/38
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/39
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/40
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/41
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   - eofuncompressed: 0
>>
>>     path: /hawq_default/16385/16508/16970/42
>>
>>     size: 0
>>
>>     tupcount: 0
>>
>>     varblockcount: 0
>>
>>   PartitionBy: PARTITION BY range (year)
>>
>>   Partitions:
>>
>>   - Blocksize: 32768
>>
>>     Checksum: false
>>
>>     CompressionLevel: 0
>>
>>     CompressionType: null
>>
>>     Constraint: START (2014) END (2015) EVERY (1) WITH (appendonly=true)
>>
>>     Files:
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/1
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/2
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/3
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/4
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/5
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/6
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/7
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/8
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/9
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/10
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/11
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/12
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/13
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/14
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/15
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/16
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/17
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/18
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/19
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/20
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/21
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/22
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/23
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/24
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/25
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/26
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/27
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/28
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/29
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/30
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 32
>>
>>       path: /hawq_default/16385/16508/16975/31
>>
>>       size: 32
>>
>>       tupcount: 1
>>
>>       varblockcount: 1
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/32
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/33
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/34
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/35
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/36
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/37
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/38
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/39
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/40
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/41
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16975/42
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     Name: sales3_1_prt_1
>>
>>   - Blocksize: 32768
>>
>>     Checksum: false
>>
>>     CompressionLevel: 0
>>
>>     CompressionType: null
>>
>>     Constraint: START (2015) END (2016) EVERY (1) WITH (appendonly=true)
>>
>>     Files:
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/1
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/2
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/3
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/4
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/5
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/6
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/7
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/8
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/9
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/10
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/11
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/12
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/13
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/14
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/15
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 32
>>
>>       path: /hawq_default/16385/16508/16981/16
>>
>>       size: 32
>>
>>       tupcount: 1
>>
>>       varblockcount: 1
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/17
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/18
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/19
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/20
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/21
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/22
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/23
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/24
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/25
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/26
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/27
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/28
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/29
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/30
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/31
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/32
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/33
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/34
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/35
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/36
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/37
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/38
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/39
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/40
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/41
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     - eofuncompressed: 0
>>
>>       path: /hawq_default/16385/16508/16981/42
>>
>>       size: 0
>>
>>       tupcount: 0
>>
>>       varblockcount: 0
>>
>>     Name: sales3_1_prt_2
>>
>> AO_Schema:
>>
>> - name: id
>>
>>   type: int4
>>
>> - name: amount
>>
>>   type: numeric
>>
>> - name: year
>>
>>   type: int4
>>
>> Bucketnum: 42
>>
>> DBVersion: PostgreSQL 8.2.15 (Greenplum Database 4.2.0 build 1) (HAWQ
>> 2.1.0.0 build
>>
>>   2490) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.8.2
>> 20140120 (Red
>>
>>   Hat 4.8.2-15) compiled on Nov 30 2016 03:44:46
>>
>> DFS_URL: hdfs://kevinhwx12061712.bdl02.shanghai.dev:8020
>>
>> Distribution_Policy: DISTRIBUTED BY (id)
>>
>> Encoding: UTF8
>>
>> FileFormat: AO
>>
>> TableName: public.sales3
>>
>> Version: 1.0.0
>>
>>
>

Mime
View raw message