You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by "Geoffrey Jacoby (Jira)" <ji...@apache.org> on 2020/07/28 00:15:00 UTC

[jira] [Created] (PHOENIX-6049) Index rebuilds should record scan timestamp to job counter

Geoffrey Jacoby created PHOENIX-6049:
----------------------------------------

             Summary: Index rebuilds should record scan timestamp to job counter
                 Key: PHOENIX-6049
                 URL: https://issues.apache.org/jira/browse/PHOENIX-6049
             Project: Phoenix
          Issue Type: Improvement
            Reporter: Geoffrey Jacoby
            Assignee: Geoffrey Jacoby


The index tool output tables (PHOENIX_INDEX_TOOL and PHOENIX_INDEX_TOOL_RESULT) are both keyed on the effective scan time of the index rebuild. This makes the table quite difficult to query if you know the index you're interested in but not the exact millisecond it was last rebuilt.

Short term: record this timestamp in the Phoenix index rebuild job counters (this JIRA)
Longer term: we might want to consider reversing the PK to both cut down on hotspotting and make the table easier to query.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)