Is Map Support ?

[spz0507]

The newest feature is ClickHouse/ClickHouse#15806

[spz0507]

But I can't find it in ClickHouseDataType.java.
https://github.com/ClickHouse/clickhouse-jdbc/blob/master/src/main/java/ru/yandex/clickhouse/domain/ClickHouseDataType.java

[zhicwu]

Link #560

[zhicwu]

Still need some more time to test, but you will be able to use Map like below:

public void testMaps() throws Exception {
    try (Statement s = conn.createStatement()) {
        s.execute("DROP TABLE IF EXISTS test_maps");
        s.execute(
                "CREATE TABLE IF NOT EXISTS test_maps(ma Map(Integer, Array(String)), mi Map(Integer, Integer), ms Map(String, String)) ENGINE = Memory");
        s.execute("insert into test_maps values ({1:['11','12'],2:['22','23']},{1:11,2:22},{'k1':'v1','k2':'v2'})");

        try (ResultSet rs = s.executeQuery("select * from test_maps")) {
            assertTrue(rs.next());
            compareMap(rs.getObject("ma"),
                    Utils.mapOf(1, new String[] { "11", "12" }, 2, new String[] { "22", "23" }));
            compareMap(rs.getObject("mi"), Utils.mapOf(1, 11, 2, 22));
            compareMap(rs.getObject("ms"), Utils.mapOf("k1", "v1", "k2", "v2"));
        }

        s.execute("truncate table test_maps");
    }

    try (PreparedStatement s = conn.prepareStatement("insert into test_maps values(?,?,?)")) {
        s.setObject(1, Utils.mapOf(1, new String[] { "11", "12" }, 2, new String[] { "22", "23" }));
        s.setObject(2, Utils.mapOf(1, 11, 2, 22));
        s.setObject(3, Utils.mapOf("k1", "v1", "k2", "v2"));
        s.execute();
    }

    try (Statement s = conn.createStatement()) {
        try (ResultSet rs = s.executeQuery("select * from test_maps")) {
            assertTrue(rs.next());
            compareMap(rs.getObject("ma"),
                    Utils.mapOf(1, new String[] { "11", "12" }, 2, new String[] { "22", "23" }));
            compareMap(rs.getObject("mi"), Utils.mapOf(1, 11, 2, 22));
            compareMap(rs.getObject("ms"), Utils.mapOf("k1", "v1", "k2", "v2"));
        }
    }
}