Examples with QueryPlan org.apache.phoenix.compile.QueryPlan used on opensource projects

Example 36 with QueryPlan

use of org.apache.phoenix.compile.QueryPlan in project phoenix by apache.

the class ViewIT method testQueryViewStatementOptimization.

@Test
public void testQueryViewStatementOptimization() throws Exception {
    Connection conn = DriverManager.getConnection(getUrl());
    String sql = "CREATE TABLE " + fullTableName + " (k1 INTEGER NOT NULL, k2 INTEGER NOT NULL, v1 DECIMAL, CONSTRAINT pk PRIMARY KEY (k1, k2))" + tableDDLOptions;
    conn.createStatement().execute(sql);
    String fullViewName1 = "V_" + generateUniqueName();
    sql = "CREATE VIEW " + fullViewName1 + "  AS SELECT * FROM " + fullTableName;
    conn.createStatement().execute(sql);
    String fullViewName2 = "V_" + generateUniqueName();
    sql = "CREATE VIEW " + fullViewName2 + "  AS SELECT * FROM " + fullTableName + " WHERE k1 = 1.0";
    conn.createStatement().execute(sql);
    sql = "SELECT * FROM " + fullViewName1 + " order by k1, k2";
    PreparedStatement stmt = conn.prepareStatement(sql);
    QueryPlan plan = PhoenixRuntime.getOptimizedQueryPlan(stmt);
    assertEquals(0, plan.getOrderBy().getOrderByExpressions().size());
    sql = "SELECT * FROM " + fullViewName2 + " order by k1, k2";
    stmt = conn.prepareStatement(sql);
    plan = PhoenixRuntime.getOptimizedQueryPlan(stmt);
    assertEquals(0, plan.getOrderBy().getOrderByExpressions().size());
}