Apache Hop version?
2.8.0-GA
Java version?
11
Operating system
Windows
What happened?
According to DuckDB documentation a connection URL of jdbc:duckdb: will create an in memory database. Also there is another way to specify this using :memory: in place of the filename. - https://duckdb.org/docs/api/java
"DuckDB can operate in in-memory mode. In most clients, this can be activated by passing the special value :memory: as the database file or omitting the database file argument. In in-memory mode, no data is persisted to disk, therefore, all data is lost when the process finishes." - https://duckdb.org/docs/connect/overview
The URL does work in Hop, the problem comes in that the database explorer does not show any tables or schemas and I had no way to know how to try to approach the table.
From other reading, at a minimum if you create a table DuckDB defaults to a 'main' schema. Another schema available is 'memory'.
Issue Priority
Priority: 3
Issue Component
Component: Database
Apache Hop version?
2.8.0-GA
Java version?
11
Operating system
Windows
What happened?
According to DuckDB documentation a connection URL of jdbc:duckdb: will create an in memory database. Also there is another way to specify this using :memory: in place of the filename. - https://duckdb.org/docs/api/java
"DuckDB can operate in in-memory mode. In most clients, this can be activated by passing the special value :memory: as the database file or omitting the database file argument. In in-memory mode, no data is persisted to disk, therefore, all data is lost when the process finishes." - https://duckdb.org/docs/connect/overview
The URL does work in Hop, the problem comes in that the database explorer does not show any tables or schemas and I had no way to know how to try to approach the table.
From other reading, at a minimum if you create a table DuckDB defaults to a 'main' schema. Another schema available is 'memory'.
Issue Priority
Priority: 3
Issue Component
Component: Database