[ 
https://issues.apache.org/jira/browse/HIVE-16314?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15945237#comment-15945237
 ] 

Kirthiga Balasubramanian commented on HIVE-16314:
-------------------------------------------------

Adding the exception here

select * from  databasename.tablename where us_date ='2017-02-17' and 
us_capacity is not null  limit 10;

Failed with exception 
java.io.IOException:org.apache.hadoop.hive.ql.metadata.HiveException: 
java.lang.ClassCastException: org.apache.hadoop.hive.serde2.io.ByteWritable 
cannot be cast to org.apache.hadoop.io.IntWritable

> Data type change in ORC hive table
> ----------------------------------
>
>                 Key: HIVE-16314
>                 URL: https://issues.apache.org/jira/browse/HIVE-16314
>             Project: Hive
>          Issue Type: Bug
>          Components: Hive
>    Affects Versions: 1.2.1
>         Environment: Production
>            Reporter: Kirthiga Balasubramanian
>            Priority: Critical
>
> Change in column data type of ORC hive table is throwing exception.
> ORC table is partitioned. The data type of one column has been changed from 
> tinyint to int. 
> 1) Querying the column for a partition after the data type change is giving 
> results.
> 2)Querying the column for a partition before the data type change was made is 
> throwing the below exception



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Reply via email to