Hi, We have a SPJ that perform some insert/select operations against a big table, and each time then the SPJ runs for 1 hour, the CALL statement will return -8007 error code, said it is cancelled. What can be possible reasons for a query to be cancelled?
>>CALL QUERY1SPJ(); *** ERROR[8007] The operation has been canceled. *** ERROR[8811] Trying to close a statement that is either not in the open state or has not reached EOF. --- SQL operation failed with errors. I have a dev environment, and simulate a long running SPJ (Not same as the SPJ in real cluster as above), but I am not able to reproduce it. The test SPJ runs 1 hour 50 mins and finish correctly. So this seems not a common SPJ issue, but I am not sure. Any suggestions to debug this issue will be very appreciated. Thanks, Ming
