hawq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hong Wu <xunzhang...@gmail.com>
Subject Re: HAWQ register error if create table DDL without specifying distributed by (column)
Date Sat, 10 Dec 2016 03:38:57 GMT
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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message