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
Query used:
SELECT
FROM_TS,
TO_TS
FROM ETL_TABLE_CONTROL
WHERE table_name = 'XXSIFY_CPQ_ORDER_DETAILS_UDM';
Problem:
FROM_TS and TO_TS are defined as TIMESTAMP columns.
When queried directly as TIMESTAMP, values do not appear in preview / result
set in Table input.
However, when I explicitly cast them to STRING (or VARCHAR), the values show
correctly in the preview.
Example:
SELECT
CAST(FROM_TS AS STRING),
CAST(TO_TS AS STRING)
FROM ETL_TABLE_CONTROL
WHERE table_name = 'XXSIFY_CPQ_ORDER_DETAILS_UDM';
Questions:
Is this a known issue with timestamp handling in preview/result rendering?
Could this be related to timezone, session settings, or internal conversion
factors?
Is there a recommended way to handle TIMESTAMP columns in control tables to
avoid this behavior?
Any guidance or workaround would be appreciated.
<img width="470" height="208" alt="image"
src="https://github.com/user-attachments/assets/352ee54f-1c81-4db4-9cd3-32729a0bb4ab";
/>
<img width="660" height="316" alt="image"
src="https://github.com/user-attachments/assets/1b52b18f-6559-41f8-871f-a76f34faa4d9";
/>
GitHub link:
https://github.com/apache/hop/discussions/6250#discussioncomment-15374510
----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]
