You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hop.apache.org by "usbrandon (via GitHub)" <gi...@apache.org> on 2024/03/20 17:12:10 UTC

[I] [Bug]: DuckDB - jdbc:duckdb: (in memory database) - No tables or schema found. (hop)

usbrandon opened a new issue, #3743:
URL: https://github.com/apache/hop/issues/3743

   ### 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


-- 
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

Re: [I] [Bug]: DuckDB - jdbc:duckdb: (in memory database) - No tables or schema found. (hop)

Posted by "hansva (via GitHub)" <gi...@apache.org>.
hansva closed issue #3743: [Bug]: DuckDB - jdbc:duckdb: (in memory database) - No tables or schema found.
URL: https://github.com/apache/hop/issues/3743


-- 
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

Re: [I] [Bug]: DuckDB - jdbc:duckdb: (in memory database) - No tables or schema found. (hop)

Posted by "hansva (via GitHub)" <gi...@apache.org>.
hansva commented on issue #3743:
URL: https://github.com/apache/hop/issues/3743#issuecomment-5370537205

   .take-issue


-- 
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