Query Management

query management statements let you monitor and control running queries in an {{ocient}} system for information about system tables containing query data, see docid\ tbjvq0xtd tcxq17hm nc cancel cancels a running query based on its specific query identifier the system cancels query execution at the next available pause point, such as between batches of data processing if the execution of the cancel sql statement fails, you can force the query to terminate immediately by using the docid 5rvt6idm alkrqjsrm1em sql statement to view active queries and their identifiers, see the docid\ tbjvq0xtd tcxq17hm nc table a cancel statement can return these statuses true 202,360 left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left 1 1 unhandled content type left 1 1 unhandled content type left 1 1 unhandled content type left 1 1 unhandled content type left 1 1 unhandled content type left 1 1 unhandled content type required privileges users must have system level update privileges to cancel queries syntax cancel query id true 118,270 88435374149657,272 11564625850343 left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type examples cancel a specific query with the 9a9eb7e3 3440 4814 871f 7f0584ac2fd8 identifier cancel '9a9eb7e3 3440 4814 871f 7f0584ac2fd8'; kill kills a running query identified by its uuid this sql statement performs a forceful termination of the query, aborting execution regardless of its current stage if you want to attempt a more gradual query termination that stops processing at the next pause point, use the docid 5rvt6idm alkrqjsrm1em sql statement to view active queries and their identifiers, see the docid\ tbjvq0xtd tcxq17hm nc table true 202,360 left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left 1 1 unhandled content type left 1 1 unhandled content type left 1 1 unhandled content type left 1 1 unhandled content type left 1 1 unhandled content type left 1 1 unhandled content type required privileges users must have system level update privileges to kill queries syntax kill query id arguments true 220,220,221 left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type example kill a specific query based on the uuid 9a9eb7e3 3440 4814 871f 7f0584ac2fd8 kill '9a9eb7e3 3440 4814 871f 7f0584ac2fd8'; related links docid\ tbjvq0xtd tcxq17hm nc docid\ nw9vavkey2v75moxm muo