[HIVE-18195] Hive schema broken on postgres

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.0.0
• Component/s: Metastore
• Assignee: Deepesh Khandelwal
• Reporter: Deepesh Khandelwal
• Created: 01/Dec/17 18:26
• Updated: 22/May/18 23:13
• Resolved: 01/Dec/17 21:43

Description

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.

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)
);