[ https://issues.apache.org/jira/browse/FLINK-16452?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17052723#comment-17052723 ]
Jingsong Lee commented on FLINK-16452: -------------------------------------- Thanks for reporting. Also not support values.... They are similar problem, can be fixed together. > 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 > Affects Versions: 1.10.0 > 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)