Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Tue, 17 May 2016 21:18:13 +0000 (UTC)
From: "Takahiko Saito (JIRA)" <jira@apache.org>
To: dev@hive.apache.org
Message-ID: <JIRA.12970541.1463519888000.216146.1463519893355@Atlassian.JIRA>
In-Reply-To: <JIRA.12970541.1463519888000@Atlassian.JIRA>
References: <JIRA.12970541.1463519888000@Atlassian.JIRA> <JIRA.12970541.1463519888147@arcas>
Subject: [jira] [Created] (HIVE-13777) NPE is thrown when select table after
 change column from string to decimal
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Tue, 17 May 2016 21:18:15 -0000

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)