You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Aljoscha Krettek (Jira)" <ji...@apache.org> on 2019/09/16 09:47:00 UTC
[jira] [Commented] (FLINK-13461) Distinguish between temporary
tables and persisted tables
[ https://issues.apache.org/jira/browse/FLINK-13461?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16930380#comment-16930380 ]
Aljoscha Krettek commented on FLINK-13461:
------------------------------------------
I moved this from "Blocker" to "Major" priority since I don't think a version upgrade or new feature should be a blocker for a release.
> Distinguish between temporary tables and persisted tables
> ---------------------------------------------------------
>
> Key: FLINK-13461
> URL: https://issues.apache.org/jira/browse/FLINK-13461
> Project: Flink
> Issue Type: Improvement
> Components: Table SQL / API
> Reporter: Dawid Wysakowicz
> Assignee: Dawid Wysakowicz
> Priority: Major
> Fix For: 1.10.0
>
>
> Currently, there is no difference between temporary tables that are only available to the current session and tables that need to be persisted in a catalog. FLINK-13279 is an example for this shortcoming. Because we introduce the first real catalog support in Flink 1.9, the difference becomes more important to users.
> A user must be able to express whether a table is just temporary or get an exception if it can not be persisted as desired. Currently, non-persisted tables are silently stored in a separate volatile data structure.
> This issue might touch API, DDL, and SQL Client. We should discuss how we approach this issue for the 1.9 release.
> Some background information for people that would like to join the discussion:
> MySQL:
> https://dev.mysql.com/doc/refman/8.0/en/create-temporary-table.html
> http://www.mysqltutorial.org/mysql-temporary-table/
> Spark:
> https://spark.apache.org/docs/latest/sql-getting-started.html#global-temporary-view
> SQL Server:
> https://docs.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql?view=sql-server-2017
> https://docs.microsoft.com/de-de/sql/relational-databases/databases/tempdb-database?view=sql-server-2017
--
This message was sent by Atlassian Jira
(v8.3.2#803003)