Hive
  1. Hive
  2. HIVE-1079

CREATE VIEW followup: derive dependencies on underlying base table partitions from view definition

    Details

    • Type: Improvement Improvement
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: 0.6.0
    • Fix Version/s: None
    • Component/s: Query Processor
    • Labels:
      None

      Description

      When querying a view, it would be useful to know which underlying base table partitions it depends on in order to know how fresh the result is (or to be able to wait until all of those partitions have been loaded consistently). The task is to come up with a way to perform this analysis automatically (possibly overconservatively), or alternately to let the view creator annotate the view definition with this dependency information, or some combination of the two.

      Note that this would be useful for any complex query which directly accesses base tables (not just view definitions).

        Issue Links

          Activity

          John Sichi made changes -
          Assignee John Sichi [ jvs ] Prajakta Kalmegh [ pkalmegh ]
          John Sichi made changes -
          Link This issue relates to HIVE-1941 [ HIVE-1941 ]
          John Sichi made changes -
          Assignee Carl Steinbach [ cwsteinbach ] John Sichi [ jvs ]
          Carl Steinbach made changes -
          Assignee John Sichi [ jvs ] Carl Steinbach [ cwsteinbach ]
          John Sichi made changes -
          Fix Version/s 0.6.0 [ 12314524 ]
          John Sichi made changes -
          Field Original Value New Value
          Link This issue relates to HIVE-972 [ HIVE-972 ]
          John Sichi created issue -

            People

            • Assignee:
              Prajakta Kalmegh
              Reporter:
              John Sichi
            • Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:

                Development