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 A0E83200BE5 for ; Sat, 10 Dec 2016 05:32:13 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 9B5BC160B1E; Sat, 10 Dec 2016 04:32:13 +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 DD903160B1D for ; Sat, 10 Dec 2016 05:32:10 +0100 (CET) Received: (qmail 41730 invoked by uid 500); 10 Dec 2016 04:32:10 -0000 Mailing-List: contact user-help@hawq.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hawq.incubator.apache.org Delivered-To: mailing list user@hawq.incubator.apache.org Received: (qmail 41718 invoked by uid 99); 10 Dec 2016 04:32:09 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 10 Dec 2016 04:32:09 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 0D1551A9E73; Sat, 10 Dec 2016 04:32:09 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.149 X-Spam-Level: ** X-Spam-Status: No, score=2.149 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, FREEMAIL_ENVFROM_END_DIGIT=0.25, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-0.001, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id uxwqzuvZartr; Sat, 10 Dec 2016 04:32:00 +0000 (UTC) Received: from mail-oi0-f47.google.com (mail-oi0-f47.google.com [209.85.218.47]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id B62595FD02; Sat, 10 Dec 2016 04:31:59 +0000 (UTC) Received: by mail-oi0-f47.google.com with SMTP id y198so39311483oia.1; Fri, 09 Dec 2016 20:31:59 -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=3WCuNfjnI265v3OdidhzaxRcaGbeRb9MuiTLWNwRDZE=; b=hyGao1Ce4WmAtX8B5OG/m7KZoEoL0vT5PoASIckw1svpLHUa+/yNaR+nAITl7hC0YB NpE0LTsAN6K5ikYFcVzJtILGygqNzlkj3E/x5q1/1PVhu/BNwkNQvHwi7XhIT+c45Xh1 UcAdmBqnt0GdSTxeeia4uXd76tCaL/fhst3PwhDA79+X2A07/9kDztC/VI39q3Oe0w+6 WZeuH1GXSygMdAY6d8Q/ZP9iSHcLgTiLDoqeRXm8EQxLDWmetobLSU4BW2Q3VU9psY1r rAQVSrw2Aj0KKc8vVDNbV/bPRkg8bIbs8KHIj3tZ7rdsirC1PqiV2jryL1CrA2g0lQzl WVJQ== 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=3WCuNfjnI265v3OdidhzaxRcaGbeRb9MuiTLWNwRDZE=; b=V0udhfuivtmgt3s2jLVjUTi/IiGQ96FvEds3zvTygd58vhdnflGtAenAXPSHhGEBC5 GIMbbgyfECQR4X4Q4e5FuhvV2eZrABMlXGFO7ZtdVkabWJ/wFA3+z51A86qc41ljeCTz F2eSYGZDKv4NujvOpLe1GwiAGy92GXVEavPKds18nm18IqsAQguyB2GouY1IYlpMqdg6 ENc4LE5K+uzEeJYm4HmWXcsTcYX5z9vuyI5sXdisjXBwUk3bKmx7gJ6R93nQPNUkLQIn 18ALWbD/YcqwfNzFEvmH+oshw1f41epiIMQJDTweGqV2ZXpdOzRzOJeZGEKvu2qOTp10 AjMg== X-Gm-Message-State: AKaTC02uJQvhDWudevVYZEiVZKA7HeauLmuQCQ1umMf7C/go/aPnQZYovmkJYGkYKBm595XQ49zpC5NEcvgDCA== X-Received: by 10.157.8.197 with SMTP id 63mr49116894otf.212.1481344319042; Fri, 09 Dec 2016 20:31:59 -0800 (PST) MIME-Version: 1.0 Received: by 10.182.158.65 with HTTP; Fri, 9 Dec 2016 20:31:58 -0800 (PST) In-Reply-To: References: From: George Lu Date: Sat, 10 Dec 2016 12:31:58 +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=001a113cfe7aed38ee0543465949 archived-at: Sat, 10 Dec 2016 04:32:13 -0000 --001a113cfe7aed38ee0543465949 Content-Type: text/plain; charset=UTF-8 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 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 > . > 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 >> >> > --001a113cfe7aed38ee0543465949 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
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" sup= ports registering a one-level partition table in this release. You can regi= ster a hash distributed table to a hash distributed table, a randomly distr= ibuted table to a randomly distributed table, a hash distributed table to a= hash distributed table. But you can not reg= ister a randomly distributed table to a hash distributed table.
<= br>
For your case, the usage is exactly correct. According to you= r log file, it says=C2=A0
"gpadmin-[ERROR]:-Bucket number of public.sales6_1_prt= _1 is not consistent with previous bucket number."=C2=A0= This is a pre-check in hawqregister, making sure that the bucketnum value f= rom=C2=A0yaml file is consistent with destination table. For a=C2=A0randoml= y distributed table, this value is meaningless and in fact this check is un= necessary. But current implement also does the check in this case, using de= fault values' consistency.

I noticed that in y= our extracted yaml file "sales3.yml", the bucketnum=C2=A0is 42 so= I guess in your environment, the default bucketnum is 42. Please check it = with following SQLs:

postgres=3D# select oid from pg_cla= ss where relnamespace=3D'2200' and relname =3D 'sales2';

postgres=3D= # select=C2=A0bucketnum=C2=A0from gp_distribution_policy = where localoid =3D '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 v= alue in different HAWQ environment, or we can remove this check for registe= ring randomly distributed table. I will do that fix asap.

Thanks,
Hong
2016-12-09 15:34 GMT+08:00 Geo= rge Lu <luwenbin888@gmail.com>:

Dear all,

=C2=A0

I had a problem in hawq register in HDB 2.1.0 backed b= y Isilon HDFS on HDP 2.5

=C2=A0

I created a one-level partitioned table:<= /span>

create table sales2( amount numeric(10,2), year intege= r) with(appendonly=3Dtrue) distributed randomly partition by range(year) (start(2014) end (2016) every(1));

then insert two records into that.=

=C2=A0

After that, I use "hawq extract -d testdb -o sale= s2.yml sale2" to extract the table metadata.

=C2=A0

Then I use "hawq register -d testdb --config sale= s2.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.<= /span>

20161209:07:07:13:081923 hawqregister:kevi41hwxworke= r0:gpadmin-[INFO]:-Files check for table sales2_1_prt_1...

20161209:07:07:15:081923 hawqregister:kevi41hwxworker0:gpadmin-[INFO]:-Files check done for tab= le 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 tab= le sales2_1_prt_2.

20161209:07:07:22:081923 hawqregister:kevi41hwxworker0:gpadmin-[INFO]:-New file(s) to be regist= ered: ['hdfs://kevinhwx12061712.bdl02.shanghai.dev:8020/hawq_defaul= t/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.<= /span>

20161209:07:07:25:081923 hawqregister:kevi41hwxworker0:gpadmin-[INFO]:-Error found, Hawqregiste= r starts to rollback...

20161209:07:07:25:081923 hawqregister:kevi41hwxworker0:gpadmin-[INFO]:-Hawq Register Rollback F= inished.

=C2=A0

However, if I created the table like:

create table sales3(id int, amount numeric(10,2), year= integer) with(appendonly=3Dtrue)=C2=A0distributed by=C2=A0(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.

=C2=A0

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 us= e hawq register for one-level partitioned table?

=C2=A0

Thanks!

=C2=A0

Regards,

Lu Wenbin

=C2=A0

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

1) Sales schema by pg_dump -d testdb -t sales2 --schem= a-only

--inserts is preferred over -d. =C2=A0-d is deprecated.

--

-- Greenplum Database database dump

--

=C2=A0

SET statement_timeout =3D 0;

SET client_encoding =3D 'UTF8';

SET standard_conforming_strings =3D off;

SET check_function_bodies =3D false;

SET client_min_messages =3D warning;

SET escape_string_warning =3D off;

SET gp_enable_column_oriented_table =3D true;

=C2=A0

SET default_with_oids =3D false;

=C2=A0

--

-- Name: GPDUMPGUC; Type: INTERNAL GUC; Schema: -; Owner:<= /p>

--

=C2=A0

SET gp_called_by_pgdump =3D true;

=C2=A0

=C2=A0

SET search_path =3D public, pg_catalog;

=C2=A0

SET default_tablespace =3D '';

=C2=A0

--

-- Name: sales2; Type: TABLE; Schema: public; Owner: gpadmin; Tablespace:

--

=C2=A0

CREATE TABLE sales2 (

=C2=A0 =C2=A0 amount numeric(10,2),

=C2=A0 =C2=A0 year integer

)

WITH (appendonly=3Dtrue) DISTRIBUTED RANDOMLY PARTITION BY RANGE(year)

=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 (

=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 START (2014) END (2015) EVERY (1) WITH (tablename=3D'sales2_1_prt_1', orientation=3Drow , appendonly=3Dtru= e ),

=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 START (2015) END (2016) EVERY (1) WITH (tablename=3D'sales2_1_prt_2', orientation=3Drow , appendonly=3Dtru= e )

=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 );

=C2=A0

=C2=A0

ALTER TABLE public.sales2 OWNER TO gpadmin;

=C2=A0

--

-- Greenplum Database database dump complete

--

=C2=A0

2) Sales2.yml

AO_FileLocations:

=C2=A0 Blocksize: 32768

=C2=A0 Checksum: false

=C2=A0 CompressionLevel: 0

=C2=A0 CompressionType: null

=C2=A0 Files:

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16910/1

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 PartitionBy: PARTITION BY range (year)

=C2=A0 Partitions:

=C2=A0 - Blocksize: 32768

=C2=A0 =C2=A0 Checksum: false

=C2=A0 =C2=A0 CompressionLevel: 0

=C2=A0 =C2=A0 CompressionType: null

=C2=A0 =C2=A0 Constraint: START (2014) END (2015) EVERY (1) WITH (appendonly=3Dtru= e)

=C2=A0 =C2=A0 Files:

=C2=A0 =C2=A0 - eofuncompressed: 32

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16915/1

=C2=A0 =C2=A0 =C2=A0 size: 32

=C2=A0 =C2=A0 =C2=A0 tupcount: 1

=C2=A0 =C2=A0 =C2=A0 varblockcount: 1

=C2=A0 =C2=A0 Name: sales2_1_prt_1

=C2=A0 - Blocksize: 32768

=C2=A0 =C2=A0 Checksum: false

=C2=A0 =C2=A0 CompressionLevel: 0

=C2=A0 =C2=A0 CompressionType: null

=C2=A0 =C2=A0 Constraint: START (2015) END (2016) EVERY (1) WITH (appendonly=3Dtru= e)

=C2=A0 =C2=A0 Files:

=C2=A0 =C2=A0 - eofuncompressed: 32

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16921/1

=C2=A0 =C2=A0 =C2=A0 size: 32

=C2=A0 =C2=A0 =C2=A0 tupcount: 1

=C2=A0 =C2=A0 =C2=A0 varblockcount: 1

=C2=A0 =C2=A0 Name: sales2_1_prt_2

AO_Schema:

- name: amount

=C2=A0 type: numeric

- name: year

=C2=A0 type: int4

DBVersion: PostgreSQL 8.2.15 (Greenplum Database 4.2.0 build 1) (HAWQ 2.1.0.0 build

=C2=A0 2490) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.8.2 20140120 (Red

=C2=A0 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

=C2=A0

3) sales3 schema

=C2=A0--inserts is preferred over -d. =C2=A0-d is deprecated.

--

-- Greenplum Database database dump

--

=C2=A0

SET statement_timeout =3D 0;

SET client_encoding =3D 'UTF8';

SET standard_conforming_strings =3D off;

SET check_function_bodies =3D false;

SET client_min_messages =3D warning;

SET escape_string_warning =3D off;

SET gp_enable_column_oriented_table =3D true;

=C2=A0

SET default_with_oids =3D false;

=C2=A0

--

-- Name: GPDUMPGUC; Type: INTERNAL GUC; Schema: -; Owner:<= /p>

--

=C2=A0

SET gp_called_by_pgdump =3D true;

=C2=A0

=C2=A0

SET search_path =3D public, pg_catalog;

=C2=A0

SET default_tablespace =3D '';

=C2=A0

--

-- Name: sales3; Type: TABLE; Schema: public; Owner: gpadmin; Tablespace:

--

=C2=A0

CREATE TABLE sales3 (

=C2=A0 =C2=A0 id integer,

=C2=A0 =C2=A0 amount numeric(10,2),

=C2=A0 =C2=A0 year integer

)

WITH (appendonly=3Dtrue) DISTRIBUTED BY (id) PARTITION BY RANGE(year)

=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 (

=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 START (2014) END (2015) EVERY (1) WITH (tablename=3D'sales3_1_prt_1', orientation=3Drow , appendonly=3Dtru= e ),

=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 START (2015) END (2016) EVERY (1) WITH (tablename=3D'sales3_1_prt_2', orientation=3Drow , appendonly=3Dtru= e )

=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 );

=C2=A0

=C2=A0

ALTER TABLE public.sales3 OWNER TO gpadmin;

=C2=A0

--

-- Greenplum Database database dump complete

--

=C2=A0

4) sales3.yml

