You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@tajo.apache.org by bl...@apache.org on 2016/05/10 04:53:08 UTC
tajo git commit: TAJO-2117: Add some missing index to MariaDBStore
Repository: tajo
Updated Branches:
refs/heads/master 34c5d5f24 -> 96b19f12c
TAJO-2117: Add some missing index to MariaDBStore
Closes #1012
Signed-off-by: JaeHwa Jung <bl...@apache.org>
Project: http://git-wip-us.apache.org/repos/asf/tajo/repo
Commit: http://git-wip-us.apache.org/repos/asf/tajo/commit/96b19f12
Tree: http://git-wip-us.apache.org/repos/asf/tajo/tree/96b19f12
Diff: http://git-wip-us.apache.org/repos/asf/tajo/diff/96b19f12
Branch: refs/heads/master
Commit: 96b19f12c1cf461c83717dd9817b685eee94a323
Parents: 34c5d5f
Author: Janaka Chathuranga Thilakarathna <bj...@gmail.com>
Authored: Tue May 10 13:50:12 2016 +0900
Committer: JaeHwa Jung <bl...@apache.org>
Committed: Tue May 10 13:50:12 2016 +0900
----------------------------------------------------------------------
CHANGES | 3 +++
.../src/main/resources/schemas/mariadb/mariadb.xml | 14 +++++++++-----
2 files changed, 12 insertions(+), 5 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/tajo/blob/96b19f12/CHANGES
----------------------------------------------------------------------
diff --git a/CHANGES b/CHANGES
index c653d99..4389665 100644
--- a/CHANGES
+++ b/CHANGES
@@ -261,6 +261,9 @@ Release 0.12.0 - unreleased
TASKS
+ TAJO-2117: Add some missing index to MariaDBStore.
+ (Janaka Chathuranga Thilakarathna via jaehwa)
+
TAJO-2142: Temporarily disable NOT IN subquery. (jihoon)
TAJO-2088: Change QueryTestCaseBase.runSimpleTests() to return a set of
http://git-wip-us.apache.org/repos/asf/tajo/blob/96b19f12/tajo-catalog/tajo-catalog-server/src/main/resources/schemas/mariadb/mariadb.xml
----------------------------------------------------------------------
diff --git a/tajo-catalog/tajo-catalog-server/src/main/resources/schemas/mariadb/mariadb.xml b/tajo-catalog/tajo-catalog-server/src/main/resources/schemas/mariadb/mariadb.xml
index a94489d..4611e70 100644
--- a/tajo-catalog/tajo-catalog-server/src/main/resources/schemas/mariadb/mariadb.xml
+++ b/tajo-catalog/tajo-catalog-server/src/main/resources/schemas/mariadb/mariadb.xml
@@ -19,6 +19,7 @@
<tns:store xmlns:tns="http://tajo.apache.org/catalogstore" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://tajo.apache.org/catalogstore ../DBMSSchemaDefinition.xsd ">
<!--
Catalog base version history
+ * 13 - 2016-05-07: Add some missing index to MariaDBStore (TAJO-2117)
* 12 - 2015-09-28: Change the variable name storeType to dataFormat (TAJO-1663)
* 11 - 2015-09-23: Add contents length and file count for partition directory (TAJO-1493)
* 10 - 2015-09-22: Well support for self-describing data formats (TAJO-1832)
@@ -32,7 +33,7 @@
* 2 - 2014-06-09: First versioning
* 1- Before 2013-03-20
-->
- <tns:base version="12">
+ <tns:base version="13">
<tns:objects>
<tns:Object order="0" type="table" name="META">
<tns:sql><![CDATA[CREATE TABLE META (VERSION INT NOT NULL)]]></tns:sql>
@@ -126,7 +127,10 @@
)]]>
</tns:sql>
</tns:Object>
- <tns:Object order="7" type="table" name="STATS">
+ <tns:Object order="7" type="index" name="INDEXES_IDX_TID_COLUMN_NAME" dependsOn="INDEXES">
+ <tns:sql><![CDATA[CREATE INDEX INDEXES_IDX_TID_COLUMN_NAME on INDEXES (DB_ID, TID, COLUMN_NAMES)]]></tns:sql>
+ </tns:Object>
+ <tns:Object order="8" type="table" name="STATS">
<tns:sql><![CDATA[
CREATE TABLE STATS (
TID INT NOT NULL PRIMARY KEY,
@@ -136,7 +140,7 @@
)]]>
</tns:sql>
</tns:Object>
- <tns:Object order="8" type="table" name="PARTITION_METHODS">
+ <tns:Object order="9" type="table" name="PARTITION_METHODS">
<tns:sql><![CDATA[
CREATE TABLE PARTITION_METHODS (
TID INT NOT NULL PRIMARY KEY,
@@ -147,7 +151,7 @@
)]]>
</tns:sql>
</tns:Object>
- <tns:Object order="9" type="table" name="PARTITIONS">
+ <tns:Object order="10" type="table" name="PARTITIONS">
<tns:sql><![CDATA[
CREATE TABLE PARTITIONS (
PARTITION_ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
@@ -160,7 +164,7 @@
)]]>
</tns:sql>
</tns:Object>
- <tns:Object order="10" type="table" name="PARTITION_KEYS">
+ <tns:Object order="11" type="table" name="PARTITION_KEYS">
<tns:sql><![CDATA[
CREATE TABLE PARTITION_KEYS (
PARTITION_ID INT NOT NULL,