Vineet Garg created HIVE-18853:

             Summary: Alter table change column shouldn't let define same 
constraint on a column with existing constraint
                 Key: HIVE-18853
             Project: Hive
          Issue Type: Bug
            Reporter: Vineet Garg
            Assignee: Vineet Garg
             Fix For: 3.0.0

create table ttest(i int constraint nn1 not null enable);
alter table ttest change i j int constraint nn2 not null enable);

The above statements will end up creating multiple not null constraints on 
column i/j. 
desc formatted ttest;

# Not Null Constraints
Table:                  constraints.ttest
Constraint Name:        nn1
Column Name:            null

Constraint Name:        nn2
Column Name:            j

This message was sent by Atlassian JIRA

Reply via email to