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

Improve SQLAnalyzer by session-based parsing-result caching

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 0.11.0
    • SQL Parser
    • None

    Description

      There are wide tables with many many columns. Moveover, BI tools generate very complex queries whose size is several MB. Although Tajo executes those queries very fast in a few seconds, the total time of UX is slow.
      To become a fastest Hadoop DW, we need this following feature. 

      tsql -f long_2times.sql
...
(0 rows, 30.641 sec, 0 B selected)
...
(0 rows, 1.707 sec, 0 B selected)

      Attachments

        1. wide_table.sql
          175 kB
          Dongjoon Hyun
        2. TAJO-1430.patch
          5 kB
          Dongjoon Hyun
        3. TAJO-1430.Hyun.150413.1.patch.txt
          15 kB
          Dongjoon Hyun
        4. TAJO-1430.Hyun.150413.0.patch.txt
          15 kB
          Dongjoon Hyun
        5. TAJO-1430.Hyun.150407.1.patch.txt
          15 kB
          Dongjoon Hyun
        6. TAJO-1430.Hyun.150407.0.patch.txt
          15 kB
          Dongjoon Hyun
        7. long_2times.sql
          232 kB
          Dongjoon Hyun

        Issue Links

          blocks

          Improvement - An improvement or enhancement to an existing feature or task. TAJO-1435 Improve JDBC PreparedStatement performance

          • Major - Major loss of function.
          • In Progress
          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. TAJO-1512 Fix various Expr cloning bugs

          • Critical - Crashes, loss of data, severe memory leak.
          • Resolved

          Activity

            People

              dongjoon Dongjoon Hyun
              dongjoon Dongjoon Hyun
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: