Invalidation table creation

Question

this is my query on the DB2 database:

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

Is it possible to reproduce "NOT NULL" in HIVE? How about PIG?

+3

Edge7 07 Aug 14 at 15:34

1 answer

Mike park · Accepted Answer · 2014-08-07T21:51:31+0000

This is currently not possible. It would be very difficult for Hive to enforce column constraints.