CODEWITHSUNDEEP
hadoopdb2hiveapache-pig
Edge7
Edge7

Reputation: 681

HIVE Creating Table not null

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?

Upvotes: 6

Views: 9995

Answers (2)

KarthiS
KarthiS

Reputation: 784

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

Refer 1. https://www.adaltas.com/en/2019/07/25/hive-3-features-tips-tricks/ 2. https://www.slideshare.net/Hadoop_Summit/what-is-new-in-apache-hive-30

Upvotes: 1

Mike Park
Mike Park

Reputation: 10931

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

Upvotes: 9

Related Questions