phoenix-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Abhishek Singh Chouhan (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-5180) Add API to PhoenixRunTime to get ptable of a tenant using a global connection
Date Thu, 07 Mar 2019 21:40:00 GMT

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

Abhishek Singh Chouhan commented on PHOENIX-5180:
-------------------------------------------------

I can try taking this up if no one else is working on this. [~tdsilva]

> Add API to PhoenixRunTime to get ptable of a tenant using a global connection
> -----------------------------------------------------------------------------
>
>                 Key: PHOENIX-5180
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-5180
>             Project: Phoenix
>          Issue Type: New Feature
>            Reporter: Thomas D'Silva
>            Priority: Major
>              Labels: SFDC
>
> If we want to look up the PTable of a tenant view we currently need to create a tenant
specific connection and call {{PhoenixRuntime.getTable()}}. This could be inefficient if we
need to create millions of tenant specific connections.
>  We could instead just pass in the tenant id and use a global connection
>  {{getTable(Connection conn, String tenantId, String name)}}
> If the table isn't cached we would need to make a rpc to fetch the table from SYSTEM.CATALOG
> {code}
> MetaDataMutationResult result = new MetaDataClient(pconn).updateCache(PName tenantId,
String schemaName, String tableName)
> {code}
> FYI [~andrew.purtell@gmail.com]



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message