Re: Flink SQL API: Extra columns added from order by

2019-07-15 Thread Morrisa Brenner
Hi Caizhi and Rong, Thanks for the responses! It's good to know that this is a known bug - right now we're just using Flink 1.8 and will work around this, but we look forward to getting the fixes in the future! All the best, Morrisa On Mon, Jul 15, 2019 at 2:25 AM Caizhi Weng wrote: > (Oops,

Re: Flink SQL API: Extra columns added from order by

2019-07-14 Thread Caizhi Weng
(Oops, I mistakenly sent my response only to Rong Rong. Sorry Rong...) Hi Morrisa, This is due to a bug in the old flink planner. The `createTable(new PlannerQueryOperation(relational.rel))` method in flink-table-planner -> `TableEnvImpl` -> `sqlQuery` should be `createTable(new PlannerQueryOpera

Re: Flink SQL API: Extra columns added from order by

2019-07-12 Thread Rong Rong
Hi Morrisa, Can you share more information regarding what type of function "formatDate" is and how did you configure the return type of that function? For the question on the first query If the return type is String, then ASC on a string value should be on alphabetical ordering. However on the th