UpdateTable Logical Operator¶
UpdateTable
is a Command that represents UPDATE SQL statement.
UpdateTable
is a SupportsSubquery.
Creating Instance¶
UpdateTable
takes the following to be created:
- Table (LogicalPlan)
-
Assignment
s - Condition Expression (optional)
UpdateTable
is created when:
AstBuilder
is requested to parse UPDATE SQL statement
Execution Planning¶
UpdateTable
command is not supported in Spark SQL and BasicOperators execution planning strategy throws an UnsupportedOperationException
when finds any:
UPDATE TABLE is not supported temporarily.
Note
UpdateTable
is to allow custom data sources to support UPDATE
SQL statement (and so does Delta Lake).