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.1.patch
          18 kB
          Thejas M Nair
        2. HIVE-14322.04.patch
          2 kB
          Sergey Shelukhin
        3. HIVE-14322.03.patch
          2 kB
          Sergey Shelukhin
        4. HIVE-14322.02.patch
          2 kB
          Sergey Shelukhin

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: