[
https://issues.apache.org/jira/browse/PHOENIX-1213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14131322#comment-14131322
]
ASF GitHub Bot commented on PHOENIX-1213:
-----------------------------------------
GitHub user karel1980 opened a pull request:
https://github.com/apache/phoenix/pull/14
PHOENIX-1213 Avoid TableNotFoundException on update/delete to multi-tena...
Added test case + solution discussed on jira
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/karel1980/phoenix PHOENIX-1213
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/phoenix/pull/14.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #14
----
commit 4719e8ad6cfb8f230436534b66e90ea117c0830a
Author: Karel Vervaeke <[email protected]>
Date: 2014-09-12T09:20:08Z
PHOENIX-1213 Avoid TableNotFoundException on update/delete to multi-tenant
tables
Added test case + solution
----
> Upsert and delete do not work for multi-tenant tables using tenant-specific
> connections
> ---------------------------------------------------------------------------------------
>
> Key: PHOENIX-1213
> URL: https://issues.apache.org/jira/browse/PHOENIX-1213
> Project: Phoenix
> Issue Type: Bug
> Reporter: Eli Levine
> Assignee: Eli Levine
> Attachments: csvloader_multitenancy_test.cleanup.patch,
> csvloader_multitenancy_test.patch
>
>
> Reported by [[email protected]] on user mailing list:
> Here is a first testcase which triggers what
> looks like a bug to me. I would expect this to work, but the last
> statement fails (upsert and commit) with
> org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03):
> Table undefined. tableName=TEST
> Note that just before, I execute a select query on the same table.
> Thanks for looking into this,
> Jan
> {code}
> @Test
> public void phoenixMultiTenancyTest() throws Exception {
> HBaseTestingUtility testUtil = new HBaseTestingUtility();
> testUtil.startMiniCluster();
> String globalUrl = "jdbc:phoenix:localhost:" +
> testUtil.getConfiguration().get("hbase.zookeeper.property.clientPort");
> Connection globalConn = DriverManager.getConnection(globalUrl);
> Statement stmt = globalConn.createStatement();
> stmt.execute("CREATE TABLE test (tenant_id VARCHAR not null, id
> bigint not null, " +
> "first_name varchar constraint pk primary key(tenant_id, id))
> MULTI_TENANT=true");
> stmt.execute("upsert into test values('jan', 1, 'a')");
> stmt.execute("upsert into test values('bruno', 1, 'b')");
> globalConn.commit();
> String tenantUrl = globalUrl + ";TenantId=jan";
> Connection tenantConn = DriverManager.getConnection(tenantUrl);
> Statement tenantStmt = tenantConn.createStatement();
> // this works and is correctly limited to only data for tenant "jan"
> ResultSet rs = tenantStmt.executeQuery("select id, first_name from
> test");
> Assert.assertTrue(rs.next());
> Assert.assertEquals("1", rs.getString(1));
> Assert.assertEquals("a", rs.getString(2));
> Assert.assertFalse(rs.next());
> // this fails with TableNotFoundException
> tenantStmt.execute("upsert into test values (2, 'b')");
> tenantConn.commit();
> }
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
