You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2014/04/08 16:29:19 UTC
svn commit: r1585744 - in /hive/branches/branch-0.13/metastore/scripts/upgrade/mysql: hive-schema-0.13.0.mysql.sql hive-txn-schema-0.13.0.mysql.sql

Author: hashutosh
Date: Tue Apr  8 14:29:19 2014
New Revision: 1585744

URL: http://svn.apache.org/r1585744
Log:
HIVE-6855 : A couple of errors in MySQL db creation script for transaction tables (Alan Gates via Ashutosh Chauhan)

Modified:
    hive/branches/branch-0.13/metastore/scripts/upgrade/mysql/hive-schema-0.13.0.mysql.sql
    hive/branches/branch-0.13/metastore/scripts/upgrade/mysql/hive-txn-schema-0.13.0.mysql.sql

Modified: hive/branches/branch-0.13/metastore/scripts/upgrade/mysql/hive-schema-0.13.0.mysql.sql
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/metastore/scripts/upgrade/mysql/hive-schema-0.13.0.mysql.sql?rev=1585744&r1=1585743&r2=1585744&view=diff
==============================================================================
--- hive/branches/branch-0.13/metastore/scripts/upgrade/mysql/hive-schema-0.13.0.mysql.sql (original)
+++ hive/branches/branch-0.13/metastore/scripts/upgrade/mysql/hive-schema-0.13.0.mysql.sql Tue Apr  8 14:29:19 2014
@@ -806,7 +806,7 @@ CREATE TABLE TXNS (
   TXN_LAST_HEARTBEAT bigint NOT NULL,
   TXN_USER varchar(128) NOT NULL,
   TXN_HOST varchar(128) NOT NULL
-) ENGINE=InnoDB;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 CREATE TABLE TXN_COMPONENTS (
   TC_TXNID bigint,
@@ -814,18 +814,18 @@ CREATE TABLE TXN_COMPONENTS (
   TC_TABLE varchar(128),
   TC_PARTITION varchar(767),
   FOREIGN KEY (TC_TXNID) REFERENCES TXNS (TXN_ID)
-) ENGINE=InnoDB;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 CREATE TABLE COMPLETED_TXN_COMPONENTS (
   CTC_TXNID bigint,
   CTC_DATABASE varchar(128) NOT NULL,
   CTC_TABLE varchar(128),
   CTC_PARTITION varchar(767)
-) ENGINE=InnoDB;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 CREATE TABLE NEXT_TXN_ID (
   NTXN_NEXT bigint NOT NULL
-) ENGINE=InnoDB;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 INSERT INTO NEXT_TXN_ID VALUES(1);
 
 CREATE TABLE HIVE_LOCKS (
@@ -843,13 +843,13 @@ CREATE TABLE HIVE_LOCKS (
   HL_HOST varchar(128) NOT NULL,
   PRIMARY KEY(HL_LOCK_EXT_ID, HL_LOCK_INT_ID),
   KEY HIVE_LOCK_TXNID_INDEX (HL_TXNID)
-) ENGINE=InnoDB;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
-CREATE INDEX HL_TXNID_IDX ON HIVE_LOCKS (HL_TXNID) USING HASH;
+CREATE INDEX HL_TXNID_IDX ON HIVE_LOCKS (HL_TXNID);
 
 CREATE TABLE NEXT_LOCK_ID (
   NL_NEXT bigint NOT NULL
-) ENGINE=InnoDB;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 INSERT INTO NEXT_LOCK_ID VALUES(1);
 
 CREATE TABLE COMPACTION_QUEUE (
@@ -862,11 +862,11 @@ CREATE TABLE COMPACTION_QUEUE (
   CQ_WORKER_ID varchar(128),
   CQ_START bigint,
   CQ_RUN_AS varchar(128)
-);
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 CREATE TABLE NEXT_COMPACTION_QUEUE_ID (
   NCQ_NEXT bigint NOT NULL
-);
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 INSERT INTO NEXT_COMPACTION_QUEUE_ID VALUES(1);
 
 

Modified: hive/branches/branch-0.13/metastore/scripts/upgrade/mysql/hive-txn-schema-0.13.0.mysql.sql
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/metastore/scripts/upgrade/mysql/hive-txn-schema-0.13.0.mysql.sql?rev=1585744&r1=1585743&r2=1585744&view=diff
==============================================================================
--- hive/branches/branch-0.13/metastore/scripts/upgrade/mysql/hive-txn-schema-0.13.0.mysql.sql (original)
+++ hive/branches/branch-0.13/metastore/scripts/upgrade/mysql/hive-txn-schema-0.13.0.mysql.sql Tue Apr  8 14:29:19 2014
@@ -24,7 +24,7 @@ CREATE TABLE TXNS (
   TXN_LAST_HEARTBEAT bigint NOT NULL,
   TXN_USER varchar(128) NOT NULL,
   TXN_HOST varchar(128) NOT NULL
-) ENGINE=InnoDB;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 CREATE TABLE TXN_COMPONENTS (
   TC_TXNID bigint,
@@ -32,18 +32,18 @@ CREATE TABLE TXN_COMPONENTS (
   TC_TABLE varchar(128),
   TC_PARTITION varchar(767),
   FOREIGN KEY (TC_TXNID) REFERENCES TXNS (TXN_ID)
-) ENGINE=InnoDB;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 CREATE TABLE COMPLETED_TXN_COMPONENTS (
   CTC_TXNID bigint,
   CTC_DATABASE varchar(128) NOT NULL,
   CTC_TABLE varchar(128),
   CTC_PARTITION varchar(767)
-) ENGINE=InnoDB;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 CREATE TABLE NEXT_TXN_ID (
   NTXN_NEXT bigint NOT NULL
-) ENGINE=InnoDB;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 INSERT INTO NEXT_TXN_ID VALUES(1);
 
 CREATE TABLE HIVE_LOCKS (
@@ -61,13 +61,13 @@ CREATE TABLE HIVE_LOCKS (
   HL_HOST varchar(128) NOT NULL,
   PRIMARY KEY(HL_LOCK_EXT_ID, HL_LOCK_INT_ID),
   KEY HIVE_LOCK_TXNID_INDEX (HL_TXNID)
-) ENGINE=InnoDB;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
-CREATE INDEX HL_TXNID_IDX ON HIVE_LOCKS (HL_TXNID) USING HASH;
+CREATE INDEX HL_TXNID_IDX ON HIVE_LOCKS (HL_TXNID);
 
 CREATE TABLE NEXT_LOCK_ID (
   NL_NEXT bigint NOT NULL
-) ENGINE=InnoDB;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 INSERT INTO NEXT_LOCK_ID VALUES(1);
 
 CREATE TABLE COMPACTION_QUEUE (
@@ -80,11 +80,11 @@ CREATE TABLE COMPACTION_QUEUE (
   CQ_WORKER_ID varchar(128),
   CQ_START bigint,
   CQ_RUN_AS varchar(128)
-);
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 CREATE TABLE NEXT_COMPACTION_QUEUE_ID (
   NCQ_NEXT bigint NOT NULL
-);
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 INSERT INTO NEXT_COMPACTION_QUEUE_ID VALUES(1);