Ajith S created SPARK-30517:
-------------------------------
Summary: 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
{{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
