chunjun icon indicating copy to clipboard operation
chunjun copied to clipboard
verified publisher icon DTStack

[Question][JDBC] splitpk error

Open kinoxyz1 opened this issue 3 years ago • 1 comments

Search before asking

  • [X] I had searched in the issues and found no similar question.

  • [X] I had googled my question but i didn't get any help.

  • [X] I had read the documentation: ChunJun doc but it didn't help me.

Description

Using splitpk will automatically check the Min/Max value of pk in the database. When there are 1 billion data in a single table, the query will take a long time and cause the task to fail.

Can you manually set the Min/Max value and calculate the step size based on this value, for example: image image

Code of Conduct

kinoxyz1 avatar Mar 01 '23 05:03 kinoxyz1

it's a nice idea

ll076110 avatar Mar 02 '23 08:03 ll076110