您当前的位置: 首页 > 

宝哥大数据

暂无认证

  • 0浏览

    0关注

    1029博文

    0收益

  • 0浏览

    0点赞

    0打赏

    0留言

私信
关注
热门博文

Kudu问题解决

宝哥大数据 发布时间:2021-01-13 10:19:55 ,浏览量:0

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·

分区的字段必须在第一个字段

关注
打赏
1587549273
查看更多评论
立即登录/注册

微信扫码登录

0.0569s