您可以在配置单元中创建一个临时表，然后分开选择每一列。让我们在hdfs“/tmp/test.csv”中创建一个包含以下内容的测试文件：
列1，列2，列3
列4，列5，列6
第7列、第8列、第9列
如果创建此临时表：

CREATE TABLE tmp_csv(c1 STRING, c2 STRING, c3 STRING) 
ROW FORMAT DELIMITED FIELDS TERMINATED BY ",";

LOAD DATA INPATH '/tmp/test.csv' OVERWRITE INTO TABLE tmp_csv;

然后可以使用以下内容重建表：

CREATE TABLE final_csv AS SELECT * FROM 
(   SELECT t1.c1 as col FROM tmp_csv t1 
    UNION ALL 
    SELECT t2.c2 as col FROM tmp_csv t2
    UNION ALL 
    SELECT t3.c3 as col FROM tmp_csv t3
)combined;

表格final\u csv的内容如下：

col1
col4
col7
col2
col5
col8
col3
col6
col9