I have tried creating using Hive query which is taking longer time. So I want to know is there any way to create 1 million tables ( empty table also fine ) quickly?
Why do you want to create 1 million tables?
Please note that the metastore is not on hadoop but it is in mysql. Therefore handling 1millions tables by mysql will be hard.