hawq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lili Ma <...@pivotal.io>
Subject Re: HAWQ register error if create table DDL without specifying distributed by (column)
Date Mon, 12 Dec 2016 15:46:43 GMT
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