[
https://issues.apache.org/jira/browse/FLINK-35935?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17871856#comment-17871856
]
Xingcan Cui commented on FLINK-35935:
-------------------------------------
hi [~xuyangzhong] , it looks like this doesn't for the filesystem connector.
For instance
{code:java}
CREATEOR REPLACE TABLE `default_catalog`.`default_database`.`test` WITH (
'connector' = 'filesystem', 'path' = 'path', 'sink.parallelism' = '1',
'format' = 'json') AS ( SELECT * FROM table WHERE dt = '2024-08-05' LIMIT 10)
{code}
> 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)
