# Copyright Materialize, Inc. and contributors. All rights reserved. # # Use of this software is governed by the Business Source License # included in the LICENSE file at the root of this repository. # # As of the Change Date specified in that file, in accordance with # the Business Source License, use of this software will be governed # by the Apache License, Version 2.0. $ set-arg-default single-replica-cluster=quickstart $ set schema={ "type": "record", "name": "row", "fields": [ { "name": "quote", "type": "string" }, { "name": "val", "type": "long" } ] } $ kafka-create-topic topic=foobar > CREATE CONNECTION kafka_conn TO KAFKA (BROKER '${testdrive.kafka-addr}', SECURITY PROTOCOL PLAINTEXT); > CREATE SOURCE foobar IN CLUSTER ${arg.single-replica-cluster} FROM KAFKA CONNECTION kafka_conn (TOPIC 'testdrive-foobar-${testdrive.seed}') FORMAT AVRO USING SCHEMA '${schema}' $ kafka-ingest format=avro topic=foobar schema=${schema} timestamp=42 {"quote": "I have a theory that it's impossible to prove anything, but I can't prove it.", "val": 2079} {"quote": "It was a virgin forest, a place where the Hand of Man had never set foot.", "val": 12345} {"quote": "If it pours before seven, it has rained by eleven.", "val": 12345} {"quote": "All power corrupts, but we need electricity.", "val": 12345} {"quote": "I want to read my new poem about pork brains and outer space ...", "val": 6745} {"quote": "You are magnetic in your bearing.", "val": 24223} {"quote": "Yes, but every time I try to see things your way, I get a headache.", "val": 21243} {"quote": "Ring around the collar.", "val": 1735} {"quote": "New York is real. The rest is done with mirrors.", "val": 25040} > SELECT val, quote FROM foobar ORDER BY quote LIMIT 5 val quote -------------------------------------------------------------------------------------- 12345 "All power corrupts, but we need electricity." 2079 "I have a theory that it's impossible to prove anything, but I can't prove it." 6745 "I want to read my new poem about pork brains and outer space ..." 12345 "If it pours before seven, it has rained by eleven." 12345 "It was a virgin forest, a place where the Hand of Man had never set foot." > SELECT val, quote FROM foobar ORDER BY quote ASC LIMIT 5 val quote -------------------------------------------------------------------------------------- 12345 "All power corrupts, but we need electricity." 2079 "I have a theory that it's impossible to prove anything, but I can't prove it." 6745 "I want to read my new poem about pork brains and outer space ..." 12345 "If it pours before seven, it has rained by eleven." 12345 "It was a virgin forest, a place where the Hand of Man had never set foot." > SELECT * FROM foobar ORDER BY quote DESC LIMIT 5 quote val ---------------------------------------------------------------------------------- "You are magnetic in your bearing." 24223 "Yes, but every time I try to see things your way, I get a headache." 21243 "Ring around the collar." 1735 "New York is real. The rest is done with mirrors." 25040 "It was a virgin forest, a place where the Hand of Man had never set foot." 12345 # Test that the second-column sort works fine > SELECT * FROM foobar ORDER BY val, quote LIMIT 6 quote val --------- "Ring around the collar." 1735 "I have a theory that it's impossible to prove anything, but I can't prove it." 2079 "I want to read my new poem about pork brains and outer space ..." 6745 "All power corrupts, but we need electricity." 12345 "If it pours before seven, it has rained by eleven." 12345 "It was a virgin forest, a place where the Hand of Man had never set foot." 12345 > SELECT * FROM foobar ORDER BY val, quote DESC LIMIT 6 quote val --------------------------------------------------------------------------------------- "Ring around the collar." 1735 "I have a theory that it's impossible to prove anything, but I can't prove it." 2079 "I want to read my new poem about pork brains and outer space ..." 6745 "It was a virgin forest, a place where the Hand of Man had never set foot." 12345 "If it pours before seven, it has rained by eleven." 12345 "All power corrupts, but we need electricity." 12345 > SELECT val, quote FROM foobar ORDER BY quote OFFSET 5 ROWS val quote ---------------------------------------------------------------------------- 25040 "New York is real. The rest is done with mirrors." 1735 "Ring around the collar." 21243 "Yes, but every time I try to see things your way, I get a headache." 24223 "You are magnetic in your bearing." > SELECT val, quote FROM foobar ORDER BY quote LIMIT 4 OFFSET 0 ROWS val quote -------------------------------------------------------------------------------------- 12345 "All power corrupts, but we need electricity." 2079 "I have a theory that it's impossible to prove anything, but I can't prove it." 6745 "I want to read my new poem about pork brains and outer space ..." 12345 "If it pours before seven, it has rained by eleven." > SELECT val, quote FROM foobar ORDER BY val, quote LIMIT 3 OFFSET 2 ROWS val quote -------------------------------------------------------------------------------------- 6745 "I want to read my new poem about pork brains and outer space ..." 12345 "All power corrupts, but we need electricity." 12345 "If it pours before seven, it has rained by eleven." > SELECT val, quote FROM foobar ORDER BY quote DESC LIMIT 5 OFFSET 6 ROWS val quote -------------------------------------------------------------------------------------- 6745 "I want to read my new poem about pork brains and outer space ..." 2079 "I have a theory that it's impossible to prove anything, but I can't prove it." 12345 "All power corrupts, but we need electricity." > SELECT val, quote FROM foobar ORDER BY quote DESC LIMIT 4 OFFSET 10 ROWS val quote -------------------------------------------------------------------------------------- > SELECT val, quote FROM foobar ORDER BY quote DESC OFFSET 10 ROWS val quote -------------------------------------------------------------------------------------- > SELECT val, quote FROM foobar ORDER BY quote DESC OFFSET 0 ROWS val quote -------------------------------------------------------------------------------------- 24223 "You are magnetic in your bearing." 21243 "Yes, but every time I try to see things your way, I get a headache." 1735 "Ring around the collar." 25040 "New York is real. The rest is done with mirrors." 12345 "It was a virgin forest, a place where the Hand of Man had never set foot." 12345 "If it pours before seven, it has rained by eleven." 6745 "I want to read my new poem about pork brains and outer space ..." 2079 "I have a theory that it's impossible to prove anything, but I can't prove it." 12345 "All power corrupts, but we need electricity."