Flink自定义source读取clickhouse

昨晚想从clickhouse读取数据，愣是没找到clickhouse的flink的读取方法，一百度都是slink的，最后是找到一个clickhouse官方提供的jdbc方法，但还是用游标，好吧凑合着用
官方链接

package redo.source



import org.apache.flink.streaming.api.scala.StreamExecutionEnvironment
import org.apache.flink.api.scala._
import org.apache.flink.streaming.api.functions.source.SourceFunction

import java.sql.{
   Connection, DriverManager, Statement}
import java.util.{
   Date, Properties}
import scala.util.Random


case class User(user_id:Long,item_id:Long,cate_id:Long,pv:Int,fav:Int,cart:Int,buy:Int,times:Date)

object ClickHouseSources {
   
  def main(args: Array[String]): Unit = {
   
    val env =StreamExecutionEnvironment.getExecutionE