Chukwa
  1. Chukwa
  2. CHUKWA-336

TableCreator will not create table if the date is more than 1 month in the past.

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Won't Fix
    • Affects Version/s: 0.1.2, 0.2.0, 0.3.0
    • Fix Version/s: 0.5.0
    • Component/s: Data Processors
    • Labels:
      None
    • Environment:

      Redhat EL 5.1, Java 6

      Description

      The current algorithm for pin point data on the time partition works as follow:

      If the selected time resolution is less than 24 hours, use weekly table.
      If the selected time resolution is less than 7 days, use monthly table.
      If the selected time resolution is less than 30 days, use quarterly table.
      If the selected time resolution is less than 91 days, use yearly table.
      If the selected time resolution is less than 365 days, use decade table.
      If the selected time resolution is 2x partition in the past, fall back to lower resolution table (weekly to monthly, monthly to quarterly, etc)

      Base on those rules, let's say if I select 12 hours data for 05-15-2009, and the current date is 06-28-2009, the system will attempt to locate data on quarterly table. Those rules operate fine for charting. For data loading, the rules also applies except the last rule for fall back.

      This has been implemented as two methods in DatabaseConfig, findTableNameForCharts and findTableName. findTableName should should not have the last rule for fall back, but the current code have last rule applied.

        Activity

        Hide
        Eric Yang added a comment -

        We no longer support SQL database partitioning. This is not an issue anymore.

        Show
        Eric Yang added a comment - We no longer support SQL database partitioning. This is not an issue anymore.

          People

          • Assignee:
            Unassigned
            Reporter:
            Eric Yang
          • Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development