AO_FileLocations:

=C2=A0 Blocksize: 32768

=C2=A0 Checksum: false

=C2=A0 CompressionLevel: 0

=C2=A0 CompressionType: null

=C2=A0 Files:

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/1

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/2

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/3

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/4

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/5

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/6

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/7

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/8

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/9

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/10

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/11

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/12

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/13

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/14

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/15

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/16

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/17

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/18

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/19

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/20

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/21

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/22

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/23

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/24

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/25

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/26

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/27

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/28

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/29

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/30

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/31

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/32

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/33

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/34

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/35

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/36

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/37

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/38

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/39

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/40

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/41

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 path: /hawq_default/16385/16508/16970/42

=C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 varblockcount: 0

=C2=A0 PartitionBy: PARTITION BY range (year)<= /span>

=C2=A0 Partitions:

=C2=A0 - Blocksize: 32768

=C2=A0 =C2=A0 Checksum: false

=C2=A0 =C2=A0 CompressionLevel: 0

=C2=A0 =C2=A0 CompressionType: null

=C2=A0 =C2=A0 Constraint: START (2014) END (2015) EV= ERY (1) WITH (appendonly=3Dtrue)

=C2=A0 =C2=A0 Files:

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508= /16975/1

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508= /16975/2

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508= /16975/3

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508= /16975/4

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508= /16975/5

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508= /16975/6

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508= /16975/7

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508= /16975/8

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508= /16975/9

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16975/10

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16975/11

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16975/12

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16975/13

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16975/14

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16975/15

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16975/16

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16975/17

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16975/18

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16975/19

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16975/20

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16975/21

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16975/22

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16975/23

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16975/24

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16975/25

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16975/26

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16975/27

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16975/28

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16975/29

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16975/30

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 32

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16975/31

