JonathanLoscalzo commented on issue #3354: URL: https://github.com/apache/hop/issues/3354#issuecomment-1793557489
> the generate sql is just a suggestion I honestly never use it. we can take a look at it No problem with the generated sql. Looking more in depth into logging, I think that the issue is how the query in "Lookup/update" is being prepared: ``` lookup row : [123158], [2023/11/04 18:17:19.143], [2023/11/04 18:17:19.143] ERROR: Because of an error this transform can't continue: offending row : [payment_id Integer(9)], [date_from Date], [date_to Date] ``` I guess that duckdb (I don't know other db's) needs the format Y -- 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-unsubscr...@hop.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org