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

behaviours for non-aggregated queries

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

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

      Description

      Even though kylin is not designed for non-aggregated queries, people do frequently use queries like

      select * from fact limit 
      

      to verify their cubes. Recently many new users reported problems when running such queries, we'll use this JIRA as an umbrella to track all related issues.

      for such queries on fact table:

      • select * from fact : should return results from base cuboid (thus not raw fact table data) and MIGHT crash query server or region server
      • select * from fact limit x : should return results from base cuboid (thus not raw fact table data) and SHOULD NOT crash query server or region server. Current there's a known issue KYLIN-1787 fails to push down the limit value
      • select a,b from fact: should return results from base cuboid (thus not raw fact table data) and MIGHT crash query server or region server (when a or b contains is a measure, the query only works when you defined a sum() measure )
      • select a,b from fact limit x: should return results from base cuboid (thus not raw fact table data) and SHOULD NOT crash query server or region server (when a or b contains is a measure, the query only works when you defined a sum() measure)

      such four kinds of queries on look up tables should return correct results from the lookup table snapshot directly, and even without the limit clause, they have a low possibility to crash query server or region server because lookup table tends to be small. However, it's still better to make sure limit is taking effect.

        Attachments

        Issue Links

          Activity

            People

            • Assignee:
              wormholer Wang Cheng
              Reporter:
              mahongbin Hongbin Ma

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment