[jira] [Created] (HIVE-26194) Unable to interrupt query in the middle of long compilation

["Rajesh Balamohan (Jira)" <ji...@apache.org>]

Rajesh Balamohan created HIVE-26194:
---------------------------------------

             Summary: Unable to interrupt query in the middle of long compilation
                 Key: HIVE-26194
                 URL: https://issues.apache.org/jira/browse/HIVE-26194
             Project: Hive
          Issue Type: Bug
          Components: HiveServer2
            Reporter: Rajesh Balamohan



*Issue:*
 * Certain queries can take lot longer time to compile, depending on the number of interactions with HMS.
 * When user tries to cancel such queries in the middle of compilation, it doesn't work. It interrupts the process only when the entire compilation phase is complete.
 * Example is given below (Q66 at 10 TB TPCDS)

 
{noformat}

. . . . . . . . . . . . . . . . . . . . . . .>        ,d_year
. . . . . . . . . . . . . . . . . . . . . . .>      )
. . . . . . . . . . . . . . . . . . . . . . .>  ) x
. . . . . . . . . . . . . . . . . . . . . . .>  group by
. . . . . . . . . . . . . . . . . . . . . . .>         w_warehouse_name
. . . . . . . . . . . . . . . . . . . . . . .>    ,w_warehouse_sq_ft
. . . . . . . . . . . . . . . . . . . . . . .>    ,w_city
. . . . . . . . . . . . . . . . . . . . . . .>    ,w_county
. . . . . . . . . . . . . . . . . . . . . . .>    ,w_state
. . . . . . . . . . . . . . . . . . . . . . .>    ,w_country
. . . . . . . . . . . . . . . . . . . . . . .>    ,ship_carriers
. . . . . . . . . . . . . . . . . . . . . . .>        ,year
. . . . . . . . . . . . . . . . . . . . . . .>  order by w_warehouse_name
. . . . . . . . . . . . . . . . . . . . . . .>  limit 100;
Interrupting... Please be patient this may take some time.
Interrupting... Please be patient this may take some time.
Interrupting... Please be patient this may take some time.
Interrupting... Please be patient this may take some time.
Interrupting... Please be patient this may take some time.
Interrupting... Please be patient this may take some time.

...
...
...

,w_city
,w_county
,w_state
,w_country
,ship_carriers
,year
order by w_warehouse_name
limit 100
INFO  : Semantic Analysis Completed (retrial = false)
ERROR : FAILED: command has been interrupted: after analyzing query.
INFO  : Compiling command(queryId=hive_20220502040541_14c76b6f-f6d2-4ab3-ad82-522f17ede63a) has been interrupted after 32.872 seconds <<<<<<<<<<<---------------- Notice that it interrupted only after entire compilation is done at 32 seconds.
Error: Query was cancelled. Illegal Operation state transition from CANCELED to ERROR (state=01000,code=0)

 {noformat}

This becomes an issue in busy cluster.

Interrupt handling should be fixed in compilation phase.



--
This message was sent by Atlassian Jira
(v8.20.7#820007)