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

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. 

Related questions

0 votes
asked Apr 1, 2020 in Big Data | Hadoop by AdilsonLima
0 votes
asked Apr 24, 2020 in Big Data | Hadoop by Hodge
0 votes
asked Jan 12, 2020 in Big Data | Hadoop by sharadyadav1986
...