You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Gabor Kaszab (Jira)" <ji...@apache.org> on 2021/07/26 10:10:00 UTC
[jira] [Commented] (IMPALA-10816) 'NoneType' object is not iterable
exception when query returns more than 10.000 rows
[ https://issues.apache.org/jira/browse/IMPALA-10816?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17387211#comment-17387211 ]
Gabor Kaszab commented on IMPALA-10816:
---------------------------------------
I also encountered something similar, but for me the error message is different when querying more than 10000 rows. impala-shell crashes in this occasion too, though.
{code:java}
[localhost:21050] default> select * from tpch_parquet.lineitem;
Query: select * from tpch_parquet.lineitem
Query submitted at: 2021-07-26 11:56:30 (Coordinator: http://gaborkaszab-OptiPlex-7040:25000)
Query progress can be monitored at: http://gaborkaszab-OptiPlex-7040:25000/query_plan?query_id=8e4a1ef92d6a559b:4d921d9000000000
Caught exception list size out of the sanity limit (10000 items max), type=<type 'exceptions.OverflowError'> in FetchResults.
Unknown Exception : list size out of the sanity limit (10000 items max)
Traceback (most recent call last):
File "/home/gaborkaszab/shadow/Impala-upstream/shell/impala_shell.py", line 1265, in _execute_stmt
for rows in rows_fetched:
File "/home/gaborkaszab/shadow/Impala-upstream/shell/impala_client.py", line 794, in fetch
resp = self._do_hs2_rpc(FetchResults)
File "/home/gaborkaszab/shadow/Impala-upstream/shell/impala_client.py", line 967, in _do_hs2_rpc
return rpc()
File "/home/gaborkaszab/shadow/Impala-upstream/shell/impala_client.py", line 791, in FetchResults
return self.imp_service.FetchResults(req)
File "/home/gaborkaszab/shadow/Impala-upstream/shell/gen-py/TCLIService/TCLIService.py", line 717, in FetchResults
return self.recv_FetchResults()
File "/home/gaborkaszab/shadow/Impala-upstream/shell/gen-py/TCLIService/TCLIService.py", line 736, in recv_FetchResults
result.read(iprot)
File "/home/gaborkaszab/shadow/Impala-upstream/shell/gen-py/TCLIService/TCLIService.py", line 3638, in read
fastbinary.decode_binary(self, iprot.trans, (self.__class__, self.thrift_spec))
OverflowError: list size out of the sanity limit (10000 items max)
Warning: close session RPC failed: Application Exception : CloseSession failed: unknown result, <class 'shell_exceptions.RPCException'>
[Not connected] >
{code}
> 'NoneType' object is not iterable exception when query returns more than 10.000 rows
> ------------------------------------------------------------------------------------
>
> Key: IMPALA-10816
> URL: https://issues.apache.org/jira/browse/IMPALA-10816
> Project: IMPALA
> Issue Type: Bug
> Affects Versions: Impala 4.0
> Reporter: Alexandra Dunai
> Priority: Critical
>
> Impala-shell returns 'NoneType' object is not iterable exception when query returns more than 10.000 rows.
> Steps to reproduce:
> 1. Enter impala-shell (or you can run query from a file as well)
> 2. Run a query that returns more than 10.000 rows (e.g. 10.001 rows)
> Expected result:
> Impala-shell returns all rows that were queried.
> Actual result:
> Impala-shell throws exception for 'NoneType' object is not iterable and then disconnects. You can only continue using impala-shell if you reconnect to it.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org