Uploaded image for project: 'CarbonData'
  1. CarbonData
  2. CARBONDATA-1829

Carbon 1.3.0 - Spark 2.2: Insert is passing when Hive is having Float and Carbon is having INT value and load file is having single precision decimal value

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 1.3.0
    • 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.

      Attachments

        1. Hive3.csv
          0.1 kB
          Ayushi Sharma

        Activity

          People

            Unassigned Unassigned
            Ayushi_22 Ayushi Sharma
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: