Hive modify partitioned table data

Question

Problem: One column value is null. It should be 'ab'. Unfortunately I have written '' instead 'ab'.

My table is partitioned table. Is there any way to change that?

I found the following way. But it seems inefficient.

1. Create a temp table like my table
2. Use INSERT OVERWRITE. Read data from my old table and write to new table. I am using case statement to change '' to 'ab'
3. And then change my temp table to original table.

I am looking for a solution something like update partition and msck. Is there any way to do?

Answer 1

You can overwrite single partition in this way:

set hive.exec.dynamic.partition=true;
set hive.exec.dynamic.partition.mode=nonstrict;

insert overwrite target_table partition (part_col)
select 
case when column ='' then 'ab' else column end as column ,
col2,    --select all the columns in the same order
col3,
part_col --partition column is the last one
from target_table where part_col='your_partition_value';