ncclementi commented on issue #12363: URL: https://github.com/apache/datafusion/issues/12363#issuecomment-2346923557
> we could have this documented. in fact tables created in DF are local temporary tables and as long it lives in memory. This, at the moment is not reflected in the information schema table, and that is what in my opinion is causing confusion. I personally like the addition of the PR #12439 because it makes it explicit. > In DUCKDB https://duckdb.org/docs/sql/statements/create_table.html they support both syntaxes, but my feeling it is the same mechanism In duckdb a `CREATE TABLE` table statement results in a table with `type=BASE TABLE` in the information schema and it's located in the current database. If you `CREATE TEMPORARY TABLE` the table shows as `type=LOCAL TEMPORARY` in the information schema, and it will be located in the `temp` system database. Something similar happens with `VIEWS`, happy to go into details if needed. -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
