【已解决】SET GLOBAL exec_mem_limit = 64G 不生效

Viewed 53
2.1

使用streamload导入数据的时候报错：

[CANCELLED]Allocator mem tracker check failed, [MEM_LIMIT_EXCEEDED]failed alloc size 64.00 B, memory tracker limit exceeded, tracker label:Load#Id=1b4b4163c97198da-60424ca4282a481, type:load, limit 2.00 GB, peak used 4.00 GB, current used 4.00 GB. backend test-rainbow-04.xd02.zzjg.dxm-int.com process memory used 10.53 GB. exec node:<>, can set exec_mem_limit=8G to change limit, details see be.INFO.

执行SET GLOBAL exec_mem_limit = 64G后，再执行streamload导入数据，还是报相同的错误，请问大佬们这是什么原因呀

松鼠找不到松果13
1 Answers
  1. 看节点mem是否充裕
  2. 基于stream load -H 设置exec_mem_limit：stream load
张彬华7323