Skip to main content
Question

how to use jdbc multitable consumer to get result with two different offset from the same table

  • April 20, 2023
  • 0 replies
  • 55 views

jqianglee
Fan

i hope to use jdbc multitable to gernerate sql like select * from test where create_time > offset order by create_time,   

select * from test where update_time > offset order by update_time.

one table is ordered by two offset respectively,and data is in a pipeline

i add two schema tabs,but i found the pipeline only output data according to the second schema tab config,the first schema config cannot take effct.

i do not know whether data according to the second schema tab config overwrite data according to the first