[FLINK-16264] SQLClientKafkaITCase fails with: Could not map the schema field 'rowtime' to a field from source.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.11.0
• Fix Version/s: 1.11.0
• Component/s: Table SQL / Client, Tests
• Labels: pull-request-available test-stability
• Assignee: Jingsong Lee
• Reporter: Robert Metzger
• Created: 24/Feb/20 23:21
• Updated: 28/Feb/20 10:00
• Resolved: 28/Feb/20 10:00

Description

https://travis-ci.org/apache/flink/jobs/654409366

18:42:33.227 [INFO] Running org.apache.flink.tests.util.kafka.SQLClientKafkaITCase
18:44:08.035 [ERROR] Tests run: 3, Failures: 0, Errors: 3, Skipped: 0, Time elapsed: 94.798 s <<< FAILURE! - in org.apache.flink.tests.util.kafka.SQLClientKafkaITCase
18:44:08.041 [ERROR] testKafka[0: kafka-version:0.10 kafka-sql-version:.*kafka-0.10.jar](org.apache.flink.tests.util.kafka.SQLClientKafkaITCase)  Time elapsed: 32.305 s  <<< ERROR!
java.io.IOException: 
Process execution failed due error. Error output:Exception in thread "main" org.apache.flink.table.client.SqlClientException: Unexpected exception. This is a bug. Please consider filing an issue.
	at org.apache.flink.table.client.SqlClient.main(SqlClient.java:190)
Caused by: org.apache.flink.table.client.gateway.SqlExecutionException: Could not create execution context.
	at org.apache.flink.table.client.gateway.local.ExecutionContext$Builder.build(ExecutionContext.java:779)
	at org.apache.flink.table.client.gateway.local.LocalExecutor.openSession(LocalExecutor.java:228)
	at org.apache.flink.table.client.SqlClient.start(SqlClient.java:98)
	at org.apache.flink.table.client.SqlClient.main(SqlClient.java:178)
Caused by: org.apache.flink.table.api.ValidationException: Could not map the schema field 'rowtime' to a field from source. Please specify the source field from which it can be derived.
	at org.apache.flink.table.descriptors.SchemaValidator.deriveFieldMapping(SchemaValidator.java:302)
	at org.apache.flink.streaming.connectors.kafka.KafkaTableSourceSinkFactoryBase.createStreamTableSource(KafkaTableSourceSinkFactoryBase.java:170)
	at org.apache.flink.table.factories.StreamTableSourceFactory.createTableSource(StreamTableSourceFactory.java:55)
	at org.apache.flink.table.factories.TableSourceFactory.createTableSource(TableSourceFactory.java:63)
	at org.apache.flink.table.factories.TableSourceFactory.createTableSource(TableSourceFactory.java:74)
	at org.apache.flink.table.client.gateway.local.ExecutionContext.createTableSource(ExecutionContext.java:384)
	at org.apache.flink.table.client.gateway.local.ExecutionContext.lambda$initializeCatalogs$6(ExecutionContext.java:585)
	at java.util.LinkedHashMap.forEach(LinkedHashMap.java:684)
	at org.apache.flink.table.client.gateway.local.ExecutionContext.initializeCatalogs(ExecutionContext.java:583)
	at org.apache.flink.table.client.gateway.local.ExecutionContext.initializeTableEnvironment(ExecutionContext.java:520)
	at org.apache.flink.table.client.gateway.local.ExecutionContext.<init>(ExecutionContext.java:165)
	at org.apache.flink.table.client.gateway.local.ExecutionContext.<init>(ExecutionContext.java:122)
	at org.apache.flink.table.client.gateway.local.ExecutionContext$Builder.build(ExecutionContext.java:768)
	... 3 more

	at org.apache.flink.tests.util.kafka.SQLClientKafkaITCase.insertIntoAvroTable(SQLClientKafkaITCase.java:175)
	at org.apache.flink.tests.util.kafka.SQLClientKafkaITCase.testKafka(SQLClientKafkaITCase.java:148)

Issue Links

• links to: GitHub Pull Request #11204