HIVE fields terminated by 与表在hdfs上的关系

最新推荐文章于 2023-12-28 11:50:07 发布

原创

最新推荐文章于 2023-12-28 11:50:07 发布 · 1.4w 阅读

0 ·

CC 4.0 BY-SA版权

本文探讨了HIVE的FIELDS TERMINATED BY设置如何影响HDFS上数据存储，虽然在HIVE查询界面中更改此设置不会立即显示变化，但实际文件在HDFS上确实会根据该设置进行调整。

hive显示不随fields terminated by发生变化，但是hdfs随着fields terminated by发生变化。

CREATE TABLE `spark_ml_essemble_training_table_space`(
`app_lable` double,
`imei_gender_man` string,
`imei_gender_woman` string,
`imei_age_5_18` string,
`imei_age_19_23` string,
`imei_age_24_29` string,
`imei_age_30_40` string,
`imei_age_41_60` string,
`imei_age_other` string,
`imei_dl_class_100` string,
`imei_dl_class_101` string,
`imei_dl_class_102` string,
`imei_dl_class_103` string,
`imei_dl_class_104` string,
`imei_dl_class_105` string,
`imei_dl_class_106` string,
`imei_dl_class_107` string,
`imei_dl_class_108` string,
`imei_dl_class_109` string,
`imei_dl_class_110` string,
`imei_dl_class_111` string,
`imei_dl_class_112` string,
`imei_dl_class_113` string,
`imei_dl_class_114` string,
`imei_dl_class_115` string,
`imei_dl_class_116` string,
`imei_dl_class_117` string,
`imei_dl_class_118` string,
`imei_dl_class_119` string,
`imei_dl_class_121` string,