how to add partition in existing without partitin table

[DataFlair Team]

I have a existing table without partition,data also available in the table.how to add partition in the table.

[DataFlair Team]

Unfortunately, you cannot add/create partition in existing table which was not partitioned while creation of the table.
However if you had partitioned the existing table using “PARTITIONED BY” clause, then you will be allowed you add partition using the ALTER TABLE command.
Please refer to both the create and alter commands below:

CREATE TABLE tab02 (foo INT, bar STRING) PARTITIONED BY (mon STRING);

ALTER TABLE tab02 ADD PARTITION (mon ='10') location '/home/hdadmin/hive-0.13.1-cdh5.3.2/examples/files/kv5.txt';

[Author]

Posts