How to convert mysql schema?

Hi,

Let's say I have two tables A and B, A have 3 fields (id, a1, a2), b have 2 fields (id, b).

I want to use odo to import data in A to B as B.id = A.id, B.b = {key1: A.a1, key2: A.a2}, B.b is a json string of A.a1 and A.a2. How to do that?

Thanks for your help!

Start by reviewing odo's existing MySQL import and schema-conversion documentation or entry points; the issue names no files or tests. Determine whether mapping fields from tables A and B into a JSON-valued column is supported, and define completion as documented guidance or an implemented, tested conversion path.

Written by the indexing model from the issue text.