flinksql table类型数据存入clickhouse-sinkfunction版本

首先在click中进行创建表格
create table res (
                     sub String,
                     page_id String,
                     count int

)
    engine  = MergeTree()
        order by sub;
select * from res;

ospv为table数据



class clichhousesink extends RichSinkFunction<Row>{
    Connection cn=null;
    PreparedStatement ps =null;
    @Override
    public void open(Configuration parameters) throws Exception {
        Class.forName("ru.yandex.clickhouse.ClickHouseDriver");
        cn = DriverManager.getConnection("jdbc:clickhouse://hadoop102:8123?characterEncoding=utf8", "default", "");
        ps = cn.prepareStatement("insert into res values (?,?,?)");
    }

    @Override
    public void close() throws Exception {
        cn.close();
        ps.close();
    }

    @Override
    public void invoke(Row value, Context context) throws Exception {
        ps.setObject(1,value.getFieldAs(0));
        ps.setObject(2,value.getFieldAs(1));
        ps.setObject(3,value.getFieldAs(2));
        ps.executeUpdate();
    }
}