[ 
https://issues.apache.org/jira/browse/HIVE-967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13455087#comment-13455087
 ] 

Kevin Wilfong commented on HIVE-967:
------------------------------------

I don't know what you mean by "frozen at the time the view is created".  A view 
is just an alias for a subquery, and in both cases the query text is stored in 
the metastore, and hence frozen.
                
> Implement "show create table"
> -----------------------------
>
>                 Key: HIVE-967
>                 URL: https://issues.apache.org/jira/browse/HIVE-967
>             Project: Hive
>          Issue Type: New Feature
>          Components: Metastore, Query Processor
>            Reporter: Adam Kramer
>            Assignee: Feng Lu
>         Attachments: HIVE-967.2.patch.txt, HIVE-967.3.patch.txt, 
> HIVE-967.4.patch.txt, HIVE-967.5.patch.txt, HIVE-967.patch.txt, 
> HiveShowCreateTable.jar, show_create.txt
>
>
> SHOW CREATE TABLE would be very useful in cases where you are trying to 
> figure out the partitioning and/or bucketing scheme for a table. Perhaps this 
> could be implemented by having new tables automatically SET PROPERTIES 
> (create_command='raw text of the create statement')?

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Reply via email to