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 want to clarify and consolidate my earlier post.
SELECT
FROM_TS,
TO_TS
FROM ETL_TABLE_CONTROL
WHERE table_name = 'XXSIFY_CPQ_ORDER_DETAILS_UDM'
Note: Despite the column names, both FROM_TS and TO_TS are defined as TIMESTAMP
in the database.
When I try to preview records for this query, no records are returned and
returned as null.
There is no transformation or logic applied — it’s a direct select from the
database.
Timestamp handling option is enabled (also tried disable/enable, no change).
Question:
Since this is a direct database read and not a transformation issue:
Is any implicit conversion or formatting required for TIMESTAMP columns to
appear in preview?
Is this expected behavior due to preview engine limitations?
Is there a known issue with TIMESTAMP data types in control tables?
GitHub link:
https://github.com/apache/hop/discussions/6250#discussioncomment-15374891
----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]
