Hi,
we are trying to make a dynamic reflective schema at github:
https://github.com/guxiaobo/calcite-json-adapter
we found our getRowType method has not been called when creating our JsonSchema
nor executing SQL, can you help checking what's missing.
below is the main test code:
Map<String, List<JSONObject>> map = new HashMap<String,
List<JSONObject>>();
List<JSONObject> t1 = new ArrayList<JSONObject>();
JSONObject r1 = new JSONObject();
t1.add(r1);
map.put("t1", t1);
r1.put("c1", Long.valueOf(100));
r1.put("c2", "column2");
r1.put("c3", Boolean.FALSE);
r1.put("c4", new BigDecimal("2.1"));
r1.put("c5", new java.sql.Date(2022, 2, 22));
r1.put("c6", new java.sql.Time(System.currentTimeMillis()));
r1.put("c7", new
java.sql.Timestamp(System.currentTimeMillis()));
String sql1 = "select count(*) from t1";
String sql2 = "select count(*) from js.t1";
Schema schema = new JsonSchema(map);