[jira] [Commented] (FLINK-10229) Support listing of views
[ https://issues.apache.org/jira/browse/FLINK-10229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16634093#comment-16634093 ] ASF GitHub Bot commented on FLINK-10229: twalthr commented on issue #6631: [FLINK-10229] [sql-client] Support listing of views URL: https://github.com/apache/flink/pull/6631#issuecomment-425927276 @yanghua Sorry, for the delay. I will take a look at it soon. I want to think about our general design for views before. This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org > Support listing of views > > > Key: FLINK-10229 > URL: https://issues.apache.org/jira/browse/FLINK-10229 > Project: Flink > Issue Type: New Feature > Components: SQL Client >Reporter: Timo Walther >Assignee: vinoyang >Priority: Major > Labels: pull-request-available > > FLINK-10163 added initial support of views for the SQL Client. According to > other database vendors, views are listed in the \{{SHOW TABLES}}. However, > there should be a way of listing only the views. We can support the \{{SHOW > VIEWS}} command. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (FLINK-10229) Support listing of views
[ https://issues.apache.org/jira/browse/FLINK-10229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16628470#comment-16628470 ] ASF GitHub Bot commented on FLINK-10229: yanghua commented on issue #6631: [FLINK-10229] [sql-client] Support listing of views URL: https://github.com/apache/flink/pull/6631#issuecomment-424648671 hi @twalthr , hequn has reviewed this PR, can you make a deterministic review? This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org > Support listing of views > > > Key: FLINK-10229 > URL: https://issues.apache.org/jira/browse/FLINK-10229 > Project: Flink > Issue Type: New Feature > Components: SQL Client >Reporter: Timo Walther >Assignee: vinoyang >Priority: Major > Labels: pull-request-available > > FLINK-10163 added initial support of views for the SQL Client. According to > other database vendors, views are listed in the \{{SHOW TABLES}}. However, > there should be a way of listing only the views. We can support the \{{SHOW > VIEWS}} command. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (FLINK-10229) Support listing of views
[ https://issues.apache.org/jira/browse/FLINK-10229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16617444#comment-16617444 ] ASF GitHub Bot commented on FLINK-10229: yanghua commented on issue #6631: [FLINK-10229] [sql-client] Support listing of views URL: https://github.com/apache/flink/pull/6631#issuecomment-421996450 hi @fhueske can you review this PR? Thanks. This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org > Support listing of views > > > Key: FLINK-10229 > URL: https://issues.apache.org/jira/browse/FLINK-10229 > Project: Flink > Issue Type: New Feature > Components: SQL Client >Reporter: Timo Walther >Assignee: vinoyang >Priority: Major > Labels: pull-request-available > > FLINK-10163 added initial support of views for the SQL Client. According to > other database vendors, views are listed in the \{{SHOW TABLES}}. However, > there should be a way of listing only the views. We can support the \{{SHOW > VIEWS}} command. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (FLINK-10229) Support listing of views
[ https://issues.apache.org/jira/browse/FLINK-10229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16610797#comment-16610797 ] ASF GitHub Bot commented on FLINK-10229: yanghua commented on issue #6631: [FLINK-10229] [sql-client] Support listing of views URL: https://github.com/apache/flink/pull/6631#issuecomment-420315730 hi @twalthr , hequn helped me to review this PR, does it look good to you? This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org > Support listing of views > > > Key: FLINK-10229 > URL: https://issues.apache.org/jira/browse/FLINK-10229 > Project: Flink > Issue Type: New Feature > Components: SQL Client >Reporter: Timo Walther >Assignee: vinoyang >Priority: Major > Labels: pull-request-available > > FLINK-10163 added initial support of views for the SQL Client. According to > other database vendors, views are listed in the \{{SHOW TABLES}}. However, > there should be a way of listing only the views. We can support the \{{SHOW > VIEWS}} command. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (FLINK-10229) Support listing of views
[ https://issues.apache.org/jira/browse/FLINK-10229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16609134#comment-16609134 ] ASF GitHub Bot commented on FLINK-10229: hequn8128 commented on issue #6631: [FLINK-10229] [sql-client] Support listing of views URL: https://github.com/apache/flink/pull/6631#issuecomment-419901914 Hi @yanghua , thanks for your update. The PR looks good. +1 to merge from my side. Best, Hequn This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org > Support listing of views > > > Key: FLINK-10229 > URL: https://issues.apache.org/jira/browse/FLINK-10229 > Project: Flink > Issue Type: New Feature > Components: SQL Client >Reporter: Timo Walther >Assignee: vinoyang >Priority: Major > Labels: pull-request-available > > FLINK-10163 added initial support of views for the SQL Client. According to > other database vendors, views are listed in the \{{SHOW TABLES}}. However, > there should be a way of listing only the views. We can support the \{{SHOW > VIEWS}} command. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (FLINK-10229) Support listing of views
[ https://issues.apache.org/jira/browse/FLINK-10229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16607966#comment-16607966 ] ASF GitHub Bot commented on FLINK-10229: yanghua commented on issue #6631: [FLINK-10229] [sql-client] Support listing of views URL: https://github.com/apache/flink/pull/6631#issuecomment-419625429 @hequn8128 What about this change? This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org > Support listing of views > > > Key: FLINK-10229 > URL: https://issues.apache.org/jira/browse/FLINK-10229 > Project: Flink > Issue Type: New Feature > Components: SQL Client >Reporter: Timo Walther >Assignee: vinoyang >Priority: Major > Labels: pull-request-available > > FLINK-10163 added initial support of views for the SQL Client. According to > other database vendors, views are listed in the \{{SHOW TABLES}}. However, > there should be a way of listing only the views. We can support the \{{SHOW > VIEWS}} command. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (FLINK-10229) Support listing of views
[ https://issues.apache.org/jira/browse/FLINK-10229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16606886#comment-16606886 ] ASF GitHub Bot commented on FLINK-10229: yanghua commented on a change in pull request #6631: [FLINK-10229] [sql-client] Support listing of views URL: https://github.com/apache/flink/pull/6631#discussion_r215899614 ## File path: flink-libraries/flink-table/src/main/scala/org/apache/flink/table/api/TableEnvironment.scala ## @@ -587,6 +587,18 @@ abstract class TableEnvironment(val config: TableConfig) { rootSchema.getTableNames.asScala.toArray } + def listViews(): Array[String] = { Review comment: Do you mean that I use the original implementation directly, just move it to the `Executor`? I used to get from the session, I misunderstood what you mean, I thought it was to refer to the implementation of the `listTable` method. This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org > Support listing of views > > > Key: FLINK-10229 > URL: https://issues.apache.org/jira/browse/FLINK-10229 > Project: Flink > Issue Type: New Feature > Components: SQL Client >Reporter: Timo Walther >Assignee: vinoyang >Priority: Major > Labels: pull-request-available > > FLINK-10163 added initial support of views for the SQL Client. According to > other database vendors, views are listed in the \{{SHOW TABLES}}. However, > there should be a way of listing only the views. We can support the \{{SHOW > VIEWS}} command. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (FLINK-10229) Support listing of views
[ https://issues.apache.org/jira/browse/FLINK-10229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16606852#comment-16606852 ] ASF GitHub Bot commented on FLINK-10229: hequn8128 commented on a change in pull request #6631: [FLINK-10229] [sql-client] Support listing of views URL: https://github.com/apache/flink/pull/6631#discussion_r215889007 ## File path: flink-libraries/flink-table/src/main/scala/org/apache/flink/table/api/TableEnvironment.scala ## @@ -587,6 +587,18 @@ abstract class TableEnvironment(val config: TableConfig) { rootSchema.getTableNames.asScala.toArray } + def listViews(): Array[String] = { Review comment: I think we can't add this function in `TableEnvironment`. Reasons are: - `table.isInstanceOf[RelTable]` is not necessary a View. `RelTable` can be registered through `registerTable()`. - `TableEnvironment` currently doesn't support view. It is only supported in SQL-Client now. As a choice, you can list views directly from the `session` passed to the `listViews()`. Also pay attention to the order. This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org > Support listing of views > > > Key: FLINK-10229 > URL: https://issues.apache.org/jira/browse/FLINK-10229 > Project: Flink > Issue Type: New Feature > Components: SQL Client >Reporter: Timo Walther >Assignee: vinoyang >Priority: Major > Labels: pull-request-available > > FLINK-10163 added initial support of views for the SQL Client. According to > other database vendors, views are listed in the \{{SHOW TABLES}}. However, > there should be a way of listing only the views. We can support the \{{SHOW > VIEWS}} command. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (FLINK-10229) Support listing of views
[ https://issues.apache.org/jira/browse/FLINK-10229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16606853#comment-16606853 ] ASF GitHub Bot commented on FLINK-10229: hequn8128 commented on a change in pull request #6631: [FLINK-10229] [sql-client] Support listing of views URL: https://github.com/apache/flink/pull/6631#discussion_r215889039 ## File path: flink-libraries/flink-sql-client/src/test/java/org/apache/flink/table/client/gateway/local/LocalExecutorITCase.java ## @@ -148,6 +148,20 @@ public void testValidateSession() throws Exception { assertEquals(expectedTables, actualTables); } + @Test + public void testListViews() throws Exception { + final Executor executor = createDefaultExecutor(clusterClient); + final SessionContext session = new SessionContext("test-session", new Environment()); + + final List actualViews = executor.listViews(session); + + final List expectedViews = Arrays.asList( Review comment: Add some other views and test the order. This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org > Support listing of views > > > Key: FLINK-10229 > URL: https://issues.apache.org/jira/browse/FLINK-10229 > Project: Flink > Issue Type: New Feature > Components: SQL Client >Reporter: Timo Walther >Assignee: vinoyang >Priority: Major > Labels: pull-request-available > > FLINK-10163 added initial support of views for the SQL Client. According to > other database vendors, views are listed in the \{{SHOW TABLES}}. However, > there should be a way of listing only the views. We can support the \{{SHOW > VIEWS}} command. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (FLINK-10229) Support listing of views
[ https://issues.apache.org/jira/browse/FLINK-10229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16605928#comment-16605928 ] ASF GitHub Bot commented on FLINK-10229: yanghua commented on issue #6631: [FLINK-10229] [sql-client] Support listing of views URL: https://github.com/apache/flink/pull/6631#issuecomment-419138067 @twalthr Would you like to review this PR? thanks~ This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org > Support listing of views > > > Key: FLINK-10229 > URL: https://issues.apache.org/jira/browse/FLINK-10229 > Project: Flink > Issue Type: New Feature > Components: SQL Client >Reporter: Timo Walther >Assignee: vinoyang >Priority: Major > Labels: pull-request-available > > FLINK-10163 added initial support of views for the SQL Client. According to > other database vendors, views are listed in the \{{SHOW TABLES}}. However, > there should be a way of listing only the views. We can support the \{{SHOW > VIEWS}} command. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (FLINK-10229) Support listing of views
[ https://issues.apache.org/jira/browse/FLINK-10229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16603238#comment-16603238 ] ASF GitHub Bot commented on FLINK-10229: yanghua commented on issue #6631: [FLINK-10229] [sql-client] Support listing of views URL: https://github.com/apache/flink/pull/6631#issuecomment-418423933 @hequn8128 thanks for your suggestion, I have refactored this PR, can you review it again? This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org > Support listing of views > > > Key: FLINK-10229 > URL: https://issues.apache.org/jira/browse/FLINK-10229 > Project: Flink > Issue Type: New Feature > Components: SQL Client >Reporter: Timo Walther >Assignee: vinoyang >Priority: Major > Labels: pull-request-available > > FLINK-10163 added initial support of views for the SQL Client. According to > other database vendors, views are listed in the \{{SHOW TABLES}}. However, > there should be a way of listing only the views. We can support the \{{SHOW > VIEWS}} command. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (FLINK-10229) Support listing of views
[ https://issues.apache.org/jira/browse/FLINK-10229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16601170#comment-16601170 ] ASF GitHub Bot commented on FLINK-10229: hequn8128 commented on a change in pull request #6631: [FLINK-10229] [sql-client] Support listing of views URL: https://github.com/apache/flink/pull/6631#discussion_r214535531 ## File path: flink-libraries/flink-sql-client/src/test/java/org/apache/flink/table/client/gateway/local/LocalExecutorITCase.java ## @@ -148,6 +148,28 @@ public void testValidateSession() throws Exception { assertEquals(expectedTables, actualTables); } + @Test + public void testListViews() throws Exception { + final Executor executor = createDefaultExecutor(clusterClient); + final SessionContext session = new SessionContext("test-session", new Environment()); + + executor.validateSession(session); + + assertEquals(session.getViews().size(), 0); Review comment: Use executor to test list views(similar to `testListTables` and `testListUserDefinedFunctions`). There are 2 views in the default environment. Executor will merge environments. This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org > Support listing of views > > > Key: FLINK-10229 > URL: https://issues.apache.org/jira/browse/FLINK-10229 > Project: Flink > Issue Type: New Feature > Components: SQL Client >Reporter: Timo Walther >Assignee: vinoyang >Priority: Major > Labels: pull-request-available > > FLINK-10163 added initial support of views for the SQL Client. According to > other database vendors, views are listed in the \{{SHOW TABLES}}. However, > there should be a way of listing only the views. We can support the \{{SHOW > VIEWS}} command. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (FLINK-10229) Support listing of views
[ https://issues.apache.org/jira/browse/FLINK-10229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16601167#comment-16601167 ] ASF GitHub Bot commented on FLINK-10229: hequn8128 commented on a change in pull request #6631: [FLINK-10229] [sql-client] Support listing of views URL: https://github.com/apache/flink/pull/6631#discussion_r214535527 ## File path: flink-libraries/flink-sql-client/src/main/java/org/apache/flink/table/client/cli/CliClient.java ## @@ -332,6 +336,17 @@ private void callShowTables() { terminal.flush(); } + private void callShowViews() { + final Set views = context.getViews().keySet(); Review comment: Get views from `Executor` like `listTables` so that to provide listViews for external systems and gateway mode. This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org > Support listing of views > > > Key: FLINK-10229 > URL: https://issues.apache.org/jira/browse/FLINK-10229 > Project: Flink > Issue Type: New Feature > Components: SQL Client >Reporter: Timo Walther >Assignee: vinoyang >Priority: Major > Labels: pull-request-available > > FLINK-10163 added initial support of views for the SQL Client. According to > other database vendors, views are listed in the \{{SHOW TABLES}}. However, > there should be a way of listing only the views. We can support the \{{SHOW > VIEWS}} command. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (FLINK-10229) Support listing of views
[ https://issues.apache.org/jira/browse/FLINK-10229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16601169#comment-16601169 ] ASF GitHub Bot commented on FLINK-10229: hequn8128 commented on a change in pull request #6631: [FLINK-10229] [sql-client] Support listing of views URL: https://github.com/apache/flink/pull/6631#discussion_r214535530 ## File path: flink-libraries/flink-sql-client/src/main/java/org/apache/flink/table/client/cli/CliClient.java ## @@ -332,6 +336,17 @@ private void callShowTables() { terminal.flush(); } + private void callShowViews() { + final Set views = context.getViews().keySet(); + + if (views.isEmpty()) { + terminal.writer().println(CliStrings.messageInfo(CliStrings.MESSAGE_EMPTY).toAnsi()); + } else { + views.forEach((v) -> terminal.writer().println(v)); Review comment: Would it better to sort views in alphabetical order(also for show functions)? Show tables did in this way as table names stored in a TreeSet in table environment. What do you think? @twalthr @yanghua This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org > Support listing of views > > > Key: FLINK-10229 > URL: https://issues.apache.org/jira/browse/FLINK-10229 > Project: Flink > Issue Type: New Feature > Components: SQL Client >Reporter: Timo Walther >Assignee: vinoyang >Priority: Major > Labels: pull-request-available > > FLINK-10163 added initial support of views for the SQL Client. According to > other database vendors, views are listed in the \{{SHOW TABLES}}. However, > there should be a way of listing only the views. We can support the \{{SHOW > VIEWS}} command. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (FLINK-10229) Support listing of views
[ https://issues.apache.org/jira/browse/FLINK-10229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16601168#comment-16601168 ] ASF GitHub Bot commented on FLINK-10229: hequn8128 commented on a change in pull request #6631: [FLINK-10229] [sql-client] Support listing of views URL: https://github.com/apache/flink/pull/6631#discussion_r214535526 ## File path: docs/dev/table/sqlClient.md ## @@ -503,6 +503,12 @@ Views created within a CLI session can also be removed again using the `DROP VIE DROP VIEW MyNewView {% endhighlight %} +Views created within a CLI session can also be shown again using the `SHOW VIEWS` statement: Review comment: Views created in a session environment file can also be listed, so change the description to: Displays all of the views in the current session using the \`SHOW VIEWS\` statement: This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org > Support listing of views > > > Key: FLINK-10229 > URL: https://issues.apache.org/jira/browse/FLINK-10229 > Project: Flink > Issue Type: New Feature > Components: SQL Client >Reporter: Timo Walther >Assignee: vinoyang >Priority: Major > Labels: pull-request-available > > FLINK-10163 added initial support of views for the SQL Client. According to > other database vendors, views are listed in the \{{SHOW TABLES}}. However, > there should be a way of listing only the views. We can support the \{{SHOW > VIEWS}} command. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (FLINK-10229) Support listing of views
[ https://issues.apache.org/jira/browse/FLINK-10229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16598098#comment-16598098 ] ASF GitHub Bot commented on FLINK-10229: hequn8128 commented on issue #6631: [FLINK-10229][SQL CLIENT] Support listing of views URL: https://github.com/apache/flink/pull/6631#issuecomment-417516814 @yanghua Thanks for your PR. I will take a look this weekend. :-) This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org > Support listing of views > > > Key: FLINK-10229 > URL: https://issues.apache.org/jira/browse/FLINK-10229 > Project: Flink > Issue Type: New Feature > Components: SQL Client >Reporter: Timo Walther >Assignee: vinoyang >Priority: Major > Labels: pull-request-available > > FLINK-10163 added initial support of views for the SQL Client. According to > other database vendors, views are listed in the \{{SHOW TABLES}}. However, > there should be a way of listing only the views. We can support the \{{SHOW > VIEWS}} command. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (FLINK-10229) Support listing of views
[ https://issues.apache.org/jira/browse/FLINK-10229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16597546#comment-16597546 ] ASF GitHub Bot commented on FLINK-10229: yanghua commented on issue #6631: [FLINK-10229][SQL CLIENT] Support listing of views URL: https://github.com/apache/flink/pull/6631#issuecomment-417350379 @walterddr and @hequn8128 Can you help me to review this PR? thanks. This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org > Support listing of views > > > Key: FLINK-10229 > URL: https://issues.apache.org/jira/browse/FLINK-10229 > Project: Flink > Issue Type: New Feature > Components: SQL Client >Reporter: Timo Walther >Assignee: vinoyang >Priority: Major > Labels: pull-request-available > > FLINK-10163 added initial support of views for the SQL Client. According to > other database vendors, views are listed in the \{{SHOW TABLES}}. However, > there should be a way of listing only the views. We can support the \{{SHOW > VIEWS}} command. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (FLINK-10229) Support listing of views
[ https://issues.apache.org/jira/browse/FLINK-10229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16596975#comment-16596975 ] ASF GitHub Bot commented on FLINK-10229: yanghua commented on issue #6631: [FLINK-10229][SQL CLIENT] Support listing of views URL: https://github.com/apache/flink/pull/6631#issuecomment-417160966 cc @fhueske and @twalthr This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org > Support listing of views > > > Key: FLINK-10229 > URL: https://issues.apache.org/jira/browse/FLINK-10229 > Project: Flink > Issue Type: New Feature > Components: SQL Client >Reporter: Timo Walther >Assignee: vinoyang >Priority: Major > Labels: pull-request-available > > FLINK-10163 added initial support of views for the SQL Client. According to > other database vendors, views are listed in the \{{SHOW TABLES}}. However, > there should be a way of listing only the views. We can support the \{{SHOW > VIEWS}} command. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (FLINK-10229) Support listing of views
[ https://issues.apache.org/jira/browse/FLINK-10229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16596462#comment-16596462 ] ASF GitHub Bot commented on FLINK-10229: yanghua opened a new pull request #6631: [FLINK-10229][SQL CLIENT] Support listing of views URL: https://github.com/apache/flink/pull/6631 ## What is the purpose of the change *This pull request support listing of views* ## Brief change log - *Support sql `SHOW VIEWS`* ## Verifying this change This change added tests and can be verified as follows: - *SqlCommandParserTest#testCommands to test command parsing* - *LocalExecutorITCase#testListViews* ## Does this pull request potentially affect one of the following parts: - Dependencies (does it add or upgrade a dependency): (yes / **no**) - The public API, i.e., is any changed class annotated with `@Public(Evolving)`: (yes / **no**) - The serializers: (yes / **no** / don't know) - The runtime per-record code paths (performance sensitive): (yes / **no** / don't know) - Anything that affects deployment or recovery: JobManager (and its components), Checkpointing, Yarn/Mesos, ZooKeeper: (yes / **no** / don't know) - The S3 file system connector: (yes / **no** / don't know) ## Documentation - Does this pull request introduce a new feature? (**yes** / no) - If yes, how is the feature documented? (not applicable / **docs** / JavaDocs / not documented) This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org > Support listing of views > > > Key: FLINK-10229 > URL: https://issues.apache.org/jira/browse/FLINK-10229 > Project: Flink > Issue Type: New Feature > Components: SQL Client >Reporter: Timo Walther >Assignee: vinoyang >Priority: Major > Labels: pull-request-available > > FLINK-10163 added initial support of views for the SQL Client. According to > other database vendors, views are listed in the \{{SHOW TABLES}}. However, > there should be a way of listing only the views. We can support the \{{SHOW > VIEWS}} command. -- This message was sent by Atlassian JIRA (v7.6.3#76005)