請問我hive表需修改某字段(在表中的位置非末尾)類型由varchar(16)改為varchar(32),使用如下語句:ALTER TABLE table_name CHANGE [COLUMN] col_old_name col_new_name column_type [COMMENT col_comment]成功在hive側(cè)修改了且查出來的表結(jié)構(gòu)證實確實成功了。但spark查到的表結(jié)構(gòu)卻未更新且insert時報錯:Caused by: java.lang.RuntimeException: Exceeds char/varchar type length limitation: 16
at org.apache.spark.sql.catalyst.util.CharVarcharCodegenUtils.trimTrailingSpaces(CharVarcharCodegenUtils.java:30) at org.apache.spark.sql.catalyst.util.CharVarcharCodegenUtils.varcharTypeWriteSideCheck(CharVarcharCodegenUtils.java:52) at org.apache.spark.sql.catalyst.expressions.GeneratedClass$SpecificUnsafeProjection.writeFields_0_106$(Unknown Source) at org.apache.spark.sql.catalyst.expressions.GeneratedClass$SpecificUnsafeProjection.apply(Unknown Source) at org.apache.spark.sql.catalyst.expressions.GeneratedClass$SpecificUnsafeProjection.apply(Unknown Source)
【Hive問題 2】Hive修改字段類型異常背景 常見hive修改字段類型操作 但是有時候修改字段類型會出現(xiàn)以下異常: 其中可能是string類型無法轉(zhuǎn)換為int等強轉(zhuǎn)類型的限制 可以進行以下步驟的嘗試解決上面遇到的問...