Use the SQL statement to the news data visualization in topic, for SQL queries, and table names field need to use double quotes to mark, example SQL is as follows:
select * from ke_test_topic where `partition` in (0,1,2) limit 100
As shown in the following figure:
Note
Access to topic message data, depending on the underlying interface record of the earliest and latest offset, the default display up to 5000 records.
Kafka topic datasets like this:
[{"id":123,"name":"smartloli"},{"id":456,"name":"smartloli2"},{"id":789,"name":"smartloli3"}]
Then you can use sql query topic like this:
select JSONS(msg,'name') from topic_name where `partition` in (0) limit 10
When Kafka topic datasets like this:
{"id":123,"name":"smartloli001"}
Then you can use sql query topic like this:
select JSON(msg,'name') from topic_name where `partition` in (0) limit 10
Using and
syntax in SQL
select JSON(msg,'name') from topic_name where `partition` in (0) and JSON(msg,'name') = 'smartloli001' limit 10
Kafka topic datasets like this:
kafka-eagle-01
kafka-eagle-02
kafka-eagle-02
kafka-eagle-03
kafka-eagle-03
...
kafka-eagle-03
kafka-eagle-04
Then you can use sql query topic like this:
select * from topic_name where `partition` in (0) and msg = 'kafka-eagle-03' limit 10
Using like
syntax in SQL
select * from topic_name where `partition` in (0) and msg like 'kafka-eagle%' limit 10
Or
select * from topic_name where `partition` in (0) and msg like '%kafka-eagle%' limit 10