@markfisher If you have heterogeneous messages the columns that have a corresponding value will get inserted - any other columns will get a null value so in your case you'd get:

name age   occupation 
-------  -----   ---------------
bob     42    null
joe      null   barista