[
https://issues.apache.org/jira/browse/PHOENIX-1309?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14160476#comment-14160476
]
James Taylor commented on PHOENIX-1309:
---------------------------------------
bq. Where would you actually query the stats table?
I'll add a method to MetaDataClient and query from there
bq. Will you first do an ANALYZE on the index or view table and then query the
stats table for these local and view index tables?
We're already collecting stats for them during compaction/splits, we just can't
access them right now. You can do an ANALYZE on an index (using the index name)
too - we should add a test case for that. Also, to analyze all view or local
indexes, you'll be able to do any of these using the base table name as <table>:
- UPDATE STATISTICS <table> INDEX
- UPDATE STATISTICS <table> ALL
- UPDATE STATISTICS <table>
> Ensure Phoenix table is created for Local index and view index tables to
> store guideposts against them
> ------------------------------------------------------------------------------------------------------
>
> Key: PHOENIX-1309
> URL: https://issues.apache.org/jira/browse/PHOENIX-1309
> Project: Phoenix
> Issue Type: Sub-task
> Reporter: ramkrishna.s.vasudevan
> Assignee: James Taylor
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
