GitHub user bamaer added a comment to the discussion: Direct Pipeline with No
Transforms
have you tried providing limits in your SQL query
`SELECT TOP 100 * FROM Employees ORDER BY Surname DESC;`
You could make this more dynamic through parameters/variables, something like:
`SELECT TOP ${NB_ROWS} START AT ${OFFSET} * FROM Employees ORDER BY Surname
DESC;`?
This last option will require you to build a loop to go over all the available
100 row result sets, but would give you more flexibility.
GitHub link:
https://github.com/apache/hop/discussions/4872#discussioncomment-12097814
----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]
