如何从字段在hive中动态插入？

-- 创建临时表
CREATE TABLE temp_table (
  id INT,
  name STRING,
  dynamic_field_name STRING,
  dynamic_field_value STRING
);

-- 插入数据到临时表
INSERT INTO TABLE temp_table VALUES
  (1, 'John', 'age', '25'),
  (2, 'Jane', 'gender', 'Female');

-- 动态插入字段到目标表
INSERT INTO TABLE target_table
SELECT
  id,
  name,
  CASE WHEN dynamic_field_name = 'age' THEN CAST(dynamic_field_value AS INT) ELSE NULL END AS age,
  CASE WHEN dynamic_field_name = 'gender' THEN dynamic_field_value ELSE NULL END AS gender
FROM temp_table;