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)

Reply via email to