Here is the code:
as you can see the table is created but for some reason the formatted schema is not shown up but error out.
Thank you in advance if anyone can please help to answer.
issue found and fixed.
I should run this in hive instead of mysql