Bifrost Document

Version 1.6.x

Bifrost ---- A heterogeneous middleware which can synchronize MySQL binlog data To Redis,MongoDB,ClickHouse...

tag

一. tag

{$SchemaName} : SchemaName

{$TableName} : TableName

{$EventType} : event type; insert,update,delete,sql,commit

{$Timestamp} : now timestamp

{$BinlogTimestamp} : Binlog timestamp

{$BinlogFileNum} : The binlog file number

{$BinlogPosition} : The binlog position

{$fieldName} : the field value

{$fieldName[‘key1’][0][‘key3’]} :

Example:

FieldName : my_json

DataType: json

Data :

{“testK”: [{“Bool”: false, “Null”: null, “Time”: “2020-05-31 23:21:30”, “Int32”: -2147483648, “Int64”: -9223372036854775808, “String”: “ss”, “Uint32”: 4294967295, “Uint64”: 18446744073709551615, “Float64”: 526637.46}]}

{$my_json[‘testK’][0][‘Time’]} => 2020-05-31 23:21:30

Last updated on 8 Sep 2020
Edit on GitHub