flink error Could not find a suitable table factory for 'org.apache.flink.table.factories.BatchTableSourceFactory' in the classpath

Question

I'm new to Apache Flink and I'm trying to read an Avro file as follows,

val schema = new Schema()
  .field("tconst", "string")
  .field("titleType", "string")
  .field("primaryTitle", "string")
  .field("originalTitle", "string")
  .field("isAdult", "int")
  .field("startYear", "string")
  .field("endYear", "string")
  .field("runtimeMinutes", "int")
  .field("genres", "string")

val avroFormat: Avro = new Avro()
  .avroSchema(
    "{" +
      "  \"type\": \"record\"," +
      "  \"name\": \"test\"," +
      "  \"fields\" : [" +
      "    {\"name\": \"tconst\", \"type\": \"string\"}," +
      "    {\"name\": \"titleType\", \"type\": \"string\"}" +
      "    {\"name\": \"primaryTitle\", \"type\": \"string\"}" +
      "    {\"name\": \"originalTitle\", \"type\": \"string\"}" +
      "    {\"name\":   \"isAdult\", \"type\": \"int\"}" +
      "    {\"name\": \"startYear\", \"type\": \"string\"}" +
      "    {\"name\": \"endYear\", \"type\": \"string\"}" +
      "    {\"name\": \"runtimeMinutes\", \"type\": \"int\"}" +
      "    {\"name\": \"genres\", \"type\": \"string\"}" +
      "  ]" +
      "}"
  )

tableEnv.connect(new FileSystem().path("/Users/x/Documents/test_1.avro"))
  .withSchema(schema)
  .withFormat(avroFormat)
  .registerTableSource("sink")

But when I run this I got the following error.

Exception in thread "main" org.apache.flink.table.api.NoMatchingTableFactoryException: Could not find a suitable table factory for 'org.apache.flink.table.factories.BatchTableSourceFactory' in
the classpath.

Reason: No context matches.

The following properties are requested:
connector.path=/Users/x/Documents/test_1.avro
connector.property-version=1
connector.type=filesystem
format.avro-schema=.... // above schema
format.property-version=1
format.type=avro
schema.0.name=tconst
schema.0.type=string
schema.1.name=titleType
schema.1.type=string
schema.2.name=primaryTitle
schema.2.type=string
schema.3.name=originalTitle
schema.3.type=string
schema.4.name=isAdult
schema.4.type=int
schema.5.name=startYear
schema.5.type=string
schema.6.name=endYear
schema.6.type=string
schema.7.name=runtimeMinutes
schema.7.type=int
schema.8.name=genres
schema.8.type=string

The following factories have been considered:
org.apache.flink.api.java.io.jdbc.JDBCTableSourceSinkFactory
org.apache.flink.table.sources.CsvBatchTableSourceFactory
org.apache.flink.table.sources.CsvAppendTableSourceFactory
org.apache.flink.table.sinks.CsvBatchTableSinkFactory
org.apache.flink.table.sinks.CsvAppendTableSinkFactory
org.apache.flink.formats.avro.AvroRowFormatFactory
org.apache.flink.streaming.connectors.kafka.KafkaTableSourceSinkFactory

In this Avro file it has a Flink Dataset and used AvroOutputFormat to write the file.

val avroOutputFormat = new AvroOutputFormat[Row](classOf[Row])
flinkDatase.write(avroOutputFormat, "/Users/x/Documents/test_1.avro").setParallelism(1)

I'm thinking, if it's a wrong type of data that could result the mentioned error. Is there a way to identify the exact problem of this?

Arvid Heise Arvid Heise · Accepted Answer · 2020-02-24T13:27:07

Sorry for misguiding you. As of now, Filesystem connector unfortunately does not support Avro.

So there is no option but to use dataset API. I recommend to use avrohugger to generate an appropriate scala class for your avro schema.

// convert to your scala class
val dsTuple: DataSet[User] = tableEnv.toDataSet[User](table)
// write out
val avroOutputFormat = new AvroOutputFormat<>(User.class)
avroOutputFormat.setCodec(Codec.SNAPPY)
avroOutputFormat.setSchema(User.SCHEMA$)
specificUser.write(avroOutputFormat, outputPath1)

flink error Could not find a suitable table factory for 'org.apache.flink.table.factories.BatchTableSourceFactory' in the classpath

1 Answers