You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Deepesh Khandelwal (JIRA)" <ji...@apache.org> on 2017/12/01 18:27:00 UTC

[jira] [Created] (HIVE-18195) Hive schema broken on postgres

Deepesh Khandelwal created HIVE-18195:
-----------------------------------------

             Summary: Hive schema broken on postgres
                 Key: HIVE-18195
                 URL: https://issues.apache.org/jira/browse/HIVE-18195
             Project: Hive
          Issue Type: Bug
          Components: Metastore
    Affects Versions: 3.0.0
            Reporter: Deepesh Khandelwal
            Assignee: Deepesh Khandelwal
            Priority: Blocker


Hive metastore schema on postgres is broken after the commit for HIVE-17954. Basicaly the following file metastore/scripts/upgrade/postgres/hive-schema-3.0.0.postgres.sql incorrectly defines WM_POOL with column ALLOC_FRACTION with DOUBLE data type, it should be double precision.
{noformat}
CREATE TABLE "WM_POOL" (
    "POOL_ID" bigint NOT NULL,
    "RP_ID" bigint NOT NULL,
    "PATH" character varying(1024) NOT NULL,
    "ALLOC_FRACTION" DOUBLE,
    "QUERY_PARALLELISM" integer,
    "SCHEDULING_POLICY" character varying(1024)
);
{noformat}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)