Details
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
- Total Dimension count - 50
- Total Metrics count - 7
- Cuboid Count - 128
- Lookup table - 10
- Total Aggregation -10
- joint dimension – 3