[
https://issues.apache.org/jira/browse/HIVE-14558?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15557378#comment-15557378
]
Lefty Leverenz commented on HIVE-14558:
---------------------------------------
Well done, [~ngangam]! You get a gold star for updating the list of commands
in the introduction, as well as the reserved words and the "Show
Tables/Views/Partitions/Indexes" section title. (I added an anchor for the old
title, so incoming links will still work.) No other docs need to be updated --
I checked the Tutorial but it doesn't discuss views. In the DDL doc I added a
link to "Show Views" from the "Create View" section.
One question about syntax: Can LIKE be included without a pattern or does the
syntax have too many brackets?
{code}
[LIKE] ['pattern_with_wildcards'] or [LIKE 'pattern_with_wildcards']
{code}
Here are the doc links:
* [DDL -- Overview |
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Overview]
* [Keywords, Non-reserved Keywords and Reserved Keywords |
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Keywords,Non-reservedKeywordsandReservedKeywords]
* [Show Tables/Views/Partitions/Indexes |
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-ShowTables/Views/Partitions/Indexes]
-- formerly [Show Tables/Partitions/Indexes |
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-ShowTables/Partitions/Indexes]
** [Show Views |
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-ShowViews]
* [Create View _(added link to "Show View" near end of section)_ |
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-CreateView]
> Add support for listing views similar to "show tables"
> ------------------------------------------------------
>
> Key: HIVE-14558
> URL: https://issues.apache.org/jira/browse/HIVE-14558
> Project: Hive
> Issue Type: New Feature
> Components: Hive
> Affects Versions: 2.0.0
> Reporter: Naveen Gangam
> Assignee: Naveen Gangam
> Fix For: 2.2.0
>
> Attachments: HIVE-14558.1.patch, HIVE-14558.2.patch,
> HIVE-14558.4.patch, HIVE-14558.4.patch
>
>
> 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
(v6.3.4#6332)
