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

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

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?


> Add description for EXPLAIN statement
> -------------------------------------
>
>                 Key: TAJO-2061
>                 URL: https://issues.apache.org/jira/browse/TAJO-2061
>             Project: Tajo
>          Issue Type: Improvement
>          Components: Documentation
>            Reporter: Jaehwa Jung
>            Assignee: Jaehwa Jung
>            Priority: Minor
>              Labels: newbie
>             Fix For: 0.12.0, 0.11.1
>
>
> 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



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

Reply via email to