Uploaded image for project: 'Kylin'
  1. Kylin
  2. KYLIN-1936

Improve enable limit logic (exactAggregation is too strict)

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: v1.5.3
    • Fix Version/s: v1.5.4
    • Component/s: None
    • Labels:
      None

      Description

      from zhaotianshuo@meizu.com:

      recently I got the following error while execute query on a cube which is not that big( about 400mb, 20milion record)
      ==================
      Error while executing SQL "select FCRASHTIME,count(1) from UXIP.EDL_FDT_OUC_UPLOAD_FILES group by FCRASH_ANALYSIS_ID,FCRASHTIME limit 1": Scan row count exceeded threshold: 10000000, please add filter condition to narrow down backend scan range, like where clause.

      I guess what it scan were the intermediate result, but It doesn't any order by,also the result count is limit to just 1.so it could scan to find any record with those two dimension and wala.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                mahongbin Hongbin Ma
                Reporter:
                mahongbin Hongbin Ma
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: