snuyanzin commented on code in PR #25316:
URL: https://github.com/apache/flink/pull/25316#discussion_r1829790186
##########
flink-table/flink-table-planner/src/main/scala/org/apache/flink/table/planner/calcite/SqlRewriterUtils.scala:
##########
@@ -157,9 +161,14 @@ object SqlRewriterUtils {
operands.get(1).asInstanceOf[SqlNodeList],
operands.get(2),
operands.get(3))
+ case SqlKind.EXPLICIT_TABLE =>
+ val operands = call.getOperandList
+ val expTable = new ExplicitTableSqlSelect(
+ operands.get(0).asInstanceOf[SqlIdentifier],
+ Collections.emptyList())
+ rewriterUtils.rewriteSelect(expTable, targetRowType, assignedFields,
targetPosition)
// Not support:
// case SqlKind.WITH =>
Review Comment:
~~looks like for that first should be supported in Calcite~~
there is support in Oracle's style like
```sql
INSERT INTO ...
WITH cte ...
SELECT ...
```
added support for that
initially I was looking for Postgres style like
```sql
WITH cte ...
INSERT INTO ...
SELECT ...
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
