we have tried the following and it does not work
Class.forName("org.apache.calcite.jdbc.Driver"); Properties info = new Properties(); info.setProperty("lex", "JAVA"); info.setProperty(CalciteConnectionProperty.CASE_SENSITIVE.camelName(), "false"); info.setProperty("defaultSchema", "hr"); try { Connection connection = DriverManager.getConnection("jdbc:calcite:", info); CalciteConnection conn = connection.unwrap(CalciteConnection.class); SchemaPlus rootSchema = conn.getRootSchema();