OK, I don't mind listing views are tables in `SHOW TABLES`.

However, if there is no way to distinguish a view from a table, we can also 
remove the `SHOW VIEW xxx` command. Why should somebody try to look up the 
definition of a view if he's not aware that it is a view. He can only know that 
if he created the view himself and in that case probably know the definition.

I also think the syntax of `SHOW VIEW xxx` is not well chosen because it is 
inconsistent with `SHOW TABLES` and `SHOW FUNCTIONS`. It gives *details about a 
single view* where as the other `SHOW` commands *list all elements of a type*.  
I think the semantics are more similar to the `DESCRIBE` command. We could 
rename `SHOW VIEW` to ``DESCRIBE VIEW`.

[ Full content available at: https://github.com/apache/flink/pull/6606 ]
This message was relayed via gitbox.apache.org for [email protected]

Reply via email to