in Big Data | Hadoop by
Q:
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. 

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

Related questions

0 votes
asked Feb 23, 2020 in Big Data | Hadoop by rahuljain1
0 votes
asked Jan 12, 2020 in Big Data | Hadoop by sharadyadav1986
0 votes
asked Jul 22, 2020 in Big Data | Hadoop by Hodge
0 votes
asked Apr 24, 2020 in Big Data | Hadoop by Hodge
0 votes
asked Mar 12, 2020 in JavaScript by GeorgeBell
...