目录
一、背景
impala shell 执行insert overwrite的sql报错
ERROR: Row of size 966.66 KB could not be materialized by Hash Join Builder (join_node_id=6). Increase the max_row_size query option (currently 512.00 KB) to process larger rows.
二、解决方法
增大MAX_ROW_SIZE
官网讲解:
https://impala.apache.org/docs/build/html/topics/impala_max_row_size.html
MAX_ROW_SIZE
Default:默认值
524288
(512 KB)
set MAX_ROW_SIZE=1048576;