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

Add description for EXPLAIN statement

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.12.0, 0.11.1
    • Component/s: Documentation
    • Labels:

      Description

      Currently, Tajo already provides EXPLAIN statement. But users may not know it because of document absence. So, we need to add description on the following page. http://tajo.apache.org/docs/current/sql_language.html

        Activity

        Hide
        githubbot ASF GitHub Bot added a comment -

        GitHub user blrunner opened a pull request:

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

        TAJO-2061: Add description for EXPLAIN statement.

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

        $ git pull https://github.com/blrunner/tajo TAJO-2061

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

        https://github.com/apache/tajo/pull/947.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 #947


        commit 66071b14dd5e77514589c37e3446c84b0d294ff8
        Author: JaeHwa Jung <blrunner@apache.org>
        Date: 2016-01-22T07:37:31Z

        TAJO-2061: Add description for EXPLAIN statement.


        Show
        githubbot ASF GitHub Bot added a comment - GitHub user blrunner opened a pull request: https://github.com/apache/tajo/pull/947 TAJO-2061 : Add description for EXPLAIN statement. You can merge this pull request into a Git repository by running: $ git pull https://github.com/blrunner/tajo TAJO-2061 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/tajo/pull/947.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 #947 commit 66071b14dd5e77514589c37e3446c84b0d294ff8 Author: JaeHwa Jung <blrunner@apache.org> Date: 2016-01-22T07:37:31Z TAJO-2061 : Add description for EXPLAIN statement.
        Hide
        githubbot ASF GitHub Bot added a comment -

        Github user jinossy commented on a diff in the pull request:

        https://github.com/apache/tajo/pull/947#discussion_r50515287

        — Diff: tajo-docs/src/main/sphinx/sql_language/explain.rst —
        @@ -0,0 +1,93 @@
        +************************
        +EXPLAIN
        +************************
        +
        +Synopsis
        +
        +.. code-block:: sql
        +
        + EXPLAIN [GLOBAL] statement
        +
        +
        +Description
        +
        +Show the logical or distributed execution plan of a statement.
        +
        +
        +Examples
        +
        +Logical plan:
        +
        +.. code-block:: sql
        +
        + default> EXPLAIN SELECT l_orderkey, count FROM lineitem GROUP BY l_orderkey;
        + explain
        + -------------------------------
        + GROUP_BY(1)(l_orderkey)
        + => exprs: (count())
        + => target list: default.lineitem.l_orderkey (INT8), ?count (INT8)
        + => out schema:

        {(2) default.lineitem.l_orderkey (INT8), ?count (INT8)}

        + => in schema:

        {(1) default.lineitem.l_orderkey (INT8)}
        + SCAN(0) on default.lineitem
        + => target list: default.lineitem.l_orderkey (INT8)
        + => out schema: {(1) default.lineitem.l_orderkey (INT8)}

        + => in schema:

        {(16) default.lineitem.l_orderkey (INT8), default.lineitem.l_partkey (INT8), default.lineitem.l_suppkey (INT8), default.lineitem.l_linenumber (INT8), default.lineitem.l_quantity (FLOAT8), default.lineitem.l_extendedprice (FLOAT8), default.lineitem.l_discount (FLOAT8), default.lineitem.l_tax (FLOAT8), default.lineitem.l_returnflag (TEXT), default.lineitem.l_linestatus (TEXT), default.lineitem.l_shipdate (DATE), default.lineitem.l_commitdate (DATE), default.lineitem.l_receiptdate (DATE), default.lineitem.l_shipinstruct (TEXT), default.lineitem.l_shipmode (TEXT), default.lineitem.l_comment (TEXT)}

        +
        +
        +Distributed plan:
        — End diff –

        How about global plan?

        Show
        githubbot ASF GitHub Bot added a comment - Github user jinossy commented on a diff in the pull request: https://github.com/apache/tajo/pull/947#discussion_r50515287 — Diff: tajo-docs/src/main/sphinx/sql_language/explain.rst — @@ -0,0 +1,93 @@ +************************ +EXPLAIN +************************ + + Synopsis + +.. code-block:: sql + + EXPLAIN [GLOBAL] statement + + + Description + +Show the logical or distributed execution plan of a statement. + + + Examples + +Logical plan: + +.. code-block:: sql + + default> EXPLAIN SELECT l_orderkey, count FROM lineitem GROUP BY l_orderkey; + explain + ------------------------------- + GROUP_BY(1)(l_orderkey) + => exprs: (count()) + => target list: default.lineitem.l_orderkey (INT8), ?count (INT8) + => out schema: {(2) default.lineitem.l_orderkey (INT8), ?count (INT8)} + => in schema: {(1) default.lineitem.l_orderkey (INT8)} + SCAN(0) on default.lineitem + => target list: default.lineitem.l_orderkey (INT8) + => out schema: {(1) default.lineitem.l_orderkey (INT8)} + => in schema: {(16) default.lineitem.l_orderkey (INT8), default.lineitem.l_partkey (INT8), default.lineitem.l_suppkey (INT8), default.lineitem.l_linenumber (INT8), default.lineitem.l_quantity (FLOAT8), default.lineitem.l_extendedprice (FLOAT8), default.lineitem.l_discount (FLOAT8), default.lineitem.l_tax (FLOAT8), default.lineitem.l_returnflag (TEXT), default.lineitem.l_linestatus (TEXT), default.lineitem.l_shipdate (DATE), default.lineitem.l_commitdate (DATE), default.lineitem.l_receiptdate (DATE), default.lineitem.l_shipinstruct (TEXT), default.lineitem.l_shipmode (TEXT), default.lineitem.l_comment (TEXT)} + + +Distributed plan: — End diff – How about global plan?
        Hide
        githubbot ASF GitHub Bot added a comment -

        Github user blrunner commented on the pull request:

        https://github.com/apache/tajo/pull/947#issuecomment-173858385

        Thanks @jinossy . I rebased your comments.

        Show
        githubbot ASF GitHub Bot added a comment - Github user blrunner commented on the pull request: https://github.com/apache/tajo/pull/947#issuecomment-173858385 Thanks @jinossy . I rebased your comments.
        Hide
        githubbot ASF GitHub Bot added a comment -

        Github user jinossy commented on the pull request:

        https://github.com/apache/tajo/pull/947#issuecomment-173859389

        +1 LGTM!

        Show
        githubbot ASF GitHub Bot added a comment - Github user jinossy commented on the pull request: https://github.com/apache/tajo/pull/947#issuecomment-173859389 +1 LGTM!
        Hide
        githubbot ASF GitHub Bot added a comment -

        Github user asfgit closed the pull request at:

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

        Show
        githubbot ASF GitHub Bot added a comment - Github user asfgit closed the pull request at: https://github.com/apache/tajo/pull/947
        Hide
        hudson Hudson added a comment -

        FAILURE: Integrated in Tajo-master-CODEGEN-build #663 (See https://builds.apache.org/job/Tajo-master-CODEGEN-build/663/)
        TAJO-2061: Add description for EXPLAIN statement. (blrunner: rev 3cf7f24bc1133d3c0df1ef6031ce075bdf97fb7f)

        • tajo-docs/src/main/sphinx/sql_language.rst
        • CHANGES
        • tajo-docs/src/main/sphinx/sql_language/explain.rst
        Show
        hudson Hudson added a comment - FAILURE: Integrated in Tajo-master-CODEGEN-build #663 (See https://builds.apache.org/job/Tajo-master-CODEGEN-build/663/ ) TAJO-2061 : Add description for EXPLAIN statement. (blrunner: rev 3cf7f24bc1133d3c0df1ef6031ce075bdf97fb7f) tajo-docs/src/main/sphinx/sql_language.rst CHANGES tajo-docs/src/main/sphinx/sql_language/explain.rst
        Hide
        blrunner Jaehwa Jung added a comment -

        Thanks Jinho Kim. I've just committed it to master branch and 0.11.1 branch.

        Show
        blrunner Jaehwa Jung added a comment - Thanks Jinho Kim . I've just committed it to master branch and 0.11.1 branch.
        Hide
        hudson Hudson added a comment -

        SUCCESS: Integrated in Tajo-0.11.1-build #158 (See https://builds.apache.org/job/Tajo-0.11.1-build/158/)
        TAJO-2061: Add description for EXPLAIN statement. (blrunner: rev 8d44f538489cc08e0a61c1ac5986f48982fc418f)

        • tajo-docs/src/main/sphinx/sql_language/explain.rst
        • CHANGES
        • tajo-docs/src/main/sphinx/sql_language.rst
        Show
        hudson Hudson added a comment - SUCCESS: Integrated in Tajo-0.11.1-build #158 (See https://builds.apache.org/job/Tajo-0.11.1-build/158/ ) TAJO-2061 : Add description for EXPLAIN statement. (blrunner: rev 8d44f538489cc08e0a61c1ac5986f48982fc418f) tajo-docs/src/main/sphinx/sql_language/explain.rst CHANGES tajo-docs/src/main/sphinx/sql_language.rst
        Hide
        hudson Hudson added a comment -

        SUCCESS: Integrated in Tajo-master-build #1064 (See https://builds.apache.org/job/Tajo-master-build/1064/)
        TAJO-2061: Add description for EXPLAIN statement. (blrunner: rev 3cf7f24bc1133d3c0df1ef6031ce075bdf97fb7f)

        • tajo-docs/src/main/sphinx/sql_language.rst
        • tajo-docs/src/main/sphinx/sql_language/explain.rst
        • CHANGES
        Show
        hudson Hudson added a comment - SUCCESS: Integrated in Tajo-master-build #1064 (See https://builds.apache.org/job/Tajo-master-build/1064/ ) TAJO-2061 : Add description for EXPLAIN statement. (blrunner: rev 3cf7f24bc1133d3c0df1ef6031ce075bdf97fb7f) tajo-docs/src/main/sphinx/sql_language.rst tajo-docs/src/main/sphinx/sql_language/explain.rst CHANGES

          People

          • Assignee:
            blrunner Jaehwa Jung
            Reporter:
            blrunner Jaehwa Jung
          • Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development