Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-14322

Postgres db issues after Datanucleus 4.x upgrade

    XMLWordPrintableJSON

Details

    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
      

      Attachments

        1. HIVE-14322.02.patch
          2 kB
          Sergey Shelukhin
        2. HIVE-14322.03.patch
          2 kB
          Sergey Shelukhin
        3. HIVE-14322.04.patch
          2 kB
          Sergey Shelukhin
        4. HIVE-14322.1.patch
          18 kB
          Thejas Nair

        Issue Links

          Activity

            People

              sershe Sergey Shelukhin
              thejas Thejas Nair
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: