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

Can kylin accelerate query speed for natural week or natural month report?

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Job Engine, Query Engine
    • Labels:
      None

      Description

      Hi team:

      In bigdata analytics platform, we often query data of the nature week or nature month.
      For example, in Bank or Accounting reports, the query periods are often a natural week or natural month report.
      In kylin system, we can build cube to increase query speed. However, it will query slowly if the amount of data is large and the query cycle is long especlially using count distinct measure.

      For example, We can add month dimension to the cube, then merge cube in normal month peroid; but if the query sql has date partition, it will also match the cube has both week dimension and date dimension, kylin need search data from HBase and aggregate data in memory. It also slowly if the amountof data is large.

      Does anyone face the same problem? Who has a better way to solve the problems of nature week or nature month query?

       

      Best regards

      Thank you.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              zhao jintao zhao jintao
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Due:
                Created:
                Updated: