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)
