Full reference is here Run a query $ curl -X POST \ http://localhost:8088/query \ -H 'content-type: application/vnd.ksql.v1+json; charset=utf-8' \ -d '{"ksql":"SELECT * FROM COMPUTER_T;", "streamsProperties": { "ksql.streams.auto.offset.reset": "earliest" }}' {"row":{"columns":[1547723561637,"100",1,"100","e0:a1:d7:18:c2:72"]},"errorMessage":null,"finalMessage":null} {"row":{"columns":[1547723561637,"101",2,"101","e1:a3:d7:18:c2:72"]},"errorMessage":null,"finalMessage":null} {"row":{"columns":[1547723561637,"102",3,"102","e2:a4:d7:18:c2:72"]},"errorMessage":null,"finalMessage":null} Remember, KSQL is a continuous query so this will keep executing; use LIMIT x if you just want the first x rows. Run a statement, use jq to format the output

Continue Reading

The Schema Registry support a REST API for finding out information about the schemas within it. Here’s a quick cheatsheat with REST calls that I often use. List 'subjects' (topics) $ curl -s "http://localhost:8081/subjects/" ["COMP_WATCH_BY_EMP_ID_T-value"]⏎ List schema for given ID $ curl -s "http://localhost:8081/schemas/ids/1" {"schema":"{\"type\":\"record\",\"name\":\"KsqlDataSourceSchema\",\"namespace\":\"io.confluent.ksql.avro_schemas\",\"fields\":[{\"name\":\"EMP_ID\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"EMP_NAME\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"EMP_KEY\",\"type\":[\"null\",\"string\"],\"default\":null},{\"name\":\"MACADDR\",\"type\":[\"null\",\"string\"],\"default\":null}]}"}⏎ List latest schema for given subject $ curl -s "http://localhost:8081/subjects/COMP_WATCH_BY_EMP_ID_T-value/versions/latest"|jq '.' { "subject": "COMP_WATCH_BY_EMP_ID_T-value", "version": 1, "id": 1, "schema": "{\"type\":\"record\",\"name\":\"KsqlDataSourceSchema\",\"namespace\":\"io.

Continue Reading

By default Kafka Connect sends its output to stdout, so you’ll see it on the console, Docker logs, or wherever. Sometimes you might want to route it to file, and you can do this by reconfiguring log4j. To find out the config file location simply inspect the running Kafka Connect process, or the existing stdout, and look for the location of connect-log4j.properties in -Dlog4j.configuration: [2019-01-15 10:34:22,755] INFO WorkerInfo values: jvm.

Continue Reading

I use Docker and Docker Compose a lot. Like, every day. It’s a fantastic way to build repeatable demos and examples, that can be torn down and spun up in a repeatable way. But…what happens when the demo that was working is spun up and then tail spins down in a blaze of flames? Here’s the excerpt of a log from my Oracle container: $ docker-compose up -d ; docker-compose logs -f oracle Recreating connect-jdbc_oracle_1_4be0ad4479f8 .

Continue Reading

I’ve reviewed a bunch of abstracts in the last couple of days, here are some common suggestions I made: No need to include your company name in the abstract text. Chances are I’ve not heard of your company, and even if I have, what does it add to my comprehension of your abstract and what you’re going to talk about? Possible exception would be the "hot" tech companies where people will see a talk just because it’s Netflix etc

Continue Reading

Why? I’ve been blogging for quite a few years now, starting on Blogger, soon onto WordPress, and then to Ghost a couple of years ago. Blogger was fairly lame, WP yucky, but I really do like Ghost. It’s simple and powerful and was perfect for my needs. My needs being, an outlet for technical content that respected formatting, worked with a markup language (Markdown), and didn’t f**k things up in the way that WP often would in its WYSIWYG handling of content.

Continue Reading

Tiny little snippet this one. Given a list of images: $ docker images|grep confluent confluentinc/cp-enterprise-kafka 5.0.0 d0c5528d7f99 3 months ago 600MB confluentinc/cp-kafka 5.0.0 373a4e31e02e 3 months ago 558MB confluentinc/cp-zookeeper 5.0.0 3cab14034c43 3 months ago 558MB confluentinc/cp-ksql-server 5.0.0 691bc3c1991f 4 months ago 493MB confluentinc/cp-ksql-cli 5.0.0 e521f3e787d6 4 months ago 488MB … Now there’s a new version available, and you want to pull down all the latest ones for it:

Continue Reading

A few years ago a colleague of mine told me about this thing called Docker, and I must admit I dismissed it as a fad…how wrong was I. Docker, and Docker Compose, are one of my key tools of the trade. With them I can build self-contained environments for tutorials, demos, conference talks etc. Tear it down, run it again, without worrying that somewhere a local config changed and will break things.

Continue Reading

This is a short summary discussing what the options are for integrating Oracle RDBMS into Kafka, as of December 2018. For a more detailed background to why and how at a broader level for all databases (not just Oracle) see this blog and these slides. What techniques & tools are there? As of December 2018, this is what the line-up looks like: Query-based CDC The JDBC Connector for Kafka Connect, polls the database for new or changed data based on an incrementing ID column and/or update timestamp Log-based CDC

Continue Reading

I’ve written recently about how I create the diagrams in my blog posts and talks, and from discussions around that, a couple of people were interested more broadly in how I use my iPad Pro. So, on the basis that if two people are interested maybe others are (and if no-one else is, I have a copy-and-paste answer to give to those two people) here we go. ### Kit

Continue Reading

I write and speak lots about Kafka, and get a fair few questions from this. The most common question is actually nothing to do with Kafka, but instead: How do you make those cool diagrams? So here’s a short, and longer, answer! ### tl;dr An iOS app called Paper, from a company called FiftyThree So, how DO you make those cool diagrams? Disclaimer: This is a style that I have copied straight from my esteemed colleagues at Confluent, including Neha Narkhede and Ben Stopford, as well as others including Martin Kleppmann.

Continue Reading

Install Not sure why the brew doesn’t work as it used to, but here’s how to get it working: brew install mtr sudo ln /usr/local/Cellar/mtr/0.92/sbin/mtr /usr/local/bin/mtr sudo ln /usr/local/Cellar/mtr/0.92/sbin/mtr-packet /usr/local/bin/mtr-packet (If you don’t do the two symbolic links (ln) you’ll get mtr: command not found or mtr: Failure to start mtr-packet: Invalid argument) Run sudo mtr google.com

Continue Reading

I do lots of work with Kafka Connect, almost entirely in Distributed mode—even just with 1 node -> makes scaling out much easier when/if needed. Because I’m using Distributed mode, I use the Kafka Connect REST API to configure and manage it. Whilst others might use GUI REST tools like Postman etc, I tend to just use the commandline. Here are some useful snippets that I use all the time.

Continue Reading

tl;dr: docker exec --interactive \ --tty \ --user root \ --workdir / \ oracle-container-name bash Using Oracle’s Docker database image I wanted to install some additional apps, without modifying the Dockerfile. Connect to the container: $ docker exec --interactive --tty docker-compose_oracle_1_479e7fa05ab5 bash No sudo: [oracle@a37d6e99353b ~]$ sudo whoami bash: sudo: command not found Googled, found the the --user flag for Docker, tried that: $ docker exec --interactive --tty --user root docker-compose_oracle_1_479e7fa05ab5 bash OCI runtime exec failed: exec failed: container_linux.

Continue Reading

Doing some funky Docker Compose stuff, including: … kafkacat: image: confluentinc/cp-kafkacat:latest depends_on: - kafka command: - bash - -c - | echo "Waiting for Kafka ⏳" cub kafka-ready -b kafka:29092 1 300 && while [ 1 -eq 1 ] do awk '{print $0;system("sleep 0.5");}' /data/data.json | \ kafkacat -b kafka:29092 -P -t purchases done volumes: - $PWD:/data … Run it: $ docker-compose up -d Oh noes! Error! ERROR: Invalid interpolation format for "command" option in service "kafkacat": "echo 'Waiting for Kafka'

Continue Reading

The problem - nested messages in Kafka Data comes into Kafka in many shapes and sizes. Sometimes it’s from CDC tools, and may be nested like this: { "SCN": 12206116841348, "SEG_OWNER": "KFKUSER", "TABLE_NAME": "CDCTAB2", "TIMESTAMP": 1539162785000, "SQL_REDO": "insert into \"KFKUSER\".\"CDCTAB2\"(\"ID\",\"CITY\",\"NATIONALITY\") values (634789,'AHMEDABAD','INDIA')", "OPERATION": "INSERT", "data": { "value": { "ID": 634789, "CITY": { "string": "AHMEDABAD" }, "NATIONALITY": { "string": "INDIA" } } }, "before": null } Note that the ‘payload’ is nested under data->value.

Continue Reading

Using the Elasticsearch Kafka Connect connector to stream events from a Kafka topic to Elasticsearch. curl -X "POST" "http://kafka-connect:8083/connectors/" \ -H "Content-Type: application/json" \ -d '{ "name": "es_sink_ATM_POSSIBLE_FRAUD", "config": { "topics": "ATM_POSSIBLE_FRAUD", "key.converter": "org.apache.kafka.connect.storage.StringConverter", "value.converter": "org.apache.kafka.connect.json.JsonConverter", "value.converter.schemas.enable": false, "connector.class": "io.confluent.connect.elasticsearch.ElasticsearchSinkConnector", "key.ignore": "true", "schema.ignore": "true", "type.name": "type.name=kafkaconnect", "topic.index.map": "ATM_POSSIBLE_FRAUD:atm_possible_fraud", "connection.url": "http://elasticsearch:9200" } }' Dynamic mapping setup in Elasticsearch (before running the Connector) to force columns to a given type: curl -XPUT "http://elasticsearch:9200/_template/kafkaconnect/" -H 'Content-Type: application/json' -d' { "index_patterns": "*", "settings": { "number_of_shards": 1, "number_of_replicas": 0 }, "mappings": { "_default_": { "dynamic_templates": [ { "dates": { "match": "*TIMESTAMP", "mapping": { "type": "date" } } }, { "geopoint": { "match": "*LOCATION", "mapping": { "type": "geo_point" } } }, { "geopoint2": { "match": "location", "mapping": { "type": "geo_point" } } }, { "non_analysed_string_template": { "match": "account_id, atm, transaction_id", "match_mapping_type": "string", "mapping": { "type": "keyword" } } } ] } } }' Sample JSON message from Kafka: (pretty-printed)

Continue Reading

Check out the jmxterm repository / Download jmxterm from http://wiki.cyclopsgroup.org/jmxterm/ Launch: java -jar ~/Downloads/jmxterm-1.0.0-uber.jar --url localhost:30002 You can pass the jmx host/port directly, or use the open command once jmxterm launches. Once connected, use domains to list available domains $>domains #following domains are available JMImplementation com.sun.management io.confluent.ksql.metrics io.confluent.rest java.lang java.nio java.util.logging kafka.admin.client kafka.consumer kafka.producer kafka.streams [...] Switch to a particular domain: $>domain io.confluent.ksql.metrics #domain is set to io.confluent.ksql.metrics List the available MBeans in a the selected domain (you can also run this without choosing a domain first, to see every MBean, but it’s a long list):

Continue Reading

To help future Googlers… with the Confluent docker images for Kafka, KSQL, Kafka Connect, etc, if you want to access JMX metrics from within, you just need to pass two environment variables: KSQL_JMX_HOSTNAME - the hostname/IP of the host machine. This is used by the JMX client to connect back into JMX, so must be accessible from the host machine running the JMX client. If you’re just running your JMX client locally on the Docker host, you can set this to 127.

Continue Reading

(SO answer repost) You can use kafkacat to send messages to Kafka that include line breaks. To do this, use its -D operator to specify a custom message delimiter (in this example /): kafkacat -b kafka:29092 \ -t test_topic_01 \ -D/ \ -P <<EOF this is a string message with a line break/this is another message with two line breaks! EOF Note that the delimiter must be a single byte - multi-byte chars will end up getting included in the resulting message See issue #140

Continue Reading