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?

Answer 1

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