Hive/Spark Multiple Insert Clause Parse Failure

[reata]

Search before asking

• I searched the issues and found no similar issues.

What Happened

sqlfluff hive and sparksql dialect failed to parse below sql:

FROM tab1
INSERT INTO TABLE tab2 SELECT * FROM tab1 WHERE flag=2
INSERT INTO TABLE tab3 SELECT * FROM tab1 WHERE flag=3

Hive Language Manual: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML#LanguageManualDML-Syntax.1

SparkSQL doesn't document this feature. However based on its antrl g4 file, it's also supported: https://github.com/apache/spark/blob/v3.5.1/sql/api/src/main/antlr4/org/apache/spark/sql/catalyst/parser/SqlBaseParser.g4#L444

Expected Behaviour

SQL to be successfully parsed.

Observed Behaviour

==== parsing violations ====
L: 1 | P: 1 | PRS | Line 1, Position 1: Found unparsable section: 'FROM tab1\nINSERT
| INTO TABLE tab2 SELECT ...'

How to reproduce

sqlfluff parse --dialect=hive test.sql
sqlfluff parse --dialect=sparksql test.sql

Dialect

hive and sparksql

Version

3.0.6

Configuration

default one

Are you willing to work on and submit a PR to address the issue?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct