Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-3501

Track table and keys used in joins and group bys for logging

    XMLWordPrintableJSON

Details

    • Task
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 0.10.0
    • 0.10.0
    • Query Processor
    • None
    • Reviewed

    Description

      For all operators that could benefit from bucketing, it will be useful to keep track of and log the table names and key column names in order for the operator to be converted to the bucketed version. This task is to track this information for joins and group bys when the keys can be directly mapped back to table scans and columns on that table. This information will be tracked on the QueryPlan object so it is available to any pre/post execution hooks for logging.

      Attachments

        1. table_access_keys.1.patch
          41 kB
          Sambavi Muthukrishnan
        2. table_access_keys.2.patch
          42 kB
          Sambavi Muthukrishnan
        3. table_access_keys.3.patch
          42 kB
          Sambavi Muthukrishnan
        4. table_access_keys.4.patch
          43 kB
          Sambavi Muthukrishnan
        5. table_access_keys.5.patch
          43 kB
          Sambavi Muthukrishnan

        Activity

          People

            sambavi Sambavi Muthukrishnan
            sambavi Sambavi Muthukrishnan
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 96h
                96h
                Remaining:
                Remaining Estimate - 96h
                96h
                Logged:
                Time Spent - Not Specified
                Not Specified