【踩坑实录】- ERROR: Row of size 966.66 KB could not be materialized by Hash Join Builder (join_node_id=6)

目录

一、背景

二、解决方法

MAX_ROW_SIZE

一、背景

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;