[ 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