[
https://issues.apache.org/jira/browse/PHOENIX-1588?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14314694#comment-14314694
]
Maryann Xue commented on PHOENIX-1588:
--------------------------------------
Yes, think it is still there.
> TableNotFoundException when optimizing "SELECT * FROM a tenant-specific table"
> ------------------------------------------------------------------------------
>
> Key: PHOENIX-1588
> URL: https://issues.apache.org/jira/browse/PHOENIX-1588
> Project: Phoenix
> Issue Type: Bug
> Reporter: Maryann Xue
>
> Testcase:
> {code}
> public void testOptimizationTenantSpecific() throws Exception {
> createBaseTable(TestUtil.DEFAULT_DATA_TABLE_NAME, null,
> "('e','i','o')", true);
> Connection conn1 = DriverManager.getConnection(getUrl() + ';' +
> PhoenixRuntime.TENANT_ID_ATTRIB + "=tid1");
> try{
> conn1.createStatement().execute("UPSERT INTO " +
> TestUtil.DEFAULT_DATA_TABLE_NAME + " values(1,2,4,'z')");
> conn1.createStatement().execute("UPSERT INTO " +
> TestUtil.DEFAULT_DATA_TABLE_NAME + " values(1,2,3,'a')");
> conn1.createStatement().execute("UPSERT INTO " +
> TestUtil.DEFAULT_DATA_TABLE_NAME + " values(2,4,2,'a')");
> conn1.createStatement().execute("UPSERT INTO " +
> TestUtil.DEFAULT_DATA_TABLE_NAME + " values(3,1,1,'c')");
> conn1.commit();
> createIndex(TestUtil.DEFAULT_INDEX_TABLE_NAME,
> TestUtil.DEFAULT_DATA_TABLE_NAME, "v1");
>
> String query = "SELECT * FROM " +
> TestUtil.DEFAULT_DATA_TABLE_NAME +" where v1='a'";
> ResultSet rs = conn1.createStatement().executeQuery(query);
> assertTrue(rs.next());
> assertEquals(1, rs.getInt("k1"));
> assertEquals(2, rs.getInt("k2"));
> assertEquals(3, rs.getInt("k3"));
> assertEquals("a", rs.getString("v1"));
> assertTrue(rs.next());
> assertEquals(2, rs.getInt("k1"));
> assertEquals(4, rs.getInt("k2"));
> assertEquals(2, rs.getInt("k3"));
> assertEquals("a", rs.getString("v1"));
> assertFalse(rs.next());
> } finally {
> conn1.close();
> }
> }
> {code}
> Stacktrace:
> org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table
> undefined. tableName=T
> at
> org.apache.phoenix.schema.PMetaDataImpl.getTable(PMetaDataImpl.java:241)
> at
> org.apache.phoenix.compile.ProjectionCompiler.projectAllIndexColumns(ProjectionCompiler.java:174)
> at
> org.apache.phoenix.compile.ProjectionCompiler.compile(ProjectionCompiler.java:330)
> at
> org.apache.phoenix.compile.QueryCompiler.compileSingleFlatQuery(QueryCompiler.java:490)
> at
> org.apache.phoenix.compile.QueryCompiler.compileSingleQuery(QueryCompiler.java:447)
> at
> org.apache.phoenix.compile.QueryCompiler.compile(QueryCompiler.java:152)
> at
> org.apache.phoenix.optimize.QueryOptimizer.addPlan(QueryOptimizer.java:224)
> at
> org.apache.phoenix.optimize.QueryOptimizer.getApplicablePlans(QueryOptimizer.java:140)
> at
> org.apache.phoenix.optimize.QueryOptimizer.optimize(QueryOptimizer.java:81)
> at
> org.apache.phoenix.optimize.QueryOptimizer.optimize(QueryOptimizer.java:67)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:222)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:1)
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:216)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:1030)
> ...
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
