[HIVE-431] Auto-add table property "select" to be the select statement that created the table

• Type: Wish
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Assignee: Unassigned
• Reporter: Adam Kramer
• Created: 19/Apr/09 07:21
• Updated: 05/Mar/10 20:42

Description

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.