[HIVE-14322] Postgres db issues after Datanucleus 4.x upgrade

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.0, 2.0.1, 2.1.0
• Fix Version/s: 2.0.2, 2.1.1, 2.2.0
• Labels: TODOC2.0 TODOC2.1.1 TODOC2.2
• Assignee: Sergey Shelukhin
• Reporter: Thejas Nair
• Created: 24/Jul/16 06:42
• Updated: 01/Jun/17 04:40
• Resolved: 01/Aug/16 18:44

Description

With the upgrade to datanucleus 4.x versions in HIVE-6113, hive does not work properly with postgres.
The nullable fields in the database have string "NULL::character varying" instead of real NULL values. This causes various issues.

One example is -

hive> create table t(i int);
OK
Time taken: 1.9 seconds
hive> create view v as select * from t;
OK
Time taken: 0.542 seconds
hive> select * from v;
FAILED: SemanticException Unable to fetch table v. java.net.URISyntaxException: Relative path in absolute URI: NULL::character%20varying

Issue Links

• is duplicated by: ATLAS-1045 HiveHook fails to post metadata for "Create view" with "Relative path in absolute URI: NULL::character%20varying" exception
• is related to: HIVE-14371 use datanucleus.rdbms.useColumnDefaultWhenNull when available
• is related to: HIVE-6113 Upgrade DataNucleus [was: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient]
• is related to: HIVE-1841 datanucleus.fixedDatastore should be true in hive-default.xml
• relates to: HIVE-15204 Hive-Hbase integration thorws "java.lang.ClassNotFoundException: NULL::character varying" (Postgres)
• links to: DN forum question link