GitHub user sivaguru-rajasekaran added a comment to the discussion: Oracle
Table Input with variables (${LAST_RUN_TS}, ${LAST_RUN_ID}) failing in Apache
Hop
I’m encountering an issue while retrieving timestamp columns directly from the
database.
Scenario:
No transformation or business logic is applied.
I’m simply selecting timestamp columns from a table and checking the preview.
The columns are defined as TIMESTAMP in the database.
Query used:
SELECT
FROM_TS,
TO_TS
FROM ETL_TABLE_CONTROL
WHERE table_name = 'XXSIFY_CPQ_ORDER_DETAILS_UDM';
Issue observed:
In the preview/output, both FROM_TS and TO_TS are returned as NULL.
Even tried timestamp as string getting this error , OriginalSql = SELECT *
FROM APPS.XXSIFY_CPQ_ORDER_DETAILS_UDM
WHERE CREATED_ON > '${FROM_TS_STR}'
AND CREATED_ON < '${TO_TS_STR}'
, Error Msg = ORA-01858: a non-numeric character was found where a numeric was
expected
Since this is a direct read from the database with no logic applied, I want to
understand if any additional configuration or mechanism is required to
correctly retrieve TIMESTAMP values in preview.
<img width="650" height="314" alt="image"
src="https://github.com/user-attachments/assets/e4a4303b-88eb-408c-94b6-9d1cc7842ab4";
/>
GitHub link:
https://github.com/apache/hop/discussions/6250#discussioncomment-15374703
----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]
