Uploaded image for project: 'Tajo (Retired)'
  1. Tajo (Retired)
  2. TAJO-2007

By default, Optimizer should use the table volume in TableStat.

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 0.12.0, 0.11.1
    • Planner/Optimizer
    • None

    Description

      Currently, the optimizer by default gets table volumes through storage manager and employ them for join optimization. But, in some cases, it causes performance degradation because aggregating all file volumes is not cheap in large partitioned tables on S3 or HDFS.

      So, this patch improves TableStatUpdateRewriter to use table volumes of TableStat by default, and it also adds a session variable 'USE_TABLE_VOLUME' to allow the optimizer to use the table volume through storage handler.

      Attachments

        Issue Links

          depends upon

          Improvement - An improvement or enhancement to an existing feature or task. TAJO-2005 Add TableStatUpdateRewriter

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

          Activity

            People

              hyunsik Hyunsik Choi
              hyunsik Hyunsik Choi
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: