You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Samarth Jain (JIRA)" <ji...@apache.org> on 2014/07/15 21:41:05 UTC
[jira] [Created] (PHOENIX-1089) Row value constructors performance
issue with multi-tenant views
Samarth Jain created PHOENIX-1089:
-------------------------------------
Summary: 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)