Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
Steps:
1. create table Hive3(Sell_price FLOAT, Item_code STRING, Qty_total Double,Profit Decimal(4,3), Update_time TIMESTAMP )row format delimited fields terminated by ',' collection items terminated by '$'
2. create table Carbon3(Sell_price INT, Item_code STRING, Qty_total DECIMAL(3,1),Profit DECIMAL(3,2), Update_time TIMESTAMP ) STORED BY 'org.apache.carbondata.format'
3. load data LOCAL INPATH '/opt/csv/Data/InsertData/Hive3.csv' overwrite into table Hive3
Issue:
Insert is passing when Hive is having Float and Carbon is having INT value and load file is having single precision decimal value. This should be failed.
Expected:
It should be failed.