[Feature][Connector-V2] Support multi-table source feature

[hailin0]

Search before asking

• I had searched in the feature and found no similar feature requirement.

Description

After #5395,#5581 finnished. SeaTunnel source can implement multi-table read for zeta. We should add implement multi-table interface for all SeaTunnel source, also need e2e testcase & docs. Please refer Jdbc source from #5581.

Please pick connector you want to implement it!

Type	Connector	Contributer	Status	Issue/PR
Source	fakesource		Done
Source	jdbc		Done	#5581
Source	Local-file	@ruanwenjun	Done	#5781
Source	cdc-mysql		Done
Source	cdc-sqlserver		Done
Source	cdc-oracle		Done
Source	cdc-mongodb
Source	tdengine
Source	starrocks
Source	socket
Source	paimon
Source	openmldb
Source	neo4j
Source	mongodb
Source	maxcompute
Source	kudu	@Carl-Zhou-CN	Done	#5714
Source	kafka	@zhilinli123		#5992
Source	pulsar
Source	iotdb
Source	influxdb
Source	elasticsearch	@FuYouJ
Source	iceberg
Source	hudi
Source	hive	@ruanwenjun		#5929
Source	localfile	@ruanwenjun	Done	#5781
Source	clickhouse	@Carl-Zhou-CN		#6230
Source	cassandra
Source	amazondynamodb
Source	Doris	@CodingGPT		#5731

Usage Scenario

No response

Related issues

No response

Are you willing to submit a PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[hailin0]

link #5652

[Carl-Zhou-CN]

Please assign me kudu

[hailin0]

Please assign me kudu

@Carl-Zhou-CN
Please comment this issue
#5714

[FlechazoW]

paimon\hive\cassandra please assign to me.

[hailin0]

paimon\hive\cassandra please assign to me.

@FlechazoW
I suggest you develop a connector first and wait until you commit the merge before continuing

[CodingGPT]

doris please assign to me, tks

[hailin0]

[Feature][Kudu] Support multi-table source read #5714

@CodingGPT Please comment this issue

#5731

[Carl-Zhou-CN]

clickhouse please assign to me, tks

[zhilinli123]

kafka multi-source , temporarily assigned to me and I will try to complete it,thks

[hailin0]

[Feature][Kafka] Support multi-table source read #5992

@Carl-Zhou-CN
#6230

[FuYouJ]

es please assign to me,

[zhilinli123]

paimon Temporarily assigned to me thks

[531651225]

influxdb please assign to me

[xiaochen-zhou]

starrocks please assign to me and I will try to complete it , thx

[hailin0]

es please assign to me,

@FuYouJ Please create new es issue link to this

[hailin0]

Please create new es issue link to this

@zhilinli123
Please create new issue link to this

[hailin0]

influxdb please assign to me

@531651225
Please create new issue link to this

[hailin0]

starrocks please assign to me and I will try to complete it , thx

@xiaochen-zhou
Please create new issue link to this

[FuYouJ]

es support multi-table source feature
#6730