[
https://issues.apache.org/jira/browse/FLINK-35935?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17872219#comment-17872219
]
xuyang commented on FLINK-35935:
--------------------------------
This bug is caused by `CREATE OR REPLACE TABLE`. Could you like to assign this
to me? I'll fix it these days.
> CREATE TABLE AS doesn't work with LIMIT
> ---------------------------------------
>
> Key: FLINK-35935
> URL: https://issues.apache.org/jira/browse/FLINK-35935
> Project: Flink
> Issue Type: Bug
> Components: Table SQL / Planner
> Affects Versions: 1.18.1
> Reporter: Xingcan Cui
> Priority: Major
>
> {code:java}
> CREATE TABLE WITH (foo) AS (SELECT * FROM bar LIMIT 5){code}
> The above statement throws "Caused by: java.lang.AssertionError: not a query:
> " exception.
> A workaround is to wrap the query with CTE.
> {code:java}
> CREATE TABLE WITH (foo) AS (WITH R AS (SELECT * FROM bar LIMIT 5) SELECT *
> FROM R){code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
