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--scanner_ttl_ms flag to a much higher value (the default is 60s), though this will come at the potential cost of Kudu memory if any clients are orphaning their scanners.
在CDH上修改kudu的参数scanner_ttl_ms=120000
重启后，执行一次，完成。。表10亿条记录，执行40分钟。