```sql
-- 使用replace命令替换数据
INSERT OVERWRITE TABLE table_name
SELECT
column1,
column2,
...
FROM
(
-- 选择要替换的数据
SELECT
column1,
column2,
...
FROM
table_name
WHERE
condition
UNION ALL
-- 选择要插入的数据
SELECT
new_column1 AS column1,
new_column2 AS column2,
...
FROM
dual
) t
;