Examples of net.hydromatic.optiq.SchemaPlus

net.hydromatic.optiq.SchemaPlus
Extension to the {@link Schema} interface.
Given a user-defined schema that implements the {@link Schema} interface,Optiq creates a wrapper that implements the {@code SchemaPlus} interface.This provides extra functionality, such as access to tables that have been added explicitly.

A user-defined schema does not need to implement this interface, but by the time a schema is passed to a method in a user-defined schema or user-defined table, it will have been wrapped in this interface.

            + "  )\n")
            .contains("CorrelatorRel"));
  }


  public String checkTpchQuery(String tpchTestQuery) throws Exception {
    final SchemaPlus schema =
        Frameworks.createRootSchema(true).add("tpch",
            new ReflectiveSchema(new TpchSchema()));


    Planner p = Frameworks.getPlanner(Lex.MYSQL, schema,
        SqlStdOperatorTable.instance(), RuleSets.ofList(RULE_SET));

View Full Code Here

    return rel;
  }


  // OptiqCatalogReader is stateless; no need to store one
  private OptiqCatalogReader createCatalogReader() {
    SchemaPlus rootSchema = rootSchema(defaultSchema);
    return new OptiqCatalogReader(
        OptiqSchema.from(rootSchema),
        caseSensitive,
        OptiqSchema.from(defaultSchema).path(null),
        typeFactory);

View Full Code Here

public class LinqFrontJdbcBackTest {
  @Test public void testTableWhere() throws SQLException,
      ClassNotFoundException {
    final OptiqConnection connection =
        OptiqAssert.getConnection(false);
    final SchemaPlus schema =
        connection.getRootSchema().getSubSchema("foodmart");
    ParameterExpression c =
        Expressions.parameter(JdbcTest.Customer.class, "c");
    String s =
        Schemas.queryable(Schemas.createDataContext(connection), schema,

View Full Code Here

    String s =
        Frameworks.withPlanner(
            new Frameworks.PlannerAction<String>() {
              public String apply(RelOptCluster cluster,
                  RelOptSchema relOptSchema, SchemaPlus rootSchema) {
                SchemaPlus schema =
                    rootSchema.add("hr",
                        new ReflectiveSchema(new JdbcTest.HrSchema()));
                final RelJsonReader reader =
                    new RelJsonReader(cluster, relOptSchema, schema);
                RelNode node;

View Full Code Here

    final SqlStdOperatorTable stdOpTab = SqlStdOperatorTable.instance();
    SqlOperatorTable opTab = new ChainedSqlOperatorTable(
        ImmutableList.of(stdOpTab,
            new ListSqlOperatorTable(
                ImmutableList.<SqlOperator>of(new MyCountAggFunction()))));
    final SchemaPlus rootSchema = Frameworks.createRootSchema(true);
    final FrameworkConfig config = Frameworks.newConfigBuilder()
        .defaultSchema(
            OptiqAssert.addSchema(rootSchema, OptiqAssert.SchemaSpec.HR))
        .operatorTable(opTab)
        .build();

View Full Code Here

          containsString("Expression 'deptno' is not being grouped"));
    }
  }


  private Planner getPlanner(List<RelTraitDef> traitDefs, Program... programs) {
    final SchemaPlus rootSchema = Frameworks.createRootSchema(true);
    final FrameworkConfig config = Frameworks.newConfigBuilder()
        .lex(Lex.ORACLE)
        .defaultSchema(
            OptiqAssert.addSchema(rootSchema, OptiqAssert.SchemaSpec.HR))
        .traitDefs(traitDefs)

View Full Code Here

  }


  /** Checks that a query returns a particular plan, using a planner with
   * OptimizeBushyJoinRule enabled. */
  private void checkBushy(String sql, String expected) throws Exception {
    final SchemaPlus rootSchema = Frameworks.createRootSchema(true);
    final FrameworkConfig config = Frameworks.newConfigBuilder()
        .lex(Lex.ORACLE)
        .defaultSchema(
            OptiqAssert.addSchema(rootSchema,
                OptiqAssert.SchemaSpec.CLONE_FOODMART))

View Full Code Here

            + "  )\n")
            .contains("CorrelatorRel"));
  }


  public String checkTpchQuery(String tpchTestQuery) throws Exception {
    final SchemaPlus schema =
        Frameworks.createRootSchema(true).add("tpch",
            new ReflectiveSchema(new TpchSchema()));


    final FrameworkConfig config = Frameworks.newConfigBuilder()
        .lex(Lex.MYSQL)

View Full Code Here

    Class.forName("net.hydromatic.optiq.jdbc.Driver");
    Connection connection =
        DriverManager.getConnection("jdbc:optiq:");
    OptiqConnection optiqConnection =
        connection.unwrap(OptiqConnection.class);
    SchemaPlus rootSchema = optiqConnection.getRootSchema();
    rootSchema.add("hr", new ReflectiveSchema(new Hr()));
    rootSchema.add("foodmart", new ReflectiveSchema(new Foodmart()));
    Statement statement = connection.createStatement();
    ResultSet resultSet =
        statement.executeQuery(
            "select *\n"
            + "from \"foodmart\".\"sales_fact_1997\" as s\n"

View Full Code Here


  @Before
  public void setUp() throws SQLException {
    Connection connection = DriverManager.getConnection("jdbc:optiq:");
    OptiqConnection optiqConnection = connection.unwrap(OptiqConnection.class);
    SchemaPlus rootSchema = optiqConnection.getRootSchema();
    rootSchema.add("test", new ReflectiveSchema(new TestSchema()));
    optiqConnection.setSchema("test");
    this.conn = optiqConnection;
  }

View Full Code Here

0 1 2 3 4 5 6 7

TOP

Related Classes of net.hydromatic.optiq.SchemaPlus

net.hydromatic.optiq.examples.foodmart.java.JdbcExample

net.hydromatic.optiq.impl.interpreter.ScanNode

net.hydromatic.optiq.impl.splunk.SplunkDriver

net.hydromatic.optiq.prepare.PlannerImpl

net.hydromatic.optiq.test.ExceptionMessageTest

net.hydromatic.optiq.test.LinqFrontJdbcBackTest

net.hydromatic.optiq.test.MultiJdbcSchemaJoinTest

net.hydromatic.optiq.test.ReflectiveSchemaTest

net.hydromatic.optiq.tools.FrameworksTest

net.hydromatic.optiq.tools.PlannerTest

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.