hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Naveen Gangam (JIRA)" <>
Subject [jira] [Commented] (HIVE-14558) Add support for listing views similar to "show tables"
Date Fri, 09 Sep 2016 20:23:20 GMT


Naveen Gangam commented on HIVE-14558:

Based on some quick searches, appears most databases have some form of support for getting
a list of views. I think it makes sense to support a "show views" command in hive, with a
syntax similar to "show tables".  I am uploading a patch that will support commands like
show views; // list all views in the current database
show views 'test_*'; // list all views that start with "test_"
show views '*view'; // list all views that end in "view"
show views in <DB>; // list all views in database <DB>
show views from <DB>; // same as IN
show views in/from <DB> [LIKE] 'test_*'; // show views in database <DB> that start
with "test_"

The syntax for this command is derived from SHOW TABLES command.

General syntax is 

> Add support for listing views similar to "show tables"
> ------------------------------------------------------
>                 Key: HIVE-14558
>                 URL:
>             Project: Hive
>          Issue Type: Bug
>          Components: Hive
>    Affects Versions: 2.0.0
>            Reporter: Naveen Gangam
>            Assignee: Naveen Gangam
> Users have been asking for such feature where they can get a lists of views separately.
> So perhaps a syntax similar to "show tables" command?
> show views [in/from <dbName>] [<pattern>]
> Does it make sense to add such command? or is it not worth the effort?

This message was sent by Atlassian JIRA

View raw message