[
https://issues.apache.org/jira/browse/HIVE-431?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12740571#action_12740571
]
Namit Jain commented on HIVE-431:
---------------------------------
This can be shown as part of describe extended (only the last partition will be
shown by default)
We can store it in the metastore.
If we are supporting this, it would be useful to have a way to recover the
exact statement used to create the table also.
> Auto-add table property "select" to be the select statement that created the
> table
> ----------------------------------------------------------------------------------
>
> Key: HIVE-431
> URL: https://issues.apache.org/jira/browse/HIVE-431
> Project: Hadoop Hive
> Issue Type: Wish
> Reporter: Adam Kramer
>
> A syntactic copy of the query that was used to fill a table would often be
> AMAZINGLY useful for figuring out where the data in the table came from.
> I think the best way to implement this would be to automatically add a table
> property which includes the SELECT statement. For partitioned tables, this
> would need to exist for each partition...or perhaps use some canonical name
> like selectquery for unpartitioned tables, plus selectquery_ds=<DATEID> for
> partitioned tables.
> This problem is growing as more and more tables in our database are generated
> by either "root" or by people who are no longer easy to contact.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
