phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-1213) Upsert and delete do not work for multi-tenant tables using tenant-specific connections
Date Fri, 12 Sep 2014 09:30:33 GMT

    [ 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 <karel@ngdata.com>
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 [~janvanbesien@ngdata.com] 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)

Mime
View raw message