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