Job is running for long time in case of exceptions.

[abhishek gupta]

Hi,

We were running following query on Hivesterix on a 3 machine cluster  .

insert overwrite table q18_tmp
select
  l_orderkey, sum(l_quantity) as t_sum_quantity
from
  lineitem
group by l_orderkey

Logs shows some exception ( HyracksDataException: Unable to allocate frame: Not enough memory),  but in case of exceptions ideally Hyracks should stop the job and show the exceptions on terminal. But job keep running on for a long time. Even job trace on rest-api was not changing for a long time and did not show any progess. It seems job is stuck and not able to make any progress.  We are not able to figure out the exact problem.

I ran query two times. I have attached the job trace present at the rest-api in files Rest_api_log_run1 and Rest_api_log_run2. I  have also attached the log which are generated on different machine in file shadowfax and warehouse.

(For information infolab-desktop, warehouse and shadowfax are machine names)



Thanks and Regards
Abhishek Gupta