[jira] [Created] (HIVE-13356) ClassCastException: org.apache.hadoop.hive.serde2.io.DateWritable cannot be cast to org.apache.hadoop.io.IntWritable

["Vitalii Diravka (JIRA)" <ji...@apache.org>]

Vitalii Diravka created HIVE-13356:
--------------------------------------

             Summary: ClassCastException: org.apache.hadoop.hive.serde2.io.DateWritable cannot be cast to org.apache.hadoop.io.IntWritable
                 Key: HIVE-13356
                 URL: https://issues.apache.org/jira/browse/HIVE-13356
             Project: Hive
          Issue Type: Bug
    Affects Versions: 1.2.1
            Reporter: Vitalii Diravka


Hive query involves cast date to int data type throughs cast exception.
{code}
[mapr@cs2none500 bin]$ rpm -qa |grep mapr
mapr-hadoop-core-2.7.0.32987.GA-1.x86_64
mapr-fileserver-5.0.0.32987.GA-1.x86_64
mapr-zookeeper-5.0.0.32987.GA-1.x86_64
mapr-historyserver-2.7.0.32987.GA-1.x86_64
mapr-hiveserver2-1.2.201601281422-1.noarch
mapr-hive-1.2.201601281422-1.noarch
mapr-hivemetastore-1.2.201601281422-1.noarch
mapr-core-internal-5.0.0.32987.GA-1.x86_64
mapr-mapreduce2-2.7.0.32987.GA-1.x86_64
mapr-core-5.0.0.32987.GA-1.x86_64
mapr-tasktracker-5.0.0.32987.GA-1.x86_64
mapr-jobtracker-5.0.0.32987.GA-1.x86_64
mapr-webserver-5.0.0.32987.GA-1.x86_64
mapr-nodemanager-2.7.0.32987.GA-1.x86_64
mapr-zk-internal-5.0.0.32987.GA.v3.4.5-1.x86_64
mapr-mapreduce1-0.20.2.32987.GA-1.x86_64
mapr-cldb-5.0.0.32987.GA-1.x86_64
mapr-resourcemanager-2.7.0.32987.GA-1.x86_64
mapr-drill-1.4.0.201601071151-1.noarch
{code}
Hive schema (parquet file in attachments):
{code}
create external table if not exists hive_storage.fewtypes_parquet (
  int_col int,
  bigint_col bigint,
  date_col int,
  time_col int,
  timestamp_col bigint,
  interval_col string,
  varchar_col string,
  float_col float,
  double_col double,
  bool_col boolean
)
STORED AS PARQUET
LOCATION '/tmp/testdata/hive_storage/fewtypes_parquet';
{code}
{code}
hive> use hive_storage;
OK
Time taken: 0.035 seconds
hive> show tables;
OK
fewtypes_parquet
Time taken: 0.034 seconds, Fetched: 1 row(s)
hive> select * from fewtypes_parquet;
OK
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
Failed with exception java.io.IOException:org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.ClassCastException: org.apache.hadoop.hive.serde2.io.DateWritable cannot be cast to org.apache.hadoop.io.IntWritable
Time taken: 0.41 seconds
{code}
If date_col in CTAS is date the query will be executed. 
Hive1.0 hasn't this issue.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)