Unable to advance iterator for node with id ‘0‘ for Kudu table: Not found

最新推荐文章于 2022-12-22 14:08:11 发布

原创

最新推荐文章于 2022-12-22 14:08:11 发布 · 1.7k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#大数据

本文介绍了解决Impala查询Kudu表时出现的“Scanner not found”错误的方法。通过调整Kudu参数scanner_ttl_ms并重启服务，成功解决了因扫描器超时导致的查询失败问题。

SQL 错误 [500051] [HY000]: [Cloudera][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error Code: 0, SQL state: Unable to advance iterator for node with id '0' for Kudu table 'xxx': Not found: Scanner bbdf18ac57aa450291e259faa62d06b1 not found (it may have expired)

, Query: compute stats xxx.

网上搜索半天，在cdh官网找到一个提示：

官网相关链接

This error indicates that a Kudu tablet server has closed a scanner because it hadn't been accessed in some time. It could manifest on a particularly slow query that very infrequently fetches new data from Kudu.

Can you share the Impala query profile for one of the failed queries, as well as the Impala daemon coordinator log?

You can also work around the issue by reconfiguring Kudu's --scanne