[
https://issues.apache.org/jira/browse/PHOENIX-1089?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Samarth Jain updated PHOENIX-1089:
----------------------------------
Attachment: testcases-PHOENIX1089.patch
[~jamestaylor] - attached is the patch for master branch. It has test cases for
tenant specific and non tenant specific views.
> 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
> Attachments: testcases-PHOENIX1089.patch
>
>
> 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)
