This is my through the spark - SQL load of data from a mysql table, the last field is composed of string concatenation with a '+',

This is kafka, data were collected by data ":" separated, I need Txxx and Bxxx the two fields, and they have the data back to the corresponding values,
Excuse me each eldest brother elder sister how should I put the kafka Txxx segmentation of data, Bxxx corresponds to each data value, by matching into sparksql formula,
The final combined results ah,, genuflect is begged to, big red envelopes, QQ1183982890