Hi, Julian Thanks for your reply.
I have made some sense to modify configuration of calcite connection. But still the schema cache mechanism did not work. Sine I have seen CachingCalciteSchema use guava cache internal, so is there any example to make it work instead of creating dynamic schema every time. Regards ------------------ Zhao Jun Apache Sharding-Sphere & ServiceComb > On Nov 5, 2019, at 4:46 AM, Julian Hyde <[email protected]> wrote: > > Possibly related to https://issues.apache.org/jira/browse/CALCITE-3436 > <https://issues.apache.org/jira/browse/CALCITE-3436>. > >> On Nov 1, 2019, at 2:08 AM, zhaojun <[email protected]> wrote: >> >> Hi, all >> >> I have found a cache property in JsonSchema, default value was true，calcite >> version was 1.20.0 >> But when I create a calcite connection through DriverManager.getConnection, >> cache property value was null after Jackson deserialization. >> My code is like this >> >> ``` >> Properties properties = new Properties(); >> properties.setProperty("schema", schemaName); >> result.setProperty("schemaFactory", >> MemorySchemaFactory.class.getCanonicalName()); >> result.setProperty("lex", "MYSQL"); >> >> DriverManager.getConnection(CONNECTION_URL, properties); >> >> ``` >> How can I solve this issue? >> >> Regards >> >> ------------------ >> Zhao Jun >> Apache Sharding-Sphere & ServiceComb >> >