=C2=A0 =C2=A0 =C2=A0 size: 32

=C2=A0 =C2=A0 =C2=A0 tupcount: 1

=C2=A0 =C2=A0 =C2=A0 varblockcount: 1

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16975/32

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16975/33

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16975/34

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16975/35

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16975/36

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16975/37

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16975/38

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16975/39

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16975/40

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16975/41

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16975/42

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 Name: sales3_1_prt_1

=C2=A0 - Blocksize: 32768

=C2=A0 =C2=A0 Checksum: false

=C2=A0 =C2=A0 CompressionLevel: 0

=C2=A0 =C2=A0 CompressionType: null

=C2=A0 =C2=A0 Constraint: START (2015) END (2016) EV= ERY (1) WITH (appendonly=3Dtrue)

=C2=A0 =C2=A0 Files:

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508= /16981/1

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508= /16981/2

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508= /16981/3

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508= /16981/4

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508= /16981/5

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508= /16981/6

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508= /16981/7

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508= /16981/8

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508= /16981/9

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16981/10

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508= /16981/11

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16981/12

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16981/13

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16981/14

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16981/15

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 32

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16981/16

=C2=A0 =C2=A0 =C2=A0 size: 32

=C2=A0 =C2=A0 =C2=A0 tupcount: 1

=C2=A0 =C2=A0 =C2=A0 varblockcount: 1

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16981/17

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16981/18

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16981/19

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16981/20

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16981/21

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16981/22

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16981/23

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16981/24

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16981/25

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16981/26

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16981/27

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16981/28

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16981/29

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16981/30

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16981/31

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16981/32

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16981/33

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16981/34

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16981/35

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16981/36

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16981/37

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16981/38

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16981/39

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16981/40

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16981/41

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 - eofuncompressed: 0

=C2=A0 =C2=A0 =C2=A0 path: /hawq_default/16385/16508/16981/42

=C2=A0 =C2=A0 =C2=A0 size: 0

=C2=A0 =C2=A0 =C2=A0 tupcount: 0

=C2=A0 =C2=A0 =C2=A0 varblockcount: 0

=C2=A0 =C2=A0 Name: sales3_1_prt_2

AO_Schema:

- name: id

=C2=A0 type: int4

- name: amount

=C2=A0 type: numeric

- name: year

=C2=A0 type: int4

Bucketnum: 42

DBVersion: PostgreSQL 8.2.15 (Greenplum Database 4.2= .0 build 1) (HAWQ 2.1.0.0 build

=C2=A0 2490) on x86_64-unknown-linux-gnu, compiled b= y GCC gcc (GCC) 4.8.2 20140120 (Red

=C2=A0 Hat 4.8.2-15) compiled on Nov 30 2016 03:44:4= 6

DFS_URL: hdfs://kevinhwx12061712.bdl02.shanghai= .dev:8020

Distribution_Policy: DISTRIBUTED BY (id)

Encoding: UTF8

FileFormat: AO

TableName: public.sales3

Version: 1.0.0




--001a113cfe7aed38ee0543465949--