Re: [I] [Bug]: Trying to use generic db with duckdb driver 0.9.1 (hop)
JonathanLoscalzo closed issue #3354: [Bug]: Trying to use generic db with duckdb driver 0.9.1 URL: https://github.com/apache/hop/issues/3354 -- 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
Re: [I] [Bug]: Trying to use generic db with duckdb driver 0.9.1 (hop)
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
Re: [I] [Bug]: Trying to use generic db with duckdb driver 0.9.1 (hop)
hansva commented on issue #3354: URL: https://github.com/apache/hop/issues/3354#issuecomment-1793538518 the generate sql is just a suggestion I honestly never use it. we can take a look at it -- 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
Re: [I] [Bug]: Trying to use generic db with duckdb driver 0.9.1 (hop)
JonathanLoscalzo commented on issue #3354: URL: https://github.com/apache/hop/issues/3354#issuecomment-1793536768 @hansva I have to remove the v0.7 and it works. But using the "Dimension Lookup/update" step it does not work with duckdb: - the generated sql has erros: ```sql CREATE TABLE warehouse.dim_payment ( payment_pk IDENTITY -- HERE: not correct, it should be INTEGER PRIMARY KEY , version INTEGER , date_from TIMESTAMP -- HERE I don't know why it could not be generated, bellow I have added the error , date_to TIMESTAMP -- HERE , payment_id INTEGER , customer_id SMALLINT , staff_id SMALLINT , rental_id INTEGER , amount DECIMAL(5, 2) ) ;CREATE INDEX idx_dim_payment_lookup ON warehouse.dim_payment(payment_id) ; CREATE BITMAP INDEX idx_dim_payment_tk ON warehouse.dim_payment(payment_pk) ; ``` - error when running the step on audit columns (date_from and date_to). ``` ERROR: Because of an error this transform can't continue: offending row : [payment_id Integer(9)], [date_from Date], [date_to Date] Error setting value #2 [Date] on prepared statement setTimestamp ERROR: org.apache.hop.core.exception.HopDatabaseException: offending row : [payment_id Integer(9)], [date_from Date], [date_to Date] Error setting value #2 [Date] on prepared statement setTimestamp at org.apache.hop.core.database.Database.setValues(Database.java:922) at org.apache.hop.pipeline.transforms.dimensionlookup.DimensionLookup.lookupValues(DimensionLookup.java:437) at org.apache.hop.pipeline.transforms.dimensionlookup.DimensionLookup.processRow(DimensionLookup.java:204) at org.apache.hop.pipeline.transform.RunThread.run(RunThread.java:55) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: org.apache.hop.core.exception.HopDatabaseException: Error setting value #2 [Date] on prepared statement setTimestamp at org.apache.hop.core.row.value.ValueMetaBase.setPreparedStatementValue(ValueMetaBase.java:5693) at org.apache.hop.core.database.Database.setValue(Database.java:905) at org.apache.hop.core.database.Database.setValues(Database.java:920) ... 4 more Caused by: java.sql.SQLFeatureNotSupportedException: setTimestamp at org.duckdb.DuckDBPreparedStatement.setTimestamp(DuckDBPreparedStatement.java:770) at org.apache.hop.core.row.value.ValueMetaBase.setPreparedStatementValue(ValueMetaBase.java:5644) ... 6 more ``` - if a field is a timestamp, the error is the same. -- 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
Re: [PR] Translations update from Weblate (hop)
hansva merged PR #3355: URL: https://github.com/apache/hop/pull/3355 -- 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
[PR] Translations update from Weblate (hop)
hop-weblate opened a new pull request, #3355: URL: https://github.com/apache/hop/pull/3355 Translations update from [Weblate](https://translate.project-hop.org) for [Apache Hop Codebase/Hop](https://translate.project-hop.org/projects/apache-hop-codebase/hop/). It also includes following components: * [Apache Hop Codebase/workflow 2](https://translate.project-hop.org/projects/apache-hop-codebase/workflow-2/) * [Apache Hop Codebase/foo](https://translate.project-hop.org/projects/apache-hop-codebase/foo/) * [Apache Hop Codebase/valuemapper](https://translate.project-hop.org/projects/apache-hop-codebase/valuemapper/) * [Apache Hop Codebase/blockuntiltransformsfinish](https://translate.project-hop.org/projects/apache-hop-codebase/blockuntiltransformsfinish/) * [Apache Hop Codebase/metadata 4](https://translate.project-hop.org/projects/apache-hop-codebase/metadata-4/) * [Apache Hop Codebase/execcql](https://translate.project-hop.org/projects/apache-hop-codebase/execcql/) * [Apache Hop Codebase/mysqlbulkload](https://translate.project-hop.org/projects/apache-hop-codebase/mysqlbulkload/) * [Apache Hop Codebase/meta](https://translate.project-hop.org/projects/apache-hop-codebase/meta/) * [Apache Hop Codebase/gui 4](https://translate.project-hop.org/projects/apache-hop-codebase/gui-4/) * [Apache Hop Codebase/mailvalidator](https://translate.project-hop.org/projects/apache-hop-codebase/mailvalidator/) * [Apache Hop Codebase/mail](https://translate.project-hop.org/projects/apache-hop-codebase/mail/) * [Apache Hop Codebase/cypherscript](https://translate.project-hop.org/projects/apache-hop-codebase/cypherscript/) * [Apache Hop Codebase/gui 3](https://translate.project-hop.org/projects/apache-hop-codebase/gui-3/) * [Apache Hop Codebase/ftp](https://translate.project-hop.org/projects/apache-hop-codebase/ftp/) * [Apache Hop Codebase/stringoperations](https://translate.project-hop.org/projects/apache-hop-codebase/stringoperations/) * [Apache Hop Codebase/http](https://translate.project-hop.org/projects/apache-hop-codebase/http/) * [Apache Hop Codebase/webservices](https://translate.project-hop.org/projects/apache-hop-codebase/webservices/) * [Apache Hop Codebase/shell](https://translate.project-hop.org/projects/apache-hop-codebase/shell/) * [Apache Hop Codebase/rest](https://translate.project-hop.org/projects/apache-hop-codebase/rest/) * [Apache Hop Codebase/googleanalytics](https://translate.project-hop.org/projects/apache-hop-codebase/googleanalytics/) * [Apache Hop Codebase/kafka](https://translate.project-hop.org/projects/apache-hop-codebase/kafka/) * [Apache Hop Codebase/plugins 1](https://translate.project-hop.org/projects/apache-hop-codebase/plugins-1/) * [Apache Hop Codebase/tableinput](https://translate.project-hop.org/projects/apache-hop-codebase/tableinput/) * [Apache Hop Codebase/googlesheets](https://translate.project-hop.org/projects/apache-hop-codebase/googlesheets/) * [Apache Hop Codebase/cassandraoutput](https://translate.project-hop.org/projects/apache-hop-codebase/cassandraoutput/) * [Apache Hop Codebase/producer](https://translate.project-hop.org/projects/apache-hop-codebase/producer/) * [Apache Hop Codebase/delay 1](https://translate.project-hop.org/projects/apache-hop-codebase/delay-1/) * [Apache Hop Codebase/uniquerowsbyhashset](https://translate.project-hop.org/projects/apache-hop-codebase/uniquerowsbyhashset/) * [Apache Hop Codebase/model](https://translate.project-hop.org/projects/apache-hop-codebase/model/) * [Apache Hop Codebase/flattener](https://translate.project-hop.org/projects/apache-hop-codebase/flattener/) * [Apache Hop Codebase/detectemptystream](https://translate.project-hop.org/projects/apache-hop-codebase/detectemptystream/) * [Apache Hop Codebase/delete](https://translate.project-hop.org/projects/apache-hop-codebase/delete/) * [Apache Hop Codebase/pgpdecryptstream](https://translate.project-hop.org/projects/apache-hop-codebase/pgpdecryptstream/) * [Apache Hop Codebase/synchronizeaftermerge](https://translate.project-hop.org/projects/apache-hop-codebase/synchronizeaftermerge/) * [Apache Hop Codebase/perspective](https://translate.project-hop.org/projects/apache-hop-codebase/perspective/) * [Apache Hop Codebase/filelocked](https://translate.project-hop.org/projects/apache-hop-codebase/filelocked/) * [Apache Hop Codebase/deletefile](https://translate.project-hop.org/projects/apache-hop-codebase/deletefile/) * [Apache Hop Codebase/insertupdate](https://translate.project-hop.org/projects/apache-hop-codebase/insertupdate/) * [Apache Hop Codebase/snowflake](https://translate.project-hop.org/projects/apache-hop-codebase/snowflake/) * [Apache Hop
Re: [PR] Update HopGuiKeyHandler.java (hop)
mattcasters merged PR #3352: URL: https://github.com/apache/hop/pull/3352 -- 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
Re: [PR] Update javascript.adoc (hop)
mattcasters merged PR #3350: URL: https://github.com/apache/hop/pull/3350 -- 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
Re: [PR] Update rest.adoc (hop)
mattcasters merged PR #3346: URL: https://github.com/apache/hop/pull/3346 -- 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
Re: [PR] Update filterrows.adoc (hop)
mattcasters merged PR #3345: URL: https://github.com/apache/hop/pull/3345 -- 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
Re: [PR] Update simple-mapping.adoc (hop)
mattcasters merged PR #3344: URL: https://github.com/apache/hop/pull/3344 -- 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
Re: [PR] Update jsoninput.adoc (hop)
mattcasters merged PR #3343: URL: https://github.com/apache/hop/pull/3343 -- 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
Re: [PR] Update getvariable.adoc (hop)
mattcasters merged PR #3342: URL: https://github.com/apache/hop/pull/3342 -- 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
Re: [PR] Update loops-in-apache-hop.adoc (hop)
mattcasters merged PR #3341: URL: https://github.com/apache/hop/pull/3341 -- 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
Re: [PR] Update replacestring.adoc (hop)
mattcasters merged PR #3340: URL: https://github.com/apache/hop/pull/3340 -- 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
Re: [PR] Update filterrows.adoc (hop)
mattcasters merged PR #3351: URL: https://github.com/apache/hop/pull/3351 -- 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
Re: [PR] Translations update from Weblate (hop)
hansva merged PR #3353: URL: https://github.com/apache/hop/pull/3353 -- 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
[PR] Translations update from Weblate (hop)
hop-weblate opened a new pull request, #3353: URL: https://github.com/apache/hop/pull/3353 Translations update from [Weblate](https://translate.project-hop.org) for [Apache Hop Codebase/Hop](https://translate.project-hop.org/projects/apache-hop-codebase/hop/). It also includes following components: * [Apache Hop Codebase/workflow 2](https://translate.project-hop.org/projects/apache-hop-codebase/workflow-2/) * [Apache Hop Codebase/foo](https://translate.project-hop.org/projects/apache-hop-codebase/foo/) * [Apache Hop Codebase/valuemapper](https://translate.project-hop.org/projects/apache-hop-codebase/valuemapper/) * [Apache Hop Codebase/blockuntiltransformsfinish](https://translate.project-hop.org/projects/apache-hop-codebase/blockuntiltransformsfinish/) * [Apache Hop Codebase/metadata 4](https://translate.project-hop.org/projects/apache-hop-codebase/metadata-4/) * [Apache Hop Codebase/mysqlbulkload](https://translate.project-hop.org/projects/apache-hop-codebase/mysqlbulkload/) * [Apache Hop Codebase/execcql](https://translate.project-hop.org/projects/apache-hop-codebase/execcql/) * [Apache Hop Codebase/meta](https://translate.project-hop.org/projects/apache-hop-codebase/meta/) * [Apache Hop Codebase/gui 4](https://translate.project-hop.org/projects/apache-hop-codebase/gui-4/) * [Apache Hop Codebase/mailvalidator](https://translate.project-hop.org/projects/apache-hop-codebase/mailvalidator/) * [Apache Hop Codebase/mail](https://translate.project-hop.org/projects/apache-hop-codebase/mail/) * [Apache Hop Codebase/cypherscript](https://translate.project-hop.org/projects/apache-hop-codebase/cypherscript/) * [Apache Hop Codebase/gui 3](https://translate.project-hop.org/projects/apache-hop-codebase/gui-3/) * [Apache Hop Codebase/ftp](https://translate.project-hop.org/projects/apache-hop-codebase/ftp/) * [Apache Hop Codebase/http](https://translate.project-hop.org/projects/apache-hop-codebase/http/) * [Apache Hop Codebase/stringoperations](https://translate.project-hop.org/projects/apache-hop-codebase/stringoperations/) * [Apache Hop Codebase/rest](https://translate.project-hop.org/projects/apache-hop-codebase/rest/) * [Apache Hop Codebase/shell](https://translate.project-hop.org/projects/apache-hop-codebase/shell/) * [Apache Hop Codebase/webservices](https://translate.project-hop.org/projects/apache-hop-codebase/webservices/) * [Apache Hop Codebase/googleanalytics](https://translate.project-hop.org/projects/apache-hop-codebase/googleanalytics/) * [Apache Hop Codebase/kafka](https://translate.project-hop.org/projects/apache-hop-codebase/kafka/) * [Apache Hop Codebase/plugins 1](https://translate.project-hop.org/projects/apache-hop-codebase/plugins-1/) * [Apache Hop Codebase/tableinput](https://translate.project-hop.org/projects/apache-hop-codebase/tableinput/) * [Apache Hop Codebase/mongodbinput](https://translate.project-hop.org/projects/apache-hop-codebase/mongodbinput/) * [Apache Hop Codebase/googlesheets](https://translate.project-hop.org/projects/apache-hop-codebase/googlesheets/) * [Apache Hop Codebase/cassandraoutput](https://translate.project-hop.org/projects/apache-hop-codebase/cassandraoutput/) * [Apache Hop Codebase/uniquerowsbyhashset](https://translate.project-hop.org/projects/apache-hop-codebase/uniquerowsbyhashset/) * [Apache Hop Codebase/producer](https://translate.project-hop.org/projects/apache-hop-codebase/producer/) * [Apache Hop Codebase/delay 1](https://translate.project-hop.org/projects/apache-hop-codebase/delay-1/) * [Apache Hop Codebase/joinrows](https://translate.project-hop.org/projects/apache-hop-codebase/joinrows/) * [Apache Hop Codebase/model](https://translate.project-hop.org/projects/apache-hop-codebase/model/) * [Apache Hop Codebase/delete](https://translate.project-hop.org/projects/apache-hop-codebase/delete/) * [Apache Hop Codebase/detectemptystream](https://translate.project-hop.org/projects/apache-hop-codebase/detectemptystream/) * [Apache Hop Codebase/flattener](https://translate.project-hop.org/projects/apache-hop-codebase/flattener/) * [Apache Hop Codebase/pgpdecryptstream](https://translate.project-hop.org/projects/apache-hop-codebase/pgpdecryptstream/) * [Apache Hop Codebase/perspective](https://translate.project-hop.org/projects/apache-hop-codebase/perspective/) * [Apache Hop Codebase/filelocked](https://translate.project-hop.org/projects/apache-hop-codebase/filelocked/) * [Apache Hop Codebase/synchronizeaftermerge](https://translate.project-hop.org/projects/apache-hop-codebase/synchronizeaftermerge/) * [Apache Hop Codebase/deletefile](https://translate.project-hop.org/projects/apache-hop-codebase/deletefile/) * [Apache Hop
[PR] Update HopGuiKeyHandler.java (hop)
vutiendung opened a new pull request, #3352: URL: https://github.com/apache/hop/pull/3352 Fix issue #2801 crash the web when enter any keys **Please** add a meaningful description for your change here Thank you for your contribution! Follow this checklist to help us incorporate your contribution quickly and easily: - [x] Run `mvn clean install apache-rat:check` to make sure basic checks pass. A more thorough check will be performed on your pull request automatically. - [x] If you have a group of commits related to the same change, please squash your commits into one and force push your branch using `git rebase -i`. - [x] Mention the appropriate issue in your description (for example: `addresses #123`), if applicable. To make clear that you license your contribution under the [Apache License Version 2.0, January 2004](http://www.apache.org/licenses/LICENSE-2.0) you have to acknowledge this by using the following check-box. - [x] I hereby declare this contribution to be licensed under the [Apache License Version 2.0, January 2004](http://www.apache.org/licenses/LICENSE-2.0) - [x] In any other case, please file an [Apache Individual Contributor License Agreement](https://www.apache.org/licenses/icla.pdf). -- 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