This is an automated email from the ASF dual-hosted git repository.
gates pushed a commit to branch branch-3.1
in repository https://gitbox.apache.org/repos/asf/hive.git
The following commit(s) were added to refs/heads/branch-3.1 by this push:
new 3e16420 HIVE-21821 Backport HIVE-21739 to branch-3.1 (Aditya Shah via
Alan Gates)
3e16420 is described below
commit 3e164204b7f06e7c9b39a2f3e0e72d439477dad8
Author: Alan Gates <ga...@hortonworks.com>
AuthorDate: Tue Jun 4 14:12:53 2019 -0700
HIVE-21821 Backport HIVE-21739 to branch-3.1 (Aditya Shah via Alan Gates)
---
standalone-metastore/src/main/sql/derby/hive-schema-3.0.0.derby.sql | 5 ++++-
standalone-metastore/src/main/sql/derby/hive-schema-3.1.0.derby.sql | 5 ++++-
.../src/main/sql/derby/upgrade-2.3.0-to-3.0.0.derby.sql | 5 ++++-
standalone-metastore/src/main/sql/mssql/hive-schema-3.0.0.mssql.sql | 5 ++++-
standalone-metastore/src/main/sql/mssql/hive-schema-3.1.0.mssql.sql | 5 ++++-
.../src/main/sql/mssql/upgrade-2.3.0-to-3.0.0.mssql.sql | 3 +++
standalone-metastore/src/main/sql/mysql/hive-schema-3.0.0.mysql.sql | 4 +++-
standalone-metastore/src/main/sql/mysql/hive-schema-3.1.0.mysql.sql | 4 +++-
.../src/main/sql/mysql/upgrade-2.3.0-to-3.0.0.mysql.sql | 4 ++--
.../src/main/sql/oracle/hive-schema-3.0.0.oracle.sql | 5 ++++-
.../src/main/sql/oracle/hive-schema-3.1.0.oracle.sql | 5 ++++-
.../src/main/sql/oracle/upgrade-2.3.0-to-3.0.0.oracle.sql | 2 +-
.../src/main/sql/postgres/hive-schema-3.0.0.postgres.sql | 5 ++++-
.../src/main/sql/postgres/hive-schema-3.1.0.postgres.sql | 5 ++++-
.../src/main/sql/postgres/upgrade-2.3.0-to-3.0.0.postgres.sql | 5 ++++-
.../hadoop/hive/metastore/tools/TestSchemaToolForMetastore.java | 4 ++--
16 files changed, 54 insertions(+), 17 deletions(-)
diff --git
a/standalone-metastore/src/main/sql/derby/hive-schema-3.0.0.derby.sql
b/standalone-metastore/src/main/sql/derby/hive-schema-3.0.0.derby.sql
index e818e1b..4994763 100644
--- a/standalone-metastore/src/main/sql/derby/hive-schema-3.0.0.derby.sql
+++ b/standalone-metastore/src/main/sql/derby/hive-schema-3.0.0.derby.sql
@@ -22,7 +22,7 @@ CREATE TABLE "APP"."DBS" (
"NAME" VARCHAR(128),
"OWNER_NAME" VARCHAR(128),
"OWNER_TYPE" VARCHAR(10),
- "CTLG_NAME" VARCHAR(256) NOT NULL
+ "CTLG_NAME" VARCHAR(256) NOT NULL DEFAULT 'hive'
);
CREATE TABLE "APP"."TBL_PRIVS" ("TBL_GRANT_ID" BIGINT NOT NULL, "CREATE_TIME"
INTEGER NOT NULL, "GRANT_OPTION" SMALLINT NOT NULL, "GRANTOR" VARCHAR(128),
"GRANTOR_TYPE" VARCHAR(128), "PRINCIPAL_NAME" VARCHAR(128), "PRINCIPAL_TYPE"
VARCHAR(128), "TBL_PRIV" VARCHAR(128), "TBL_ID" BIGINT);
@@ -211,6 +211,9 @@ CREATE TABLE "APP"."CTLGS" (
"DESC" VARCHAR(4000),
"LOCATION_URI" VARCHAR(4000) NOT NULL);
+-- Insert a default value. The location is TBD. Hive will fix this when it
starts
+INSERT INTO "APP"."CTLGS" VALUES (1, 'hive', 'Default catalog for Hive',
'TBD');
+
-- ----------------------------------------------
-- DML Statements
-- ----------------------------------------------
diff --git
a/standalone-metastore/src/main/sql/derby/hive-schema-3.1.0.derby.sql
b/standalone-metastore/src/main/sql/derby/hive-schema-3.1.0.derby.sql
index 043cf07..74582e1 100644
--- a/standalone-metastore/src/main/sql/derby/hive-schema-3.1.0.derby.sql
+++ b/standalone-metastore/src/main/sql/derby/hive-schema-3.1.0.derby.sql
@@ -22,7 +22,7 @@ CREATE TABLE "APP"."DBS" (
"NAME" VARCHAR(128),
"OWNER_NAME" VARCHAR(128),
"OWNER_TYPE" VARCHAR(10),
- "CTLG_NAME" VARCHAR(256) NOT NULL
+ "CTLG_NAME" VARCHAR(256) NOT NULL DEFAULT 'hive'
);
CREATE TABLE "APP"."TBL_PRIVS" ("TBL_GRANT_ID" BIGINT NOT NULL, "CREATE_TIME"
INTEGER NOT NULL, "GRANT_OPTION" SMALLINT NOT NULL, "GRANTOR" VARCHAR(128),
"GRANTOR_TYPE" VARCHAR(128), "PRINCIPAL_NAME" VARCHAR(128), "PRINCIPAL_TYPE"
VARCHAR(128), "TBL_PRIV" VARCHAR(128), "TBL_ID" BIGINT, "AUTHORIZER"
VARCHAR(128));
@@ -212,6 +212,9 @@ CREATE TABLE "APP"."CTLGS" (
"DESC" VARCHAR(4000),
"LOCATION_URI" VARCHAR(4000) NOT NULL);
+-- Insert a default value. The location is TBD. Hive will fix this when it
starts
+INSERT INTO "APP"."CTLGS" VALUES (1, 'hive', 'Default catalog for Hive',
'TBD');
+
-- ----------------------------------------------
-- DML Statements
-- ----------------------------------------------
diff --git
a/standalone-metastore/src/main/sql/derby/upgrade-2.3.0-to-3.0.0.derby.sql
b/standalone-metastore/src/main/sql/derby/upgrade-2.3.0-to-3.0.0.derby.sql
index 7b7a8a2..2bdd7b8 100644
--- a/standalone-metastore/src/main/sql/derby/upgrade-2.3.0-to-3.0.0.derby.sql
+++ b/standalone-metastore/src/main/sql/derby/upgrade-2.3.0-to-3.0.0.derby.sql
@@ -192,7 +192,10 @@ UPDATE "APP"."DBS"
-- Add the not null constraint
ALTER TABLE "APP"."DBS" ALTER COLUMN "CTLG_NAME" NOT NULL;
--- Put back the unique index
+-- Add default value to ctlg name
+ALTER TABLE "APP"."DBS" ALTER COLUMN "CTLG_NAME" SET DEFAULT 'hive';
+
+-- Put back the unique index
CREATE UNIQUE INDEX "APP"."UNIQUE_DATABASE" ON "APP"."DBS" ("NAME",
"CTLG_NAME");
-- Add the foreign key
diff --git
a/standalone-metastore/src/main/sql/mssql/hive-schema-3.0.0.mssql.sql
b/standalone-metastore/src/main/sql/mssql/hive-schema-3.0.0.mssql.sql
index c88fb18..7446036 100644
--- a/standalone-metastore/src/main/sql/mssql/hive-schema-3.0.0.mssql.sql
+++ b/standalone-metastore/src/main/sql/mssql/hive-schema-3.0.0.mssql.sql
@@ -279,7 +279,7 @@ CREATE TABLE DBS
"NAME" nvarchar(128) NULL,
OWNER_NAME nvarchar(128) NULL,
OWNER_TYPE nvarchar(10) NULL,
- CTLG_NAME nvarchar(256)
+ CTLG_NAME nvarchar(256) DEFAULT 'hive'
);
ALTER TABLE DBS ADD CONSTRAINT DBS_PK PRIMARY KEY (DB_ID);
@@ -692,6 +692,9 @@ CREATE TABLE CTLGS (
LOCATION_URI nvarchar(4000) not null
);
+-- Insert a default value. The location is TBD. Hive will fix this when it
starts
+INSERT INTO CTLGS VALUES (1, 'hive', 'Default catalog for Hive', 'TBD');
+
CREATE UNIQUE INDEX UNIQUE_CTLG ON CTLGS ("NAME");
-- Constraints for table MASTER_KEYS for class(es)
[org.apache.hadoop.hive.metastore.model.MMasterKey]
diff --git
a/standalone-metastore/src/main/sql/mssql/hive-schema-3.1.0.mssql.sql
b/standalone-metastore/src/main/sql/mssql/hive-schema-3.1.0.mssql.sql
index fef6ab9..ca2729d 100644
--- a/standalone-metastore/src/main/sql/mssql/hive-schema-3.1.0.mssql.sql
+++ b/standalone-metastore/src/main/sql/mssql/hive-schema-3.1.0.mssql.sql
@@ -285,7 +285,7 @@ CREATE TABLE DBS
"NAME" nvarchar(128) NULL,
OWNER_NAME nvarchar(128) NULL,
OWNER_TYPE nvarchar(10) NULL,
- CTLG_NAME nvarchar(256)
+ CTLG_NAME nvarchar(256) DEFAULT 'hive'
);
ALTER TABLE DBS ADD CONSTRAINT DBS_PK PRIMARY KEY (DB_ID);
@@ -700,6 +700,9 @@ CREATE TABLE CTLGS (
LOCATION_URI nvarchar(4000) not null
);
+-- Insert a default value. The location is TBD. Hive will fix this when it
starts
+INSERT INTO CTLGS VALUES (1, 'hive', 'Default catalog for Hive', 'TBD');
+
CREATE UNIQUE INDEX UNIQUE_CTLG ON CTLGS ("NAME");
-- Constraints for table MASTER_KEYS for class(es)
[org.apache.hadoop.hive.metastore.model.MMasterKey]
diff --git
a/standalone-metastore/src/main/sql/mssql/upgrade-2.3.0-to-3.0.0.mssql.sql
b/standalone-metastore/src/main/sql/mssql/upgrade-2.3.0-to-3.0.0.mssql.sql
index 63a8f62..28dbae9 100644
--- a/standalone-metastore/src/main/sql/mssql/upgrade-2.3.0-to-3.0.0.mssql.sql
+++ b/standalone-metastore/src/main/sql/mssql/upgrade-2.3.0-to-3.0.0.mssql.sql
@@ -268,6 +268,9 @@ UPDATE DBS
-- Add the not null constraint
ALTER TABLE DBS ALTER COLUMN CTLG_NAME nvarchar(256) NOT NULL;
+-- Add the default as 'hive'
+ALTER TABLE DBS ADD DEFAULT 'hive' FOR CTLG_NAME;
+
-- Put back the unique index
CREATE UNIQUE INDEX UNIQUEDATABASE ON DBS ("NAME", "CTLG_NAME");
diff --git
a/standalone-metastore/src/main/sql/mysql/hive-schema-3.0.0.mysql.sql
b/standalone-metastore/src/main/sql/mysql/hive-schema-3.0.0.mysql.sql
index c54df55..e64f4ee 100644
--- a/standalone-metastore/src/main/sql/mysql/hive-schema-3.0.0.mysql.sql
+++ b/standalone-metastore/src/main/sql/mysql/hive-schema-3.0.0.mysql.sql
@@ -85,6 +85,8 @@ CREATE TABLE `CTLGS` (
UNIQUE KEY `UNIQUE_CATALOG` (`NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+-- Insert a default value. The location is TBD. Hive will fix this when it
starts
+INSERT INTO `CTLGS` VALUES (1, 'hive', 'Default catalog for Hive', 'TBD');
--
-- Table structure for table `DBS`
@@ -99,7 +101,7 @@ CREATE TABLE IF NOT EXISTS `DBS` (
`NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
`OWNER_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT
NULL,
`OWNER_TYPE` varchar(10) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT
NULL,
- `CTLG_NAME` varchar(256) NOT NULL,
+ `CTLG_NAME` varchar(256) NOT NULL DEFAULT 'hive',
PRIMARY KEY (`DB_ID`),
UNIQUE KEY `UNIQUE_DATABASE` (`NAME`, `CTLG_NAME`),
CONSTRAINT `CTLG_FK1` FOREIGN KEY (`CTLG_NAME`) REFERENCES `CTLGS` (`NAME`)
diff --git
a/standalone-metastore/src/main/sql/mysql/hive-schema-3.1.0.mysql.sql
b/standalone-metastore/src/main/sql/mysql/hive-schema-3.1.0.mysql.sql
index 8510ceb..048162c 100644
--- a/standalone-metastore/src/main/sql/mysql/hive-schema-3.1.0.mysql.sql
+++ b/standalone-metastore/src/main/sql/mysql/hive-schema-3.1.0.mysql.sql
@@ -85,6 +85,8 @@ CREATE TABLE `CTLGS` (
UNIQUE KEY `UNIQUE_CATALOG` (`NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+-- Insert a default value. The location is TBD. Hive will fix this when it
starts
+INSERT INTO `CTLGS` VALUES (1, 'hive', 'Default catalog for Hive', 'TBD');
--
-- Table structure for table `DBS`
@@ -99,7 +101,7 @@ CREATE TABLE IF NOT EXISTS `DBS` (
`NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
`OWNER_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT
NULL,
`OWNER_TYPE` varchar(10) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT
NULL,
- `CTLG_NAME` varchar(256) NOT NULL,
+ `CTLG_NAME` varchar(256) NOT NULL DEFAULT 'hive',
PRIMARY KEY (`DB_ID`),
UNIQUE KEY `UNIQUE_DATABASE` (`NAME`, `CTLG_NAME`),
CONSTRAINT `CTLG_FK1` FOREIGN KEY (`CTLG_NAME`) REFERENCES `CTLGS` (`NAME`)
diff --git
a/standalone-metastore/src/main/sql/mysql/upgrade-2.3.0-to-3.0.0.mysql.sql
b/standalone-metastore/src/main/sql/mysql/upgrade-2.3.0-to-3.0.0.mysql.sql
index 9b87563..8d4b5a0 100644
--- a/standalone-metastore/src/main/sql/mysql/upgrade-2.3.0-to-3.0.0.mysql.sql
+++ b/standalone-metastore/src/main/sql/mysql/upgrade-2.3.0-to-3.0.0.mysql.sql
@@ -235,8 +235,8 @@ ALTER TABLE `DBS` ADD COLUMN `CTLG_NAME` VARCHAR(256);
UPDATE `DBS`
SET `CTLG_NAME` = 'hive';
--- Add the not null constraint
-ALTER TABLE `DBS` CHANGE COLUMN `CTLG_NAME` `CTLG_NAME` varchar(256) NOT NULL;
+-- Add the not null constraint and default value
+ALTER TABLE `DBS` CHANGE COLUMN `CTLG_NAME` `CTLG_NAME` varchar(256) NOT NULL
DEFAULT 'hive';
-- Put back the unique index
ALTER TABLE `DBS` ADD UNIQUE KEY `UNIQUE_DATABASE` (`NAME`, `CTLG_NAME`);
diff --git
a/standalone-metastore/src/main/sql/oracle/hive-schema-3.0.0.oracle.sql
b/standalone-metastore/src/main/sql/oracle/hive-schema-3.0.0.oracle.sql
index 63cc1f7..5836e0d 100644
--- a/standalone-metastore/src/main/sql/oracle/hive-schema-3.0.0.oracle.sql
+++ b/standalone-metastore/src/main/sql/oracle/hive-schema-3.0.0.oracle.sql
@@ -82,6 +82,9 @@ CREATE TABLE CTLGS (
UNIQUE ("NAME")
);
+-- Insert a default value. The location is TBD. Hive will fix this when it
starts
+INSERT INTO CTLGS VALUES (1, 'hive', 'Default catalog for Hive', 'TBD');
+
-- Table DBS for classes [org.apache.hadoop.hive.metastore.model.MDatabase]
CREATE TABLE DBS
(
@@ -91,7 +94,7 @@ CREATE TABLE DBS
"NAME" VARCHAR2(128) NULL,
OWNER_NAME VARCHAR2(128) NULL,
OWNER_TYPE VARCHAR2(10) NULL,
- CTLG_NAME VARCHAR2(256)
+ CTLG_NAME VARCHAR2(256) DEFAULT 'hive'
);
ALTER TABLE DBS ADD CONSTRAINT DBS_PK PRIMARY KEY (DB_ID);
diff --git
a/standalone-metastore/src/main/sql/oracle/hive-schema-3.1.0.oracle.sql
b/standalone-metastore/src/main/sql/oracle/hive-schema-3.1.0.oracle.sql
index 90388e7..afb14fd 100644
--- a/standalone-metastore/src/main/sql/oracle/hive-schema-3.1.0.oracle.sql
+++ b/standalone-metastore/src/main/sql/oracle/hive-schema-3.1.0.oracle.sql
@@ -83,6 +83,9 @@ CREATE TABLE CTLGS (
UNIQUE ("NAME")
);
+-- Insert a default value. The location is TBD. Hive will fix this when it
starts
+INSERT INTO CTLGS VALUES (1, 'hive', 'Default catalog for Hive', 'TBD');
+
-- Table DBS for classes [org.apache.hadoop.hive.metastore.model.MDatabase]
CREATE TABLE DBS
(
@@ -92,7 +95,7 @@ CREATE TABLE DBS
"NAME" VARCHAR2(128) NULL,
OWNER_NAME VARCHAR2(128) NULL,
OWNER_TYPE VARCHAR2(10) NULL,
- CTLG_NAME VARCHAR2(256)
+ CTLG_NAME VARCHAR2(256) DEFAULT 'hive'
);
ALTER TABLE DBS ADD CONSTRAINT DBS_PK PRIMARY KEY (DB_ID);
diff --git
a/standalone-metastore/src/main/sql/oracle/upgrade-2.3.0-to-3.0.0.oracle.sql
b/standalone-metastore/src/main/sql/oracle/upgrade-2.3.0-to-3.0.0.oracle.sql
index ce3437f..766f92b 100644
--- a/standalone-metastore/src/main/sql/oracle/upgrade-2.3.0-to-3.0.0.oracle.sql
+++ b/standalone-metastore/src/main/sql/oracle/upgrade-2.3.0-to-3.0.0.oracle.sql
@@ -247,7 +247,7 @@ UPDATE DBS
SET "CTLG_NAME" = 'hive';
-- Add the not null constraint
-ALTER TABLE DBS MODIFY CTLG_NAME NOT NULL;
+ALTER TABLE DBS MODIFY CTLG_NAME DEFAULT 'hive' NOT NULL;
-- Put back the unique index
CREATE UNIQUE INDEX UNIQUE_DATABASE ON DBS ("NAME", CTLG_NAME);
diff --git
a/standalone-metastore/src/main/sql/postgres/hive-schema-3.0.0.postgres.sql
b/standalone-metastore/src/main/sql/postgres/hive-schema-3.0.0.postgres.sql
index 97697f8..84ffc9e 100644
--- a/standalone-metastore/src/main/sql/postgres/hive-schema-3.0.0.postgres.sql
+++ b/standalone-metastore/src/main/sql/postgres/hive-schema-3.0.0.postgres.sql
@@ -66,6 +66,9 @@ CREATE TABLE "CTLGS" (
"LOCATION_URI" VARCHAR(4000) NOT NULL
);
+-- Insert a default value. The location is TBD. Hive will fix this when it
starts
+INSERT INTO "CTLGS" VALUES (1, 'hive', 'Default catalog for Hive', 'TBD');
+
--
-- Name: DBS; Type: TABLE; Schema: public; Owner: hiveuser; Tablespace:
--
@@ -77,7 +80,7 @@ CREATE TABLE "DBS" (
"NAME" character varying(128) DEFAULT NULL::character varying,
"OWNER_NAME" character varying(128) DEFAULT NULL::character varying,
"OWNER_TYPE" character varying(10) DEFAULT NULL::character varying,
- "CTLG_NAME" varchar(256)
+ "CTLG_NAME" varchar(256) DEFAULT 'hive'
);
diff --git
a/standalone-metastore/src/main/sql/postgres/hive-schema-3.1.0.postgres.sql
b/standalone-metastore/src/main/sql/postgres/hive-schema-3.1.0.postgres.sql
index 028d091..901d89f 100644
--- a/standalone-metastore/src/main/sql/postgres/hive-schema-3.1.0.postgres.sql
+++ b/standalone-metastore/src/main/sql/postgres/hive-schema-3.1.0.postgres.sql
@@ -66,6 +66,9 @@ CREATE TABLE "CTLGS" (
"LOCATION_URI" VARCHAR(4000) NOT NULL
);
+-- Insert a default value. The location is TBD. Hive will fix this when it
starts
+INSERT INTO "CTLGS" VALUES (1, 'hive', 'Default catalog for Hive', 'TBD');
+
--
-- Name: DBS; Type: TABLE; Schema: public; Owner: hiveuser; Tablespace:
--
@@ -77,7 +80,7 @@ CREATE TABLE "DBS" (
"NAME" character varying(128) DEFAULT NULL::character varying,
"OWNER_NAME" character varying(128) DEFAULT NULL::character varying,
"OWNER_TYPE" character varying(10) DEFAULT NULL::character varying,
- "CTLG_NAME" varchar(256)
+ "CTLG_NAME" varchar(256) DEFAULT 'hive'
);
diff --git
a/standalone-metastore/src/main/sql/postgres/upgrade-2.3.0-to-3.0.0.postgres.sql
b/standalone-metastore/src/main/sql/postgres/upgrade-2.3.0-to-3.0.0.postgres.sql
index f2571d8..8a8a00a 100644
---
a/standalone-metastore/src/main/sql/postgres/upgrade-2.3.0-to-3.0.0.postgres.sql
+++
b/standalone-metastore/src/main/sql/postgres/upgrade-2.3.0-to-3.0.0.postgres.sql
@@ -268,7 +268,10 @@ UPDATE "DBS"
-- Add the not null constraint
ALTER TABLE "DBS" ALTER COLUMN "CTLG_NAME" SET NOT NULL;
--- Put back the unique index
+-- Add the default catalog name
+ALTER TABLE "DBS" ALTER COLUMN "CTLG_NAME" SET DEFAULT 'hive';
+
+-- Put back the unique index
ALTER TABLE "DBS" ADD CONSTRAINT "UNIQUE_DATABASE" UNIQUE ("NAME",
"CTLG_NAME");
-- Add the foreign key
diff --git
a/standalone-metastore/src/test/java/org/apache/hadoop/hive/metastore/tools/TestSchemaToolForMetastore.java
b/standalone-metastore/src/test/java/org/apache/hadoop/hive/metastore/tools/TestSchemaToolForMetastore.java
index 9e425cf..515d903 100644
---
a/standalone-metastore/src/test/java/org/apache/hadoop/hive/metastore/tools/TestSchemaToolForMetastore.java
+++
b/standalone-metastore/src/test/java/org/apache/hadoop/hive/metastore/tools/TestSchemaToolForMetastore.java
@@ -338,7 +338,7 @@ public class TestSchemaToolForMetastore {
// Test valid case
String[] scripts = new String[] {
- "insert into CTLGS values (1, 'mycat', 'mydescription',
'hdfs://myhost.com:8020/user/hive/warehouse');",
+ "insert into CTLGS values (2, 'mycat', 'mydescription',
'hdfs://myhost.com:8020/user/hive/warehouse');",
"insert into DBS values(2, 'my db',
'hdfs://myhost.com:8020/user/hive/warehouse/mydb', 'mydb', 'public', 'role',
'mycat');",
"insert into DBS values(7, 'db with bad port',
'hdfs://myhost.com:8020/', 'haDB', 'public', 'role', 'mycat');",
"insert into
SDS(SD_ID,CD_ID,INPUT_FORMAT,IS_COMPRESSED,IS_STOREDASSUBDIRECTORIES,LOCATION,NUM_BUCKETS,OUTPUT_FORMAT,SERDE_ID)
values
(1,null,'org.apache.hadoop.mapred.TextInputFormat','N','N','hdfs://myhost.com:8020/user/hive/warehouse/mydb',-1,'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat',null);",
@@ -467,7 +467,7 @@ public class TestSchemaToolForMetastore {
// Insert the records in DB to simulate a hive table
private void createTestHiveTableSchemas() throws IOException {
String[] scripts = new String[] {
- "insert into CTLGS values (1, 'mycat', 'my description',
'hdfs://myhost.com:8020/user/hive/warehouse');",
+ "insert into CTLGS values (2, 'mycat', 'my description',
'hdfs://myhost.com:8020/user/hive/warehouse');",
"insert into DBS values(2, 'my db',
'hdfs://myhost.com:8020/user/hive/warehouse/mydb', 'mydb', 'public', 'role',
'mycat');",
"insert into
SDS(SD_ID,CD_ID,INPUT_FORMAT,IS_COMPRESSED,IS_STOREDASSUBDIRECTORIES,LOCATION,NUM_BUCKETS,OUTPUT_FORMAT,SERDE_ID)
values
(1,null,'org.apache.hadoop.mapred.TextInputFormat','N','N','hdfs://myhost.com:8020/user/hive/warehouse/mydb',-1,'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat',null);",
"insert into
SDS(SD_ID,CD_ID,INPUT_FORMAT,IS_COMPRESSED,IS_STOREDASSUBDIRECTORIES,LOCATION,NUM_BUCKETS,OUTPUT_FORMAT,SERDE_ID)
values
(2,null,'org.apache.hadoop.mapred.TextInputFormat','N','N','hdfs://myhost.com:8020/user/admin/2015_11_18',-1,'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat',null);",
