[ https://issues.apache.org/jira/browse/SPARK-30517?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17015706#comment-17015706 ]
Ajith S edited comment on SPARK-30517 at 1/15/20 8:01 AM: ---------------------------------------------------------- [~srowen] [~dongjoon] [~vanzin] Please let me know your opinions about proposal. I would like to work if its acceptable was (Author: ajithshetty): [~srowen] [~dongjoon] [~vanzin] Please let me know about your opinion about proposal. I would like to work if its acceptable > Support SHOW TABLES EXTENDED > ---------------------------- > > Key: SPARK-30517 > URL: https://issues.apache.org/jira/browse/SPARK-30517 > Project: Spark > Issue Type: New Feature > Components: SQL > Affects Versions: 3.0.0 > Reporter: Ajith S > Priority: Major > > {{Intention is to support show tables with a additional column 'type' where > type can be MANAGED,EXTERNAL,VIEW using which user can query only tables of > required types, like listing only views or only external tables (using a > 'where' clause over 'type' column).}} > {{Usecase example:}} > {{Currently its not possible to list all the VIEWS, but other technologies > like hive support it using 'SHOW VIEWS', mysql supports it using a more > complex query 'SHOW FULL TABLES WHERE table_type = 'VIEW';'}} > Decide to take mysql approach as it provides more flexibility for querying. -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org