[
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: [email protected]
For additional commands, e-mail: [email protected]
