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

Reply via email to