Is it possible, to create external table on a existing hive table which is partitioned.
I have a existing hive table which is partitioned by dt and group like below desc page_access; page string country string dt string ( Partitioned column ) group string ( Partitioned column ) dfs -tail file /user/hive/warehouse/page_access/dt=2012-06-01/group=a/000003_0 PXXXXX1 {"UY": 2, "BR": 1} PXXXXX2 {"LV": 1, "BR": 1} Is it possible to define a external table something like.. create external table page_access_m ( page string country map(<string>,<int>) )PARTITIONED BY(dt STRING, group STRING) location /user/hive/warehouse/page_access; currently I'm using hive.0.6 Thanks Sai