7.KSQL
3.7.1 Overview
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:
As shown in the following figure:
Access to topic message data, depending on the underlying interface record of the earliest and latest offset, the default display up to 5000 records.
3.7.2 Parse JSONObject Or JSONArrays
Kafka topic datasets like this:
Then you can use sql query topic like this:
When Kafka topic datasets like this:
Then you can use sql query topic like this:
Using and
syntax in SQL
3.7.3 Filter Query [where ... and]
Kafka topic datasets like this:
Then you can use sql query topic like this:
Using like
syntax in SQL
Or
Last updated