[jira] [Created] (FLINK-35935) CREATE TABLE AS doesn't work with LIMIT

[Xingcan Cui (Jira)]

Xingcan Cui created FLINK-35935:
-----------------------------------

             Summary: 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


{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)