[jira] [Created] (HAWQ-670) Error when changing the table distribution policy from random to hash distribution

["Haisheng Yuan (JIRA)" <ji...@apache.org>]

Haisheng Yuan created HAWQ-670:
----------------------------------

             Summary: Error when changing the table distribution policy from random to hash distribution
                 Key: HAWQ-670
                 URL: https://issues.apache.org/jira/browse/HAWQ-670
             Project: Apache HAWQ
          Issue Type: Bug
            Reporter: Haisheng Yuan
            Assignee: Lei Chang


If the current segments number is 8 and I run these queries, 
{code:sql}
create table t2 (c1 int) with (bucketnum=5);
create table t2_2 (c2 int) inherits(t2);
alter table t2 set distributed by (c1);
{code}
The alter table clause will show the following error message:
{color:red}
ERROR:  bucketnum requires a numeric value
{color}
which is not expected behavior.

The query should be able to be executed without error messages.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)