Update , SET option in Hive
INSERT OVERWRITE TABLE _tableName_ PARTITION (_partitionColumn_= _partitionValue_) SELECT [other Things], CASE WHEN id=206 THEN ‘florida’ ELSE location END AS location, [other Other Things] FROM _tableName_ WHERE [_whereClause_]; You can have multiple partitions listed by separating them by commas. … PARTITION (_partitionColumn_= _partitionValue1_, _partitionColumn_= _partitionValue2_, …). I haven’t done this with multiple partitions, just one at … Read more