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, 17 Dec 2016 01:35:18 GMT
Hi Supriya Biswas,

To remove your address from the list, send a message to:

  <dev-unsubscribe@hawq.incubator.apache.org>

I think you will receive a confirm email if it works. If it doesn't work,
send mail to the following for info and FAQ for this list:

  <dev-info@hawq.incubator.apache.org>

  <dev-faq@hawq.incubator.apache.org>


Hong

2016-12-13 22:10 GMT+08:00 Supriya Biswas <supriya.biswas@nielsen.com>:

> I DO NOT WANT TO RECEIVE ANY MAIL.
>
> I UN-SUBSCRIBED IT BUT, STILL RECEIVING MAIL.
>
> ** PLEASE HELP BY REMOVING ME FROM THE MAILING LIST **
>
>
> *Supriyo Biswas *Architect
> The Nielsen Company
> Office (516) 682-6021/NETS 249-6021
>
> Cell    (516) 353-6795
> www.nielsen.com
>
> On Tue, Dec 13, 2016 at 12:42 AM, Wenbin Lu <luwenbin888@gmail.com> wrote:
>
>> Hi Lili,
>>
>> Greatly appreciates your help!!
>>
>> Thanks!
>>
>> Regards,
>> Lu Wenbin
>>
>> On Mon, Dec 12, 2016 at 11:46 PM, Lili Ma <lma@pivotal.io> wrote:
>>
>>> Hi George,
>>>
>>> We have fixed the bug in current HAWQ master branch.  And you can use a
>>> temp workaround as this: If you want to register to a randomly distributed
>>> table, you can set default_hash_table_bucket_number to 6 before
>>> creating the DDL.
>>>
>>> Any further questions, please do not hesitate to let us know!
>>>
>>> Thanks
>>> Lili
>>>
>>> On Sat, Dec 10, 2016 at 12:31 PM, George Lu <luwenbin888@gmail.com>
>>> wrote:
>>>
>>>> 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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message