question Re: how to alter hive table partition in Archives of Support Questions (Read Only)

how to alter hive table partition

bshah1 — Fri, 16 Sep 2022 11:15:49 GMT

I am using hdp 2.4.2 (hive - 1.2.1.2.4).

When I tried using the following hive command it gives me error. Is there a way to alter the table partition location?

show partitions btest.testcglbalances;
+-----------------------+--+
|       partition       |
+-----------------------+--+
| load_date=2017-02-16  |
+-----------------------+--+


alter table btest.testcglbalances partition (load_date='2017-02-16') set location 's3a://xxx/data/test/test2/2017-02-16';

Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Unable to alter partition. alter is not possible (state=08S01,code=1)

Re: how to alter hive table partition

namaheshwari — Thu, 16 Mar 2017 06:18:56 GMT

The below HCC post has a pretty good explanation:

https://community.hortonworks.com/questions/15161/can-we-apply-the-partitioning-on-the-already-exist.html

Re: how to alter hive table partition

deepesh1 — Thu, 16 Mar 2017 06:52:17 GMT

If you ran this using beeline connecting to HS2, can you check the full error stack trace in the hiveserver2.log?

Re: how to alter hive table partition

bshah1 — Thu, 16 Mar 2017 10:35:07 GMT

thanks for your reply. that help