[
https://issues.apache.org/jira/browse/PHOENIX-5649?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17101245#comment-17101245
]
Geoffrey Jacoby edited comment on PHOENIX-5649 at 5/6/20, 10:52 PM:
--------------------------------------------------------------------
[~larsh] [~swaroopa] - This may have something to do with the particular view /
table schema being used. Phoenix has some big performance problems when doing
M/R jobs or queries on views where the view predicate skips part of the PK.
(For example, when doing an M/R job on an entire view on top of a multi-tenant
table where the view spans tenants.) In that case, I believe Phoenix is doing a
table scan over and over.
A way to fix this would be to work PHOENIX-5248 to allow for multi-tenant
tables to use a non-leading PK column, and then redo the table in question as
"view predicate"/tenant rather than tenant/"view predicate".
was (Author: gjacoby):
[~larsh] [~swaroopa] - This may have something to do with the particular view /
table schema being used. Phoenix has some big performance problems when doing
M/R jobs or queries on views where the view predicate skips part of the PK.
(For example, when doing an M/R job on an entire view on top of a multi-tenant
table where the view spans tenants.) In that case, I believe Phoenix is doing a
table scan over and over.
A way to fix this would be to work PHOENIX-5248 to allow for multi-tenant
tables to use a non-leading PK column, and then redo the table in question as
"view predicate"-tenant rather than tenant-"view predicate".
> IndexScrutinyTool is very slow on view-indexes
> ----------------------------------------------
>
> Key: PHOENIX-5649
> URL: https://issues.apache.org/jira/browse/PHOENIX-5649
> Project: Phoenix
> Issue Type: Improvement
> Affects Versions: 4.14.3
> Reporter: Swaroopa Kadam
> Assignee: Swaroopa Kadam
> Priority: Major
> Fix For: 5.1.0, 4.15.1, 4.16.1
>
>
> From view-index to view, it scrutinizes about 7 rows per minute with batch
> size 1.
> From view to view-index, it is about 1000 rows per minute with batch size 1,
> which is also very slow.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
