[
https://issues.apache.org/jira/browse/FLINK-16452?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rui Li updated FLINK-16452:
---------------------------
Description:
The following example would fail:
{code}
create table src (x int, y string);
create table dest (x int) partitioned by (p string, q string);
insert into dest partition (p='a') select * from src order by x limit 10;
{code}
The error is: {{"INSERT INTO <table> PARTITION statement only support SELECT
clause for now"}}
> Insert into static partition doesn't support order by or limit
> --------------------------------------------------------------
>
> Key: FLINK-16452
> URL: https://issues.apache.org/jira/browse/FLINK-16452
> Project: Flink
> Issue Type: Bug
> Components: Table SQL / Planner
> Reporter: Rui Li
> Priority: Major
>
> The following example would fail:
> {code}
> create table src (x int, y string);
> create table dest (x int) partitioned by (p string, q string);
> insert into dest partition (p='a') select * from src order by x limit 10;
> {code}
> The error is: {{"INSERT INTO <table> PARTITION statement only support SELECT
> clause for now"}}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
