Re: Rearrange columns after Refresh with Flink

2020-04-10 Thread Jeff Zhang
Each interpreter has its configuration file under ZEPPELIN_HOME/interpreter/${interpreter_name}/interpreter-setting.json, the setting in this file is the configuration what you see in zeppelin interpreter setting page. Regarding hive catalog, as long as your zeppelin server can connect to hive meta

Re: Rearrange columns after Refresh with Flink

2020-04-10 Thread Craftman Tel
Ok thanks. Last question, which env.yaml file is the interpreter using? in my Flink cluster I am using a Hive catalog that don't show up in Zeppelin. Can I configure this? Thanks for the great help Le ven. 10 avr. 2020 à 16:05, Jeff Zhang a écrit : > The query you see is actually the temporary

Re: Rearrange columns after Refresh with Flink

2020-04-10 Thread Jeff Zhang
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 于2020年4月10日周五 下午9:57写道: > Thanks for the tip on order by. I was hoping the

Re: Rearrange columns after Refresh with Flink

2020-04-10 Thread Craftman Tel
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,

Re: Rearrange columns after Refresh with Flink

2020-04-10 Thread Jeff Zhang
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 ? Craftm

Rearrange columns after Refresh with Flink

2020-04-10 Thread Craftman Tel
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;),