Mailing-List: contact dev-help@nifi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@nifi.apache.org
Date: Mon, 6 Nov 2017 04:21:25 -0700 (MST)
From: gywndi <gywndi@gmail.com>
To: dev@nifi.apache.org
Message-ID: <1509967285809-0.post@n7.nabble.com>
Subject: table_name is null with cdc from mysql
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
archived-at: Mon, 06 Nov 2017 11:51:17 -0000

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/