The query you see is actually the temporary table name created by zeppelin to display the sql result when you run this query. I think I should filter these table to avoid confusion. Thanks for the feedback.
Craftman Tel <craftman...@gmail.com> 于2020年4月10日周五 下午9:57写道： > 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 >> > -- Best Regards Jeff Zhang
