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

1 Answer

Jan 10

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. 

Click here to read more about Loan/Mortgage
Click here to read more about Insurance

Related questions

Jun 20 in Hive
Jan 12 in Big Data | Hadoop
Jul 22 in Big Data | Hadoop