[jira] [Created] (HIVE-14322) Postgres db issues after Datanucleus 4.x upgrade

["Thejas M Nair (JIRA)" <ji...@apache.org>]

Thejas M Nair created HIVE-14322:
------------------------------------

             Summary: Postgres db issues after Datanucleus 4.x upgrade
                 Key: HIVE-14322
                 URL: https://issues.apache.org/jira/browse/HIVE-14322
             Project: Hive
          Issue Type: Bug
    Affects Versions: 2.1.0
            Reporter: Thejas M Nair
            Assignee: Thejas M Nair


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 -
{code}
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
{code}





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)