carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Neha Bhardwaj (JIRA)" <>
Subject [jira] [Created] (CARBONDATA-950) selecting table data having a column of "date" type throws exception in hive
Date Tue, 18 Apr 2017 07:37:41 GMT
Neha Bhardwaj created CARBONDATA-950:

             Summary: selecting table data having a column of "date" type throws exception
in hive
                 Key: CARBONDATA-950
             Project: CarbonData
          Issue Type: Bug
          Components: data-query
         Environment: spark 2.1, hive 1.2.1
            Reporter: Neha Bhardwaj
            Priority: Minor
         Attachments: my_user.csv

selecting data from a hive table containing a column of date datatype is failing to render

Steps to reproduce:
1) In Spark Shell :
a) Create Table -
import org.apache.spark.sql.SparkSession
import org.apache.spark.sql.CarbonSession._
val carbon = SparkSession.builder().config(sc.getConf).getOrCreateCarbonSession("hdfs://localhost:54310/opt/data")

scala> carbon.sql(" create table my_user(id int, name string,dob date) stored by 'carbondata'

b) Load Data -
scala> carbon.sql(""" load data inpath 'hdfs://localhost:54310/Files/my_user.csv' into
table my_user """ ).show

2) In Hive :
a) Add Jars -
add jar /home/neha/incubator-carbondata/assembly/target/scala-2.11/carbondata_2.11-1.1.0-incubating-SNAPSHOT-shade-hadoop2.7.2.jar;
add jar /opt/spark-2.1.0-bin-hadoop2.7/jars/spark-catalyst_2.11-2.1.0.jar;
add jar /home/neha/incubator-carbondata/integration/hive/carbondata-hive-1.1.0-incubating-SNAPSHOT.jar;

b) Create Table -
create table my_user(id int, name string,dob date);

c) Alter location -
hive> alter table my_user set LOCATION 'hdfs://localhost:54310/opt/data/default/my_user'

d) Set Properties -
set hive.mapred.supports.subdirectories=true;
set mapreduce.input.fileinputformat.input.dir.recursive=true;

d) Alter FileFormat -
alter table my_user set FILEFORMAT
INPUTFORMAT "org.apache.carbondata.hive.MapredCarbonInputFormat"
OUTPUTFORMAT "org.apache.carbondata.hive.MapredCarbonOutputFormat"
SERDE "org.apache.carbondata.hive.CarbonHiveSerDe";

e) Query:
select * from my_user;

Expected Output: 
display all the data of table my_user.

Actual Output:
Failed with exception java.lang.Integer
cannot be cast to java.lang.Long

This message was sent by Atlassian JIRA

View raw message