Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

What is the best way to add upper partition on existing partitioning hive table?

What is the best way to add upper partition on existing partitioning hive table?

New Contributor

I have partitioning hive table with structure:

(
DeviceId STRING,
UserId STRING,
OSVersion STRING,
PlatformId STRING,
FbId STRING,
UserPayments INT,
i_date DATE,
i_time TIMESTAMP,
params STRING,
insert_time TIMESTAMP
)
PARTITIONED BY (dump_date STRING, GameVersion STRING, action STRING)STORED AS SEQUENCEFILE;
I want to add  upper partition like:
 platform STRING
final result must be:
)
...
)
PARTITIONED BY (platform STRING,dump_date STRING, GameVersion STRING, action STRING)STORED AS SEQUENCEFILE;
What is the best way to do it?
<br>
Don't have an account?
Coming from Hortonworks? Activate your account here