You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hop.apache.org by "ggrohmann (via GitHub)" <gi...@apache.org> on 2023/02/27 17:13:38 UTC
[GitHub] [hop] ggrohmann opened a new issue, #2483: Wait for SQL: Passing date row results to pipeline
ggrohmann opened a new issue, #2483:
URL: https://github.com/apache/hop/issues/2483
The Pipeline Transformator seems to have an issue starting with version 2.2 in the following constellation:
Step
- "Wait for SQL" with "Custom SQL", "Add Rows to Resultset" and a column of date(time)
- Followinging Pipeline within the workflow
- Step "Get Rows From Result" within the pipeline (Data Type date)
2 possible outcomes for me:
(a) I receive directly the error in the pipeline: SAMPLEDATE None : Unknown type 0 specified.
(b) The pipeline does run completely and without a problem. However, if the workflow picks up the processing again, the following error appears (starting with hop 2.2):
SAMPLEDATE Timestamp : There was a data type error: the data type of java.lang.String object ['2023-02-27T13:00:00.000'] does not correspond to value meta [Timestamp] (through reference chain: org.apache.hop.execution.ExecutionData["rowsBinaryGzipBase64Encoded"])
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [hop] hansva commented on issue #2483: Wait for SQL: Passing date row results to pipeline
Posted by "hansva (via GitHub)" <gi...@apache.org>.
hansva commented on issue #2483:
URL: https://github.com/apache/hop/issues/2483#issuecomment-1446768233
what is the database type?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [hop] hansva commented on issue #2483: [Bug] Wait for SQL: Passing date row results to pipeline
Posted by "hansva (via GitHub)" <gi...@apache.org>.
hansva commented on issue #2483:
URL: https://github.com/apache/hop/issues/2483#issuecomment-1452134432
could you add a sample (you have to zip it as GitHub does not accept our file types). It will make debugging this a bit faster for us.
As far as variables go, they are all strings... Which are cast to the type you select in the Get Variables transform
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [hop] ggrohmann commented on issue #2483: Wait for SQL: Passing date row results to pipeline
Posted by "ggrohmann (via GitHub)" <gi...@apache.org>.
ggrohmann commented on issue #2483:
URL: https://github.com/apache/hop/issues/2483#issuecomment-1447781618
Tested with a MS SQL Server/ Database
It does work, if I pass the result as a string (or rather if I grab it in the pipeline as a string via Get rows from result).
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [hop] ggrohmann commented on issue #2483: [Bug] Wait for SQL: Passing date row results to pipeline
Posted by "ggrohmann (via GitHub)" <gi...@apache.org>.
ggrohmann commented on issue #2483:
URL: https://github.com/apache/hop/issues/2483#issuecomment-1452156444
> could you add a sample (you have to zip it as GitHub does not accept our file types). It will make debugging this a bit faster for us. As far as variables go, they are all strings... Which are cast to the type you select in the Get Variables transform
added above
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [hop] ggrohmann commented on issue #2483: [Bug] Wait for SQL: Passing date row results to pipeline
Posted by "ggrohmann (via GitHub)" <gi...@apache.org>.
ggrohmann commented on issue #2483:
URL: https://github.com/apache/hop/issues/2483#issuecomment-1452118370
It seems a very weird behaviour. I continued testing with this issue since I got similar effects in other occasions. It doesn't seem to be dependent on the Wait for SQL step and rather indicates an issue how string and date values are in general passed to the variables of a workflow or pipeline.
I do have a pipeline, where I write a date value (system date), which was altered to a string (Select values), to the variables of the workflow above. This step fails with version (b) from above. However, if I put in a delay row step of 1sec, it runs smoothly without any errors. Seems to be an issue of the engine imho.
works
doesn't work
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org