[jira] [Commented] (PHOENIX-4371) Document explain plan and how we expose estimate information in it

["James Taylor (JIRA)" <ji...@apache.org>]

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

James Taylor commented on PHOENIX-4371:
---------------------------------------

+1 with a couple of nots:
- make sure you link to the new explain page from the old location.
- simplify this slightly by removing the superfluous PreparedStatement code:
{code}
String explainSql = "EXPLAIN SELECT * FROM T";
ResultSet rs = conn.createStatement(explainSql).executeQuery(explainSql);
 rs.next();
Long estimatedBytes =
                (Long) rs.getObject(PhoenixRuntime.EXPLAIN_PLAN_ESTIMATED_BYTES_READ_COLUMN);
Long estimatedRows =
                (Long) rs.getObject(PhoenixRuntime.EXPLAIN_PLAN_ESTIMATED_ROWS_READ_COLUMN);
Long estimateInfoTs =
                (Long) rs.getObject(PhoenixRuntime.EXPLAIN_PLAN_ESTIMATE_INFO_TS_COLUMN);
{code}

> Document explain plan and how we expose estimate information in it
> ------------------------------------------------------------------
>
>                 Key: PHOENIX-4371
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-4371
>             Project: Phoenix
>          Issue Type: Task
>            Reporter: Samarth Jain
>            Assignee: Samarth Jain
>         Attachments: explainplan.md
>
>




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)