Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-5649

Produce row count statistics from ReflectiveSchema for array based tables

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 1.34.0
    • 1.37.0
    • core

    Description

      When testing new Calcite implementations it is easy to use (and several online examples indeed use) a trivial reflected synthetic schema such as the following:

          public Schema getSchema() {
              return new ReflectiveSchema(new PeopleSchema());
          }
      
          public static final class PeopleSchema {
              public final Person[] heroes = {
                      new Person("Ironman", 12),
                      new Person("Batman", 10)
              };
      
              public static class Person {
                  public final String name;
                  public final int age;
      
                  public Person(final String name, final int age) {
                      this.name = name;
                      this.age = age;
                  }
              }
          }
      

      While this works for some basics, the lack of statistics makes it less useful than it could be. While not all variations supported by ReflectiveSchema can easily capture statistics, the variation which provides the table as an array has trivial access to a valid RowCount value.

      For these simple cases ReflectiveSchema should provide a Statistic object with a valid row count so the simple synthetic schemas will be more useful.

      Attachments

        Activity

          People

            adamkennedy77 Adam Kennedy
            adamkennedy77 Adam Kennedy
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 40m
                40m