nifi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From gywndi <gyw...@gmail.com>
Subject table_name is null with cdc from mysql
Date Mon, 06 Nov 2017 11:21:25 GMT
Hi~ 

I set with mysql 5.7.16(percona) and testing..
(In fact, minimal format is not suitable with NiFi, so I changed to binlog
image to "FULL")

But I updated 1 rows.. there's no database and table_name (also table_id),
when I read "Provenance Event
". (Only updated data is seen..) 

Is this common? I want to make a new script to send to another system. But,
I can't see the table_name.. 
Reply me please.
(Do you have any good reference?)

Thanks.
============================

{ "type" : "update",
  "timestamp" : 1509739175000,
  "binlog_filename" : "mysql-binary.000001",
  "binlog_position" : 5645,
  "database" : NULL,
  "table_name" : NULL,
  "table_id" : NULL,
  "columns" : [ 
  { "id" : 1, "last_value" : 2603098, "value" : 2603098 }, 
  { "id" : 2, "last_value" : "22b847352243de264f3542d059c5f94a", "value" :
"d32edc9ec1db8c286941cd8bd7162ae2" } 
]}



--
Sent from: http://apache-nifi-developer-list.39713.n7.nabble.com/

Mime
View raw message