[KYLIN-4952] kylin - coprocessor timeout after scanning 10 439 900 rows

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: v3.0.1
• Component/s: Query Engine

Environment

Server details
1. OS : Ubuntu 18.04.5 LTS
2. RAM : 32 GB
3. Storage: 1 TB
4. CPU : 4 cpu

Software version details
· kylin-3.0.1
· hadoop-2.7.0
· hbase-1.1.2
· hive-1.2.1

• Assignee: Unassigned
• Reporter: mohamed ismaiel
• Created: 05/Apr/21 06:28
• Updated: 08/Apr/21 06:12

Description

We are using Kylin for OLAP which is integrated to HDFS system running in cloud environment. Kylin is connected to our Java BI Application using JDBC.

Our's is currently a Standalone setup almost like a DEV environment without clusters.

 Coprocessor timeout issue

      Current data size in a fact table is about 150 million per year. 

      Segment: 20190401000000_20200331000000

• Status: READY
• Start Time: 2019-04-01 00:00:00
• End Time: 2020-03-31 00:00:00
• Source Count: 152032244
• HBase Table: KYLIN_X8BBJ2V6Q3
• Region Count: 1
• Size: 4.39844 GB

      while executing the Cube query we are getting coprocessor timeout after scanning 10439900 rows while executing SQL

Cube details

1. Total Dimension count - 50
2. Total Metrics count - 7
3. Cuboid Count - 128
4. Lookup table - 10
5. Total Aggregation -10
6. joint dimension – 3