I test streaming to read data through JDBCInputFormat with code snippet as
below (scala 2.11, flink 1.0)

val input = JDBCInputFormat.buildJDBCInputFormat.
                    setDrivername(driver).
                    setDBUrl(url).
                    setQuery(sql).
                    setUsername(user).
                    setPassword(password).
                    finish.
                    asInstanceOf[JDBCInputFormat[Tuple1[String]]]


val env = StreamExecutionEnvironment.getExecutionEnvironment
    val dataset = env.createInput(input)
    dataset.writeAsText("/tmp/jdbc.txt")
    env.execute("jdbc-test")

However submitting the job it throws

Type of TypeVariable 'OT' in 'class
org.apache.flink.api.common.io.RichInputFormat' could not be determined.
This is most likely a type erasure problem. The type extraction currently
supports types with generic variables only in cases where all variables in
the return type can be deduced from the input type(s).
org.apache.flink.api.java.typeutils.TypeExtractor.createTypeInfoWithTypeHierarchy(TypeExtractor.java:670)
org.apache.flink.api.java.typeutils.TypeExtractor.privateCreateTypeInfo(TypeExtractor.java:564)
org.apache.flink.api.java.typeutils.TypeExtractor.getInputFormatTypes(TypeExtractor.java:272)
org.apache.flink.streaming.api.environment.StreamExecutionEnvironment.createInput(StreamExecutionEnvironment.java:1011)
org.apache.flink.streaming.api.scala.StreamExecutionEnvironment.createInput(StreamExecutionEnvironment.scala:484)

Where should I add that OT stuff so to avoid the type erasure problem?

Thanks

Reply via email to