regex101: trino kill query

Non-Capturing Group(?:call|CALL)

1st Alternativecall

callthe literal text call (case sensitive)

2nd AlternativeCALL

CALLthe literal text CALL (case sensitive)

Character Class[\ *]

\ the literal (32₁₀ / 40₈ / 20₁₆)

*the literal * (42₁₀ / 52₈ / 2A₁₆)

Non-Capturing Group(?:(?:system|"system").(?:runtime|"runtime").(?:kill_query|"kill_query"))

Non-Capturing Group(?:system|"system")

1st Alternativesystem

systemthe literal text system (case sensitive)

2nd Alternative"system"

"system"the literal text "system" (case sensitive)

.any character (except for line terminators)

Non-Capturing Group(?:runtime|"runtime")

1st Alternativeruntime

runtimethe literal text runtime (case sensitive)

2nd Alternative"runtime"

"runtime"the literal text "runtime" (case sensitive)

.any character (except for line terminators)

Non-Capturing Group(?:kill_query|"kill_query")

1st Alternativekill_query

kill_querythe literal text kill_query (case sensitive)

2nd Alternative"kill_query"

"kill_query"the literal text "kill_query" (case sensitive)

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

Search reference

Regular Expression

(?:call|CALL)[\ *](?:(?:system|"system").(?:runtime|"runtime").(?:kill_query|"kill_query"))

Test String
New

CALL system.runtime.kill_query(query_id => '20211003_215635_15007_n3mb3', message => 'Looker query cancel.')

CALL "system"."runtime"."kill_query"(query_id => '20211003_215635_15007_n3mb3', message => 'Looker query cancel.')



CALL "system".runtime."kill_query"(query_id => '20211003_215635_15007_n3mb3', message => 'Looker query cancel.')


CALL "system"."runtime"."kill_query"('20211003_215635_15007_n3mb3', 'afsd')



CALL "system"."runtime"."kill_query"(message => '20211003_215635_15007_n3mb3', query_id => 'afsd')

CALL+"system"."runtime"."kill_query"(message => '20211003_215635_15007_n3mb3', query_id => 'afsd')

Regular Expressions 101

Regular Expression

Test String
New

Extraction
Processing...

Regular Expression

Test StringNew

ExtractionProcessing...

Test String
New

Extraction
Processing...