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

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupcommits @
categorieshive, hadoop
postedApr 8, '14 at 2:29p
activeApr 8, '14 at 2:29p
posts1
users1
websitehive.apache.org

1 user in discussion

Hashutosh: 1 post

People

Translate

site design / logo © 2021 Grokbase