[
https://issues.apache.org/jira/browse/HAWQ-1213?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
hongwu updated HAWQ-1213:
-------------------------
Description:
Bug reproduce process:
{code}
postgres=# set default_hash_table_bucket_number=10;
postgres=# create table sales2( amount numeric(10,2), year integer)
with(appendonly=true) distributed randomly partition by range(year)
(start(2014) end (2016) every(1));
postgres=# create table sales6( amount numeric(10,2), year integer)
with(appendonly=true) distributed randomly partition by range(year)
(start(2014) end (2016) every(1));
hawq extract -d postgres -o sales2.yml sales2
hawq register -d postgres --config sales2.yml sales6
gpadmin-[ERROR]:-Bucket number of public.sales6_1_prt_1 is not consistent with
previous bucket number
{code}
was:
Bug reproduce process:
{code}
postgres=# set default_hash_table_bucket_number=10;
postgres=# create table sales2( amount numeric(10,2), year integer)
with(appendonly=true) distributed randomly partition by range(year)
(start(2014) end (2016) every(1));
hawq extract -d postgres -o sales2.yml sales2
hawq register -d postgres --config sales2.yml sales6
gpadmin-[ERROR]:-Bucket number of public.sales6_1_prt_1 is not consistent with
previous bucket number
{code}
> Incorrect check of hawqregister in case of randomly distributed table with
> non-default `default_hash_table_bucket_number` value.
> --------------------------------------------------------------------------------------------------------------------------------
>
> Key: HAWQ-1213
> URL: https://issues.apache.org/jira/browse/HAWQ-1213
> Project: Apache HAWQ
> Issue Type: Bug
> Components: Command Line Tools
> Affects Versions: 2.0.1.0-incubating
> Reporter: hongwu
> Assignee: hongwu
>
> Bug reproduce process:
> {code}
> postgres=# set default_hash_table_bucket_number=10;
> postgres=# create table sales2( amount numeric(10,2), year integer)
> with(appendonly=true) distributed randomly partition by range(year)
> (start(2014) end (2016) every(1));
> postgres=# create table sales6( amount numeric(10,2), year integer)
> with(appendonly=true) distributed randomly partition by range(year)
> (start(2014) end (2016) every(1));
> hawq extract -d postgres -o sales2.yml sales2
> hawq register -d postgres --config sales2.yml sales6
> gpadmin-[ERROR]:-Bucket number of public.sales6_1_prt_1 is not consistent
> with previous bucket number
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
