應(yīng)用場景使用spark將數(shù)據(jù)落入表中可能會存在列名不對應(yīng)等情況，需要更改列名

hive> desc uid_follow_anchor_number; OK uid string target_uid string timestamp string Time taken: 0.097 seconds, Fetched: 3 row(s) hive> ALTER TABLE uid_follow_anchor_number CHANGE uid uid_1 string; OK Time taken: 0.223 seconds hive> ALTER TABLE uid_follow_anchor_number CHANGE target_uid uid string; OK Time taken: 0.233 seconds hive> ALTER TABLE uid_follow_anchor_number CHANGE uid_1 target_uid string; OK Time taken: 0.222 seconds hive> desc uid_follow_anchor_number; OK target_uid string uid string timestamp string Time taken: 0.088 seconds, Fetched: 3 row(s)

?

總結(jié)

以上是生活随笔為你收集整理的更改hive列名的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。