The code does produce a folder for each table but the 'categories' folder has only two files:
[cloudera@quickstart ~]$ hadoop fs -ls /user/hive/warehouse/categories/
Found 2 items
-rw-r--r-- 1 cloudera hive 0 2016-01-10 12:36 /user/hive/warehouse/categories/_SUCCESS
-rw-r--r-- 1 cloudera hive 1344 2016-01-10 12:36 /user/hive/warehouse/categories/part-m-00000.avro
I do not have the result of the codes which ran before this. I would appreciate it if someone help me what I am doing wrong and how to fix this.