in Big Data | Hadoop by
Q:
How can you add a new partition for the month December in the above partitioned table?

▼ Show 1 Answer

0 votes
by

For adding a new partition in the above table partitioned_transaction, we will issue the command give below:

ALTER TABLE partitioned_transaction ADD PARTITION (month=’Dec’) LOCATION  ‘/partitioned_transaction’;

Note: I suggest you to go through the dedicated blog on Hive Commands where all the commands present in Apache Hive have been explained with an example. 

Learn More with Madanswer
...