[
https://issues.apache.org/jira/browse/PHOENIX-1475?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14222663#comment-14222663
]
ramkrishna.s.vasudevan commented on PHOENIX-1475:
-------------------------------------------------
For queries that needs to always use the stats, can we add some HINTs in the
query itselt to always use stats? So that would bypass this
'phoenix.stats.updateFrequency' setting and ensure always stats are used.
> Statistics are not immediately used after data load
> ---------------------------------------------------
>
> Key: PHOENIX-1475
> URL: https://issues.apache.org/jira/browse/PHOENIX-1475
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 5.0.0, 4.2
> Reporter: Mujtaba Chohan
> Assignee: James Taylor
> Priority: Minor
>
> Although statistics are available in stats table but they are not used when
> query is executed immediately after data is loaded in a table. Also _update
> statistics_ cannot be executed since _phoenix.stats.minUpdateFrequency_ has
> not elapsed nor are they are used immediately after running _major
> compaction_.
> Stats are used after _phoenix.stats.updateFrequency_ has elapsed but there is
> no way to force immediate use for uses cases such as performance test
> utilities and real time systems.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
