数据严格按照我给的数据

好的，我明白了。根据你提供的数据，以下是将数据写入文本文件中的示例代码：

zs age:28,salary:20000,address:beijing
ls age:25,salary:10000,address:sh
as age:30,salary:30000,address:sz
fs age:24,salary:8000,address:sz

接下来是在 Hive 中创建表并导入数据的示例代码：

CREATE TABLE employees (
  name STRING,
  age INT,
  salary INT,
  address STRING
)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
STORED AS TEXTFILE;

LOAD DATA LOCAL INPATH '/path/to/employee.txt' OVERWRITE INTO TABLE employees
  SELECT 
    regexp_extract(col_value, '(?<=^name:)[^,]*', 0) AS name,
    cast(regexp_extract(col_value, '(?<=^age:)[^,]*', 0) AS INT) AS age,
    cast(regexp_extract(col_value, '(?<=^salary:)[^,]*', 0) AS INT) AS salary,
    regexp_extract(col_value, '(?<=^address:)[^,]*', 0) AS address
  FROM (
    SELECT split(line, ' ') AS cols FROM (
      SELECT explode(split(regexp_replace(trim(line), '\\s+', ' '), '\\n')) AS line
      FROM (
        SELECT stack(4, 'zs age:28,salary:20000,address:beijing', 'ls age:25,salary:10000,address:sh', 'as age:30,salary:30000,address:sz', 'fs age:24,salary:8000,address:sz') AS line
      ) t1
    ) t2
  ) t3
  LATERAL VIEW explode(cols) t4 AS col_value;

请将代码中的 `/path/to/employee.txt` 替换为你实际的文件路径。这里使用了 Hive 的正则表达式函数 `regexp_extract()` 来提取文本数据中的字段值，并使用了 Hive 的内置函数 `explode()` 将每一行数据拆分成多个字段。