02-after-leave.td 918 B

12345678910111213141516171819202122232425262728293031323334
  1. # Copyright Materialize, Inc. and contributors. All rights reserved.
  2. #
  3. # Use of this software is governed by the Business Source License
  4. # included in the LICENSE file at the root of this repository.
  5. #
  6. # As of the Change Date specified in that file, in accordance with
  7. # the Business Source License, use of this software will be governed
  8. # by the Apache License, Version 2.0.
  9. #
  10. # Ingest some more data and read it back
  11. #
  12. $ set schema={"type": "record", "name": "schema", "fields": [ {"name": "f1", "type": "string" } ] }
  13. $ kafka-ingest format=avro topic=kafka-multi-broker schema=${schema} timestamp=11
  14. {"f1": "03-01" }
  15. $ kafka-ingest format=avro topic=kafka-multi-broker schema=${schema} timestamp=12
  16. {"f1": "03-02" }
  17. $ kafka-ingest format=avro topic=kafka-multi-broker schema=${schema} timestamp=13
  18. {"f1": "03-03" }
  19. > SELECT f1 FROM kafka_multi_broker_tbl
  20. 01-01
  21. 01-02
  22. 01-03
  23. 02-01
  24. 02-02
  25. 02-03
  26. 03-01
  27. 03-02
  28. 03-03