Thanks for the tip on order by. I was hoping the UI can handle this. I mean when I run SHOW TABLES in a cell I get the following result:
select * from table1 select * from table3 table1 table2 table3 The same command in Flink SQL Client gives table1 table2 table3 Le ven. 10 avr. 2020 à 15:45, Jeff Zhang <zjf...@gmail.com> a écrit : > 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 >
