Uploaded image for project: 'Engineering'
  1. Engineering
  2. ENG-732

Optimize multi-partition "select count(*) from <table>;"

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: V1.1
    • Fix Version/s: V1.3.1
    • Component/s: Core

      Description

      It would be great if we pushed down the count to each partition and aggregated the aggregates, even if there is a where clause.

      From the forums:
      A simple count of the key_value table in the key_value example is giving the error:
      Output from SQL stmt overflowed output/network buffer of 10mb. Try a "limit" clause or a stronger predicate.
      This is through a stored procedure.
      I know it is multi-partitioned query and performance will be impacted but surprised to see it hitting the buffer limits. Any work arounds to get to count of huge tables ?
      Thanks.

        Attachments

          Activity

            People

            • Assignee:
              nshi Ning Shi
              Reporter:
              tcallaghan Tim Callaghan
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Zendesk Support