Review Board 1.7.22


HIVE-4021 PostgreSQL upgrade scripts are creating column with incorrect name

Review Request #9456 - Created Feb. 14, 2013 and submitted

Jarek Cecho
HIVE-4021
Reviewers
hive
hive
I've fixed the column name to singular form as the code and other scripts are expecting.

 
/trunk/metastore/scripts/upgrade/postgres/012-HIVE-1362.postgres.sql
Revision 1446320 New Change
1
SELECT '< HIVE-1362 Column Statistics Support in Hive  >';
1
SELECT '< HIVE-1362 Column Statistics Support in Hive  >';
2

    
   
2

   
3
CREATE TABLE "TAB_COL_STATS" (
3
CREATE TABLE "TAB_COL_STATS" (
4
 "CS_ID" bigint NOT NULL,
4
 "CS_ID" bigint NOT NULL,
5
 "DB_NAME" character varying(128) DEFAULT NULL::character varying,
5
 "DB_NAME" character varying(128) DEFAULT NULL::character varying,
6
 "TABLE_NAME" character varying(128) DEFAULT NULL::character varying,
6
 "TABLE_NAME" character varying(128) DEFAULT NULL::character varying,
7
 "COLUMN_NAME" character varying(128) DEFAULT NULL::character varying,
7
 "COLUMN_NAME" character varying(128) DEFAULT NULL::character varying,
8
 "COLUMN_TYPE" character varying(128) DEFAULT NULL::character varying,
8
 "COLUMN_TYPE" character varying(128) DEFAULT NULL::character varying,
9
 "TBL_ID" bigint NOT NULL,
9
 "TBL_ID" bigint NOT NULL,
10
 "LONG_LOW_VALUE" bigint,
10
 "LONG_LOW_VALUE" bigint,
11
 "LONG_HIGH_VALUE" bigint,
11
 "LONG_HIGH_VALUE" bigint,
12
 "DOUBLE_LOW_VALUE" double precision,
12
 "DOUBLE_LOW_VALUE" double precision,
13
 "DOUBLE_HIGH_VALUES" double precision,
13
 "DOUBLE_HIGH_VALUE" double precision,
14
 "BIG_DECIMAL_LOW_VALUE" character varying(4000) DEFAULT NULL::character varying,
14
 "BIG_DECIMAL_LOW_VALUE" character varying(4000) DEFAULT NULL::character varying,
15
 "BIG_DECIMAL_HIGH_VALUE" character varying(4000) DEFAULT NULL::character varying,
15
 "BIG_DECIMAL_HIGH_VALUE" character varying(4000) DEFAULT NULL::character varying,
16
 "NUM_NULLS" bigint NOT NULL,
16
 "NUM_NULLS" bigint NOT NULL,
17
 "NUM_DISTINCTS" bigint,
17
 "NUM_DISTINCTS" bigint,
18
 "AVG_COL_LEN" double precision,
18
 "AVG_COL_LEN" double precision,
[+20] [20] 17 lines
[+20]
36
 "COLUMN_TYPE" character varying(128) DEFAULT NULL::character varying,
36
 "COLUMN_TYPE" character varying(128) DEFAULT NULL::character varying,
37
 "PART_ID" bigint NOT NULL,
37
 "PART_ID" bigint NOT NULL,
38
 "LONG_LOW_VALUE" bigint,
38
 "LONG_LOW_VALUE" bigint,
39
 "LONG_HIGH_VALUE" bigint,
39
 "LONG_HIGH_VALUE" bigint,
40
 "DOUBLE_LOW_VALUE" double precision,
40
 "DOUBLE_LOW_VALUE" double precision,
41
 "DOUBLE_HIGH_VALUES" double precision,
41
 "DOUBLE_HIGH_VALUE" double precision,
42
 "BIG_DECIMAL_LOW_VALUE" character varying(4000) DEFAULT NULL::character varying,
42
 "BIG_DECIMAL_LOW_VALUE" character varying(4000) DEFAULT NULL::character varying,
43
 "BIG_DECIMAL_HIGH_VALUE" character varying(4000) DEFAULT NULL::character varying,
43
 "BIG_DECIMAL_HIGH_VALUE" character varying(4000) DEFAULT NULL::character varying,
44
 "NUM_NULLS" bigint NOT NULL,
44
 "NUM_NULLS" bigint NOT NULL,
45
 "NUM_DISTINCTS" bigint,
45
 "NUM_DISTINCTS" bigint,
46
 "AVG_COL_LEN" double precision,
46
 "AVG_COL_LEN" double precision,
[+20] [20] 9 lines
  1. /trunk/metastore/scripts/upgrade/postgres/012-HIVE-1362.postgres.sql: Loading...