[
https://issues.apache.org/jira/browse/PHOENIX-4455?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16292125#comment-16292125
]
Ankit Singhal commented on PHOENIX-4455:
----------------------------------------
can you try our Index Scrutiny tool and post the keys which are not matching
between index table and data table.
Details on how to run the Index Scrutiny tool can be found at
https://phoenix.apache.org/secondary_indexing.html
> Index table exists dirty data
> -----------------------------
>
> Key: PHOENIX-4455
> URL: https://issues.apache.org/jira/browse/PHOENIX-4455
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.11.0
> Reporter: asko
> Priority: Critical
> Attachments: querypaln.png, select table.png
>
>
> The result of first query has one record, but the next query have two record
> from index table. It seems to that the index have dirty data.
> Index columns information and query plans:
> !querypaln.png!
> The results of query:
> !select table.png!
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
