Hi Lili, Greatly appreciates your help!!
Thanks! Regards, Lu Wenbin On Mon, Dec 12, 2016 at 11:46 PM, Lili Ma <l...@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 <luwenbin...@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 <xunzhang...@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 <luwenbin...@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 >>>> >>>> >>> >> >