You need to use order by in sql, e.g. select * from sink_kafka order by event_ts desc limit 10;
> Also, when I show tables (SHOW TABLES;), the command show me previously executed SQL queries too. Is this a bug? Do you mean when you call 'show tables', it would execute preview sql query ? Craftman Tel <craftman...@gmail.com> 于2020年4月10日周五 下午9:42写道： > Hi > > I am using Zeppelin with Flink to show events from Kafka. I want to order > the lines by descending ID to always show new events first. However, when > the table refresh, my table lose the setting and show always the oldest > events. > > How can I achieve this? > > Also, when I show tables (SHOW TABLES;), the command show me previously > executed SQL queries too. Is this a bug? > > Thanks > -- Best Regards Jeff Zhang
