You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Tanuj Khurana (Jira)" <ji...@apache.org> on 2020/11/10 20:15:00 UTC
[jira] [Created] (PHOENIX-6218) Rows deleted count is incorrect for
immutable tables with indexes
Tanuj Khurana created PHOENIX-6218:
--------------------------------------
Summary: Rows deleted count is incorrect for immutable tables with indexes
Key: PHOENIX-6218
URL: https://issues.apache.org/jira/browse/PHOENIX-6218
Project: Phoenix
Issue Type: Bug
Reporter: Tanuj Khurana
Assignee: Tanuj Khurana
For immutable tables if the best query plan for delete uses the data table and it has an index, the rows deleted count reported is #(rows updated)/#(tables updated) where # of rows updated only includes data table rows but the number of tables includes data + index. This reduces the row count than the actual rows deleted count.
The same problem can also happen if the best query plan uses the index table and there are more than one index present on the data table. In this case the rows updated will include both data table and the index table (one used by the query plan) but because there are other indexes also present the #(tables updated) will be more and we will get an inaccurate result.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)