Specifies whether to use an INSERT INTO SELECT statement.

Syntax

Connect-SparkSQL -UseInsertSelectSyntax SwitchParameter

Data Type

bool

Default Value

false

Remarks

When set to true, an INSERT INTO SELECT statement will be used when executing insert statements. When set to false, an INSERT INTO VALUES statement will be used.

Unless explicitly specified, this option will be configured accordingly based on the Spark version.