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

Bad query leads to full gc

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • v3.1.0
    • Query Engine
    • None
    • Sprint 52

    Description

      The following sql goes into dead loop of RuleQueue.popMatch() in VolcanoPlanner.findBestExp() leading to OOM

      select LSTG_FORMAT_NAME,
       cast(sum(t.sid_cnt) as bigint) as sid_cnts
      from
       (select LSTG_FORMAT_NAME,
       count(distinct SELLER_ID) as sid_cnt
       from TEST_KYLIN_FACT
       group by LSTG_FORMAT_NAME) t
      group by LSTG_FORMAT_NAME
      order by sid_cnts
      
      

      Attachments

        Activity

          People

            yaho Zhong Yanghong
            yaho Zhong Yanghong
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: