[jira] [Updated] (CARBONDATA-1459) Error in using insert into in Carbonadata 1.2.0 while using tables loaded using CarbonData 1.1.0

["Ravindra Pesala (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CARBONDATA-1459?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ravindra Pesala updated CARBONDATA-1459:
----------------------------------------
    Fix Version/s:     (was: 1.2.0)
                   NONE

> Error in using insert into in Carbonadata 1.2.0 while using tables loaded using CarbonData 1.1.0
> ------------------------------------------------------------------------------------------------
>
>                 Key: CARBONDATA-1459
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-1459
>             Project: CarbonData
>          Issue Type: Bug
>          Components: data-query
>    Affects Versions: 1.2.0
>            Reporter: Pallavi Singh
>             Fix For: NONE
>
>
> I have a table created and loaded in Carbondata 1.1.0 when I try to load data into a new table created using CarbonData 1.2.0 using insert into, the data load fails.
> insert into T_Carbon2 select * from T_Carbon1;
> We get the error :
> 0: jdbc:hive2://localhost:10000> insert into T_Carbon2 select * from T_Carbon01;
> Error: java.lang.Exception: DataLoad failure (state=,code=0)
> here T_Carbon2 is loaded in 1.2.0, while T_Carbon1 is loaded in 1.1.0
> the queries are given below :
> create table T_Carbon01(Active_status String,Item_type_cd INT,Qty_day_avg INT,Qty_total INT,Sell_price BIGINT,Sell_pricep DOUBLE,Discount_price DOUBLE,Profit DECIMAL(3,2),Item_code String,Item_name String,Outlet_name String,Update_time TIMESTAMP,Create_date String)STORED BY 'org.apache.carbondata.format'
> create table T_Carbon2(Active_status String,Item_type_cd INT,Qty_day_avg INT,Qty_total INT,Sell_price BIGINT,Sell_pricep DOUBLE,Discount_price DOUBLE,Profit DECIMAL(3,2),Item_code String,Item_name String,Outlet_name String,Update_time TIMESTAMP,Create_date String)STORED BY 'org.apache.carbondata.format'
> LOAD DATA INPATH 'hdfs://localhost:54310/data/T_Hive1.csv' INTO table T_Carbon01 options ('DELIMITER'=',', 'QUOTECHAR'='\', 'FILEHEADER'='Active_status,Item_type_cd,Qty_day_avg,Qty_total,Sell_price,Sell_pricep,Discount_price,Profit,Item_code,Item_name,Outlet_name,Update_time,Create_date')



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)