试图更改配置单元中的cloumn类型，运行ddl，但它抛出了一个错误“

ttvkxqim 于 2021-05-29 发布在 Hadoop

关注(0)|答案(1)|浏览(574)

尝试更改配置单元中的cloumn类型，运行ddl，但它抛出了一个错误
运行以下ddl：

ALTER TABLE INV.HTL_RATE_PLAN
CHANGE RATE_PLAN_RSTRCT_STRT_DT RATE_PLAN_RSTRCT_STRT_DT DATE 
COMMENT 'Advance booking alternate days restriction rule applied to a rate category. This rule dictates the minimum number of days before arrival the guest must book for the rate category to be available.'
AFTER PRICE_GRID_CD;

错误：

Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Reordering columns is not supported for table INV_TRF.HTL_RATE_PLAN. SerDe may be incompatible.

救命啊？我做错了什么。请建议。

hadoop Hive ddl hive-serde

来源：https://stackoverflow.com/questions/41638344/trying-to-change-the-cloumn-type-in-hive-running-a-ddl-but-its-throwing-an-er

1条答案

按热度按时间

0h4hbjxa1#

要更改列类型，只需执行以下操作：

ALTER TABLE INV.HTL_RATE_PLAN
CHANGE RATE_PLAN_RSTRCT_STRT_DT RATE_PLAN_RSTRCT_STRT_DT DATE 
COMMENT 'Advance booking alternate days restriction rule applied to a rate category. This rule dictates the minimum number of days before arrival the guest must book for the rate category to be available.';

拆下的零件 AFTER PRICE_GRID_CD 将列位置更改为位于指定列之后，但是由serde处理的存储类型不支持此操作。

赞(0）回复(0）举报 2021-05-29

我来回答

试图更改配置单元中的cloumn类型，运行ddl，但它抛出了一个错误“

1条答案

相关问题

热门标签

最新问答