[
https://issues.apache.org/jira/browse/PHOENIX-4371?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16248593#comment-16248593
]
James Taylor edited comment on PHOENIX-4371 at 11/11/17 6:42 PM:
-----------------------------------------------------------------
+1 with a couple of nits:
- 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}
was (Author: jamestaylor):
+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)
