zeppelin-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeff Zhang <zjf...@gmail.com>
Subject Re: Rearrange columns after Refresh with Flink
Date Fri, 10 Apr 2020 14:05:32 GMT
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 <craftmantel@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 <zjffdu@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 <craftmantel@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

Mime
View raw message