Uploaded image for project: 'Tajo'
  1. Tajo
  2. TAJO-1136

Implement queryable virtual table for query history

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: TajoMaster
    • Labels:
      None

      Description

      Currently, Tajo does not provide queryable query history. We can see the history form WEB UI or bin/tajo command.

      I propose that we should implement a virtual table where each row a running/finished/failed query and columns are query id, start time, finish time, query status, in/out bytes and other counts and statistic information.

      If we provide queryable feature for query history, we don't need to implement additional code to discovery queries. Especially, it would be very useful for following cases:

      • users can get some statistic information for their usages
      • Query optimizer can exploit statistic information

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                hyunsik Hyunsik Choi
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated: