Takahiko Saito created HIVE-13777: ------------------------------------- Summary: NPE is thrown when select table after change column from string to decimal Key: HIVE-13777 URL: https://issues.apache.org/jira/browse/HIVE-13777 Project: Hive Issue Type: Bug Affects Versions: 1.2.1, 2.1.0 Reporter: Takahiko Saito
Run the followings to change a column from string to decimail: {noformat} drop table if exists shcemaevo_vectorization_true_disallowincompatible_false_fileformat_orc_string_decimal; create table shcemaevo_vectorization_true_disallowincompatible_false_fileformat_orc_string_decimal stored as orc as select s, s_dc from schemaevo; alter table shcemaevo_vectorization_true_disallowincompatible_false_fileformat_orc_string_decimal change column s_dc s_dc decimal(12,4); select count(*) from shcemaevo_vectorization_true_disallowincompatible_false_fileformat_orc_string_decimal; {noformat} select count works fine but just select throws NPE: {noformat} 0: jdbc:hive2://os-r6-0517-hiveserver2-1-1.op> select count(*) from shcemaevo_vectorization_true_disallowincompatible_false_fileformat_orc_string_decimal; +---------+--+ | c0 | +---------+--+ | 100000 | +---------+--+ 1 row selected (13.856 seconds) 0: jdbc:hive2://os-r6-0517-hiveserver2-1-1.op> select * from shcemaevo_vectorization_true_disallowincompatible_false_fileformat_orc_string_decimal; Error: java.io.IOException: java.lang.NullPointerException (state=,code=0) {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)