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 2014/10/05 08:57:33 UTC

[jira] [Commented] (TAJO-1026) Implement Query history persistency manager.

    [ https://issues.apache.org/jira/browse/TAJO-1026?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14159460#comment-14159460 ] 

ASF GitHub Bot commented on TAJO-1026:
--------------------------------------

GitHub user babokim opened a pull request:

    https://github.com/apache/tajo/pull/179

    TAJO-1026: Implement Query history persistency manager.

    Query history has the three types of files.
    - Query list file: saving  the list of query(default store is hdfs), hourly rolling, stored by TajoMaster.
    
    `<tajo.query-history.path>/<yyyyMMdd>/query-list/query-list-<sequence>.hist`
    
    - Query detail file: saving the query plan and execution block summary(default store is hdfs), single file per query or execution block, stored by QueryMaster.
    
    `<tajo.query-history.path>/<yyyyMMdd>/query-detail/<QUERY_ID>/query.hist`
    
    `<tajo.query-history.path>/<yyyyMMdd>/query-detail/<QUERY_ID>/<EB_ID>.hist` 
    
    - Task detail file: saving the task history(default is local), stored by Worker.
    
     `<tajo.task-history.path>/<yyyyMMdd>/tasks/<WORKER_HOST>_<WORKER_PORT>/<WORKER_HOST>_<WORKER_PORT>_<HH>_<seq>.hist`
    
    And I added page navigation in query.jsp and querytasks.jsp

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/babokim/tajo TAJO-1026

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/tajo/pull/179.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 #179
    
----
commit f9cd6c0129805f274cba63c4ff12e569bd0fd060
Author: HyoungJun Kim <ba...@babokim-macbook-pro.local>
Date:   2014-09-26T14:50:33Z

    TAJO-1026: Implement Query history persistency manager.
    Completed Writer

commit c6d3ba3952d0e0f4d9355e68d9eb040e5d334dd2
Author: HyoungJun Kim <ba...@babokim-macbook-pro.local>
Date:   2014-10-04T09:31:43Z

    TAJO-1026: Implement Query history persistency manager.

commit f3eed7f74bb12480b66980e4a098d5780b726abe
Author: HyoungJun Kim <ba...@babokim-macbook-pro.local>
Date:   2014-10-05T05:33:17Z

    TAJO-1026: Implement Query history persistency manager.

commit bad8e84c62629685b46c8f46316750509952bebf
Author: HyoungJun Kim <ba...@babokim-macbook-pro.local>
Date:   2014-10-05T05:34:05Z

    Merge branch 'master' of https://git-wip-us.apache.org/repos/asf/tajo into TAJO-1026

----


> Implement Query history persistency manager.
> --------------------------------------------
>
>                 Key: TAJO-1026
>                 URL: https://issues.apache.org/jira/browse/TAJO-1026
>             Project: Tajo
>          Issue Type: New Feature
>            Reporter: Hyoungjun Kim
>            Assignee: Hyoungjun Kim
>            Priority: Minor
>
> Currently query history stored in the memory of TajoMaster or QueryMaster. Query detail information is disappeared when the cluster is restarted. And because of memory limitations, only a few hours or a few days histories are kept.
> I suggest the following features for the query history.
> - Worker saves a query task history to the HDFS after finishing a query.
> - QueryMaster saves a query history to the HDFS after finishing a query.
> - If query is finished, Information Web server in TajoMaster shows query history in the web page, If query is running  TajoMaster forward to QueryMaster.
> - History data will be saved to HDFS with JSON format.
> - JSON format has history file version for backward compatibility.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)