Uploaded image for project: 'EXASOL Roadmap'
  1. EXASOL Roadmap
  2. EXASOL-2809

Virtual Schemas: Added Pushdown of COUNT of Tuple

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Normal
    • Resolution: Fixed
    • Fix Version/s: Exasol 7.1.0, Exasol 7.0.4
    • Component/s: None
    • Labels:
      None

      Description

      Description

      Virtual Schemas are able to push certain aspects of a query into the source system, which can result in improved performance for the virtual schema query.
      The pushdown of COUNT(*) and COUNT(exp) was already supported.

      Improvement

      Virtual schemas now support the pushdown of COUNT of a tuple, e.g. COUNT((exp1, exp2)), into the source system. The virtual schema API has been extended to support this.

      To take advantage of this improvement, you must

      • update the database to the fix version and
      • update the virtual schema adapter.

        Attachments

          Activity

            People

            • Assignee:
              CaptainEXA Captain EXASOL
              Reporter:
              CaptainEXA Captain EXASOL
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: