GitHub user bamaer added a comment to the discussion: Oracle Table Input with
variables (${LAST_RUN_TS}, ${LAST_RUN_ID}) failing in Apache Hop
We've basically given you all the information you need, but you'll have to do
your part of the work and study the examples to make sure you get to a working
situation.
What I would do in your situation (if passing timestamps to your query is your
main goal):
- add `FROM_DATE` and `TO_DATE` parameters to your pipeline. Parameters are not
exactly the same as variables, but they behave exactly the same within the
context of a pipeline. If this works with parameters, it should be
straightforward to move on afterwards
- use the easiest, most basic query possible to get used to working with
variables: "select * from MY_TABLE where the_date > '${FROM_DATE}' and the_date
< '${TO_DATE}'. If that works (again, with the most basic date format first),
you'll know how variable replacement in your queries works, and you can move on
to more complex examples.
-
Again: don't aim for everything and the kitchen sink all at once, break it down
into small, manageable pieces and move in small steps.
GitHub link:
https://github.com/apache/hop/discussions/6250#discussioncomment-15346342
----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]
