[BUG] Create auto refresh materialized view statement ending with semicolon does not create streaming job on EMR-S

[seankao-az]

What is the bug?
When CREATE MATERIALIZED VIEW statement ends with a semicolon, no streaming job is created on EMR-S. Instead, an interactive session handles the request.

How can one reproduce the bug?
Steps to reproduce the behavior:
1.

POST /_plugins/_async_query
{
    "datasource": "my_glue",
    "lang": "sql",
    "query": "CREATE MATERIALIZED VIEW my_glue.default.mv AS SELECT 1 FROM my_glue.default.dummy WITH ( auto_refresh = true, checkpoint_location = 's3://test', watermark_delay = '1 Minute');"
}

2. See response

{
  "queryId": "xxx",
  "sessionId": "xxx"
}

3. Check EMR-S jobs: no streaming job is created
4. Check materialized view content: will not get auto refreshed

What is the expected behavior?
Response should not contain a sessionId. EMR-S should spawn streaming job. Materialized view content should get auto refreshed.

What is your host/environment?

• OS: 2.13