[jira] [Commented] (PHOENIX-1089) Row value constructors performance issue with multi-tenant views

["James Taylor (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/PHOENIX-1089?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14068878#comment-14068878 ] 

James Taylor commented on PHOENIX-1089:
---------------------------------------

[~samarthjain] - Can you attach a unit test to put in WhereOptimizerTest that repros this (i.e. demonstrates that for a tenant-specific connection, an IN list with RVC for all columns does not use the skip scan as it should)?

> Row value constructors performance issue with multi-tenant views
> ----------------------------------------------------------------
>
>                 Key: PHOENIX-1089
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1089
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 3.0.0, 4.0.0, 5.0.0
>            Reporter: Samarth Jain
>            Assignee: Samarth Jain
>
> Row value constructors expect all pk columns to be present in braces. However, tenant-specific views (and maybe also regular views?) add the tenant_id column like this:
> tenant_id = 'abc' AND (pkcol1, pkcol2) in ('a', 'b'). This likely brakes the performance benefit afforded by row-value constructors.
> To make row value constructors work correctly it should be :
> (tenant_id, pkcol1, pkcol2) in ('abc', 'a', 'b')
> [~jamestaylor]



--
This message was sent by Atlassian JIRA
(v6.2#6252)