【详述】复杂查询报错【StarRocks planner use long time 10000 ms in memo phase, This probably because 1. FE Full GC, 2. Hive external table fetch metadata took a long time, 3. The SQL is very complex. You could 1. adjust FE JVM config, 2. try query again, 3. enlarge new_planner-optimize_timeout session variable】
【背景】查询操作
【业务影响】查询时报错
【是否存算分离】否
【StarRocks版本】3.1.5
【集群规模】1fe+3be
【机器信息】每个节点8c 32GB
【联系方式】社区群13-李琳健
【附件】sql.txt (16.9 KB)