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