[
https://issues.apache.org/jira/browse/PHOENIX-548?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gabriel Reid resolved PHOENIX-548.
----------------------------------
Resolution: Fixed
Bulk resolve of closed issues imported from GitHub. This status was reached by
first re-opening all closed imported issues and then resolving them in bulk.
> Wrong results after region split when client is instantiated before split
> -------------------------------------------------------------------------
>
> Key: PHOENIX-548
> URL: https://issues.apache.org/jira/browse/PHOENIX-548
> Project: Phoenix
> Issue Type: Task
> Affects Versions: 2.1.0-Release
> Reporter: mujtaba
> Assignee: James Taylor
> Labels: bug
>
> **Steps**
> 1. Create table and data
> 2. Create phoenix client instance
> 3. Split table
> 4. Run query in existing client instance: SELECT domain,max(core),
> round(date, 'second', 86400) FROM performance_1000000 where domain like
> 'App%' GROUP BY domain, round(date, 'second',86400)
> **Result (wrong):**
> DOMAIN MAX(CORE) ROUND(DATE,'second',86400)
> Apple.com 499 2013-09-09
> Apple.com 499 2013-09-10
> Apple.com 499 2013-09-11
> Apple.com 499 2013-09-12
> Apple.com 499 2013-09-13
> Apple.com 499 2013-09-14
> Apple.com 499 2013-09-15
> Apple.com 499 2013-09-16
> Apple.com 499 2013-09-17
> Apple.com 499 2013-09-18
> Apple.com 499 2013-09-09
> Apple.com 499 2013-09-10
> Apple.com 499 2013-09-11
> Apple.com 499 2013-09-18
> Apple.com 499 2013-09-09
> Apple.com 499 2013-09-10
> Apple.com 499 2013-09-11
> Apple.com 499 2013-09-18
> Apple.com 499 2013-09-09
> Apple.com 499 2013-09-10
> Apple.com 499 2013-09-11
> Apple.com 499 2013-09-18
> Apple.com 499 2013-09-19
> Apple.com 499 2013-09-20
> Apple.com 499 2013-09-10
> Apple.com 499 2013-09-11
> Apple.com 499 2013-09-12
> Apple.com 499 2013-09-13
> Apple.com 499 2013-09-14
> Apple.com 499 2013-09-20
> Apple.com 499 2013-09-10
> Apple.com 499 2013-09-11
> Apple.com 499 2013-09-12
> Apple.com 499 2013-09-13
> Apple.com 499 2013-09-14
> Apple.com 499 2013-09-20
> Apple.com 493 2013-09-09
> Apple.com 499 2013-09-10
> Apple.com 499 2013-09-11
> Apple.com 499 2013-09-12
> Apple.com 499 2013-09-13
> Apple.com 499 2013-09-14
> 5.Create new Phoenix client instance and run the same query.
> **Result (correct):**
> Apple.com 499 2013-09-09
> Apple.com 499 2013-09-10
> Apple.com 499 2013-09-11
> Apple.com 499 2013-09-12
> Apple.com 499 2013-09-13
> Apple.com 499 2013-09-14
> Apple.com 499 2013-09-15
> Apple.com 499 2013-09-16
> Apple.com 499 2013-09-17
> Apple.com 499 2013-09-18
> Apple.com 499 2013-09-19
> Apple.com 499 2013-09-20
--
This message was sent by Atlassian JIRA
(v6.2#6252)
