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

1 Answer

0 votes
Jan 10, 2020

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. 

Related questions

0 votes
Jun 13, 2020 in HBase
0 votes
Apr 1, 2020 in Big Data | Hadoop