You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@tajo.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2016/05/08 07:16:12 UTC
[jira] [Commented] (TAJO-2117) Add some missing index to
MariaDBStore
[ https://issues.apache.org/jira/browse/TAJO-2117?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15275503#comment-15275503 ]
ASF GitHub Bot commented on TAJO-2117:
--------------------------------------
GitHub user janakact opened a pull request:
https://github.com/apache/tajo/pull/1012
Added General Index for Maria DB
Added General Index : Consists of DB_ID and TID and COLUMN_NAMES
Issue: https://issues.apache.org/jira/browse/TAJO-2117
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/janakact/tajo TAJO-2117
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/tajo/pull/1012.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1012
----
commit 60d583a9fe33f1247120b947fe923251a9ae5598
Author: Janaka <ja...@users.noreply.github.com>
Date: 2016-05-07T09:43:14Z
Added General Index (DB_ID, TID and COLUMN_NAMES)
Added General Index : Consists of DB_ID and TID and COLUMN_NAMES
Issue: https://issues.apache.org/jira/browse/TAJO-2117
----
> Add some missing index to MariaDBStore
> --------------------------------------
>
> Key: TAJO-2117
> URL: https://issues.apache.org/jira/browse/TAJO-2117
> Project: Tajo
> Issue Type: Task
> Components: Catalog
> Reporter: Jaehwa Jung
> Assignee: Janaka Chathuranga Thilakarathna
> Priority: Minor
> Labels: newbie
> Fix For: 0.12.0
>
>
> Currently, the {{INDEXES}} table of MySQLStore has two indexes as following:
> * Unique index : Consists of {{DB_ID}} and {{INDEX_NAME}}
> * General Index : Consists of {{DB_ID}} and {{TID}} and {{COLUMN_NAMES}}
> But the table of MariaDBStore has only unique index. We need to create other index to the table.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)