HIVE Creating Table not null

Question

this is my query in DB2 Database:

CREATE TABLE MY_TABLE                                                 
      (COD_SOC              CHAR(5)  NOT NULL);

Is possible reproduce the 'NOT NULL' in HIVE? What about PIG?

score 9 · Accepted Answer · answered Aug 07 '14 at 21:51

9

No it is not possible at this time. It would be very difficult for Hive to enforce column constraints.

answered Aug 07 '14 at 21:51

Mike Park

1

Has this behavior changed recently in any Hive version ? – Balkrishan Aggarwal Jan 24 '17 at 07:22
1

I don't know if it has changed recently – Mike Park Jan 24 '17 at 19:53

score 1 · Answer 2 · answered May 06 '20 at 20:23

1

With Hive 3.0, you can have DEFAULT Constraints on the hive table

answered May 06 '20 at 20:23

KarthiS

2 Answers2