Details
-
Bug
-
Status: Resolved
-
Blocker
-
Resolution: Fixed
-
Impala 2.9.0
Description
TestTPCHJoinQueries.test_outer_joins[batch_size: 0 | exec_option: {'disable_codegen': False, 'abort_on_error': 1, 'exec_single_node_rows_threshold': 0, 'batch_size': 0, 'num_nodes': 0} | table_format: parquet/none]
[gw2] linux2 -- Python 2.6.6 /data/jenkins/workspace/impala-umbrella-build-and-test/repos/Impala/bin/../infra/python/env/bin/python
query_test/test_join_queries.py:122: in test_outer_joins
self.run_test_case('tpch-outer-joins', new_vector)
common/impala_test_suite.py:359: in run_test_case
result = self.__execute_query(target_impalad_client, query, user=user)
common/impala_test_suite.py:567: in __execute_query
return impalad_client.execute(query, user=user)
common/impala_connection.py:160: in execute
return self.__beeswax_client.execute(sql_stmt, user=user)
beeswax/impala_beeswax.py:173: in execute
handle = self.__execute_query(query_string.strip(), user=user)
beeswax/impala_beeswax.py:339: in __execute_query
self.wait_for_completion(handle)
beeswax/impala_beeswax.py:359: in wait_for_completion
raise ImpalaBeeswaxException("Query aborted:" + error_log, None)
E ImpalaBeeswaxException: ImpalaBeeswaxException:
E Query aborted:
E Memory limit exceeded
E
E
E
E Memory Limit Exceeded by fragment: 644cda3570148404:3e76dd4d00000002
E Query(644cda3570148404:3e76dd4d00000000): memory limit exceeded. Limit=1.00 GB Total=1.00 GB Peak=1.00 GB
E Fragment 644cda3570148404:3e76dd4d00000000: Total=10.27 KB Peak=339.00 KB
E EXCHANGE_NODE (id=6): Total=0 Peak=0
E DataStreamRecvr: Total=0 Peak=0
E PLAN_ROOT_SINK: Total=0 Peak=0
E CodeGen: Total=2.27 KB Peak=331.00 KB
E Block Manager: Limit=819.20 MB Total=760.00 MB Peak=760.00 MB
E Fragment 644cda3570148404:3e76dd4d00000001: Total=85.19 MB Peak=85.32 MB
E HDFS_SCAN_NODE (id=0): Total=85.01 MB Peak=85.31 MB
E DataStreamSender (dst_id=4): Total=1.16 KB Peak=1.16 KB
E CodeGen: Total=1.22 KB Peak=228.00 KB
E Fragment 644cda3570148404:3e76dd4d00000003: Total=477.88 MB Peak=785.88 MB
E Runtime Filter Bank: Total=2.00 MB Peak=2.00 MB
E SORT_NODE (id=3): Total=4.00 KB Peak=4.00 KB
E HASH_JOIN_NODE (id=2): Total=449.05 MB Peak=761.31 MB
E Exprs: Total=4.00 KB Peak=4.00 KB
E Hash Join Builder (join_node_id=2): Total=449.02 MB Peak=761.02 MB
E Hash Join Builder (join_node_id=2) Exprs: Total=8.00 KB Peak=8.00 KB
E EXCHANGE_NODE (id=4): Total=0 Peak=0
E DataStreamRecvr: Total=21.98 MB Peak=21.98 MB
E EXCHANGE_NODE (id=5): Total=0 Peak=0
E DataStreamRecvr: Total=4.79 MB Peak=22.91 MB
E DataStreamSender (dst_id=6): Total=432.00 B Peak=432.00 B
E CodeGen: Total=41.86 KB Peak=2.86 MB
E Fragment 644cda3570148404:3e76dd4d00000002: Total=141.00 MB Peak=181.91 MB
E HDFS_SCAN_NODE (id=1): Total=140.74 MB Peak=181.66 MB
E DataStreamSender (dst_id=5): Total=4.67 KB Peak=4.67 KB
E CodeGen: Total=653.00 B Peak=116.50 KB
E Memory Limit Exceeded by fragment: 644cda3570148404:3e76dd4d00000003
E Query(644cda3570148404:3e76dd4d00000000): memory limit exceeded. Limit=1.00 GB Total=1.00 GB Peak=1.00 GB
E Fragment 644cda3570148404:3e76dd4d00000000: Total=10.27 KB Peak=339.00 KB
E EXCHANGE_NODE (id=6): Total=0 Peak=0
E DataStreamRecvr: Total=0 Peak=0
E PLAN_ROOT_SINK: Total=0 Peak=0
E CodeGen: Total=2.27 KB Peak=331.00 KB
E Block Manager: Limit=819.20 MB Total=760.00 MB Peak=760.00 MB
E Fragment 644cda3570148404:3e76dd4d00000001: Total=85.19 MB Peak=85.32 MB
E HDFS_SCAN_NODE (id=0): Total=85.01 MB Peak=85.31 MB
E DataStreamSender (dst_id=4): Total=1.16 KB Peak=1.16 KB
E CodeGen: Total=1.22 KB Peak=228.00 KB
E Fragment 644cda3570148404:3e76dd4d00000003: Total=477.88 MB Peak=785.88 MB
E Runtime Filter Bank: Total=2.00 MB Peak=2.00 MB
E SORT_NODE (id=3): Total=4.00 KB Peak=4.00 KB
E HASH_JOIN_NODE (id=2): Total=449.05 MB Peak=761.31 MB
E Exprs: Total=4.00 KB Peak=4.00 KB
E Hash Join Builder (join_node_id=2): Total=449.02 MB Peak=761.02 MB
E Hash Join Builder (join_node_id=2) Exprs: Total=8.00 KB Peak=8.00 KB
E EXCHANGE_NODE (id=4): Total=0 Peak=0
E DataStreamRecvr: Total=21.98 MB Peak=21.98 MB
E EXCHANGE_NODE (id=5): Total=0 Peak=0
E DataStreamRecvr: Total=4.79 MB Peak=22.91 MB
E DataStreamSender (dst_id=6): Total=432.00 B Peak=432.00 B
E CodeGen: Total=41.86 KB Peak=2.86 MB
E Fragment 644cda3570148404:3e76dd4d00000002: Total=141.00 MB Peak=181.91 MB
E HDFS_SCAN_NODE (id=1): Total=140.74 MB Peak=181.66 MB
E DataStreamSender (dst_id=5): Total=4.67 KB Peak=4.67 KB
E CodeGen: Total=653.00 B Peak=116.50 KB
Thomas, assigning to you because it broke on commit