1、WARNINGS: Row of size 3.88 MB could not be materialized in plan node with id 2. Increase the max_row_size query option (currently 512.00 KB) to process larger rows.
在impala-shell命令行执行
[s88:21000] > set max_row_size=5m
但是不知道如何在shell脚本中调用impala-shell如何设置???
2、Error in Kudu table 't_mortgages': Invalid argument: value too large for column 'guarantees' (1886885 bytes, maximum is 1310720 bytes)
参考 https://blog.csdn.net/vkingnew/article/details/90405817
-- 原因:
默认的类型为string,string类型默认为UTF-8字符集下最大为64kb,即为65536 bytes。若要扩展可存储的大小
可以设置参数max_cell_size_bytes。
-- 解决办法:
在所有的tserver角色服务器上执行:
kudu tserver set_flag 10.19.102.65 max_cell_size_bytes 131072 -force
3、time_out
WARNINGS: Kudu error(s) reported, first error: Timed out: Failed to write batch of 2768 ops to tablet dcf6b40176db43faa988eb8aa321a09d after 443 attempt(s): Failed to write to server: (no server available): Write(tablet: dcf6b40176db43faa988eb8aa321a09d, num_ops: 2768, num_attempts: 443) passed its deadline: Illegal state: Tablet not RUNNING: INITIALIZED
Error in Kudu table 't_mortgages': Timed out: Failed to write batch of 2768 ops to tablet dcf6b40176db43faa988eb8aa321a09d after 443 attempt(s): Failed to write to server: (no server available): Write(tablet: dcf6b40176db43faa988eb8aa321a09d, num_ops: 2768, num_attempts: 443) passed its deadline: Illegal state: Tablet not RUNNING: INITIALIZED (1 of 2768 similar)
4、kudu总结
5、·KUDU-Got out-of-order key column: name: “ID” type: STRING is_key: true is_nullable: false·
分区的字段必须在第一个字段