I am new to MemSql but I can’t figure out the answer to my question from the documentation.
If I missed something documented in existing documentation, a link will be very much appreciated.
Suppose I have a table with colums: id, name, address, phone
Suppose I am configuring a pipeline to ingest JSONs from Kafka
How does the pipeline determines which field to put in which column?
Should the name of the field be the same as the column?
What if a field occurs in JSON that doesn’t match the column? Or vice versa?