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 <[email protected]> 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 <[email protected]> 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 <[email protected]>: >> >>> 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 >>> >>> >> >
