[
https://issues.apache.org/jira/browse/PHOENIX-2525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15068431#comment-15068431
]
James Taylor commented on PHOENIX-2525:
---------------------------------------
Looking at this closer, the root issue is that UPDATE STATISTICS <table> is
being executed transactionally against <table> when the table is transactional.
Instead UPDATE STATISTICS should always be run non transactionally, even if the
table is transactional. So most of these changes shouldn't be necessary.
A good test to add to TransactionIT is a test that calculates statistics over a
table with in flight transactions that have been written to HBase (maybe adapt
testReadOnlyView). The UPDATE STATISTICS call should see these (as well as data
on the invalid list) as it's simply trying to figure out equa-distant
guideposts for the data that exists.
> Views on transactional tables return no rows
> --------------------------------------------
>
> Key: PHOENIX-2525
> URL: https://issues.apache.org/jira/browse/PHOENIX-2525
> Project: Phoenix
> Issue Type: Bug
> Reporter: Mujtaba Chohan
> Assignee: Thomas D'Silva
> Attachments: PHOENIX-2525-wip.patch, PHOENIX-2525.patch
>
>
> Aggregate or non-aggregate queries do not return any rows to the client for
> views created over transactional table.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
