Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id EE4AE200BE5 for ; Sat, 10 Dec 2016 04:39:16 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id ECECC160B1E; Sat, 10 Dec 2016 03:39:16 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 763D2160B1D for ; Sat, 10 Dec 2016 04:39:15 +0100 (CET) Received: (qmail 91180 invoked by uid 500); 10 Dec 2016 03:39:14 -0000 Mailing-List: contact dev-help@hawq.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hawq.incubator.apache.org Delivered-To: mailing list dev@hawq.incubator.apache.org Received: (qmail 90841 invoked by uid 99); 10 Dec 2016 03:39:13 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 10 Dec 2016 03:39:13 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 5F66E185F4D; Sat, 10 Dec 2016 03:39:13 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.88 X-Spam-Level: * X-Spam-Status: No, score=1.88 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id q2Z78jn6FJhu; Sat, 10 Dec 2016 03:39:05 +0000 (UTC) Received: from mail-oi0-f42.google.com (mail-oi0-f42.google.com [209.85.218.42]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 4B7825F47E; Sat, 10 Dec 2016 03:39:04 +0000 (UTC) Received: by mail-oi0-f42.google.com with SMTP id v84so38385044oie.3; Fri, 09 Dec 2016 19:39:04 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=i12beUnC3CCF24djyH0PYfg5RFsVrIygfQLvrmWQ+YY=; b=M2XvbCuPZ2gp3Js5I/jasCsszXlQUT52yYBtsitD8g/Mg+IYDxPcJNo/LNXi8D84ld M/V8neXTNKqWq8K1A3q0zGrO9YRsHlpUO9gbi1tH0DNkd2qXLvJHElwQXXCc6ZV314hi suY1VgwymJocm9E9e+AJRCoh4i08RYgeRHm0/WYrQKw2247lK33wpJPP06afuQ9B4+cM qhaKQ+sgonUGrjnSx+jQ2N7Gpl/dQa8un76um/6Z7ZgAJe696gPuBaCLF/aWTCQKX5ya EBNSIB33A8zdskO3f4Yu3w6AlIMdGOsc0+hEQVhiEItY6pP/LPe7y2ZASifhc/kArgC6 XZPw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=i12beUnC3CCF24djyH0PYfg5RFsVrIygfQLvrmWQ+YY=; b=ZMNo3IR573VttzlDgHf15MnriAO2ZrSKwPO7HB/Rzk5goZbCC+ahbcv6m43N3srE4v Zx4gDEGf6D6ksHU+QN7M8VJtwytgpUCDEuurgQ7K4WXQ1bOs/KbcyLlwYEPD504/QSSG VpjDsZDoSDByiWysNUogC8LJU9IlkaMqJcL9r0S5Hzzk11FGA7JKv9gS4FLB9SEl5gys eo/0hGw0NEpNGXzvtP39vO28/9t98y5SPBEN36tS4rys30V2M+8ZFSi36WVC8bS+LuOL RygeT4GHlEIOfm07UJSSknE3pZEIcTG22CL0iY1Ptvij9pjUwn1yocaak92X1wDEUK/m pQJQ== X-Gm-Message-State: AKaTC01r+gLNlZGAV5uJCQCF6anmMYY0T8vSbmF8fABErrFt55rA1aj/wzutQdvsmtrojdF8wc61EDRAWtDA+g== X-Received: by 10.157.48.101 with SMTP id w34mr50865254otd.268.1481341138217; Fri, 09 Dec 2016 19:38:58 -0800 (PST) MIME-Version: 1.0 Received: by 10.182.165.69 with HTTP; Fri, 9 Dec 2016 19:38:57 -0800 (PST) In-Reply-To: References: From: Hong Wu Date: Sat, 10 Dec 2016 11:38:57 +0800 Message-ID: Subject: Re: HAWQ register error if create table DDL without specifying distributed by (column) To: user@hawq.incubator.apache.org Cc: wenbin.lu@emc.com, dev@hawq.incubator.apache.org Content-Type: multipart/alternative; boundary=001a113cf70055aea70543459cc1 archived-at: Sat, 10 Dec 2016 03:39:17 -0000 --001a113cf70055aea70543459cc1 Content-Type: text/plain; charset=UTF-8 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 . 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 : > 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 > > --001a113cf70055aea70543459cc1--