Hive
  1. Hive
  2. HIVE-431

Auto-add table property "select" to be the select statement that created the table

    Details

    • Type: Wish Wish
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      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.

        Activity

          People

          • Assignee:
            Unassigned
            Reporter:
            Adam Kramer
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:

              Development