[jira] [Created] (CARBONDATA-3083) Null values are getting replaced by 0 after update operation.

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (CARBONDATA-3083) Null values are getting replaced by 0 after update operation.

Akash R Nilugal (Jira)
Kunal Kapoor created CARBONDATA-3083:
----------------------------------------

             Summary: Null values are getting replaced by 0 after update operation.
                 Key: CARBONDATA-3083
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-3083
             Project: CarbonData
          Issue Type: Bug
    Affects Versions: 1.5.1
            Reporter: Kunal Kapoor
            Assignee: Kunal Kapoor
             Fix For: 1.5.1


create table negativeTable(intCol int, stringCol string, shortCol short) stored by 'carbondata'

load data inpath 'hdfs://hacluster/user/dataWithNegativeValues.csv' into table negativeTable options('delimiter'=',','fileheader'='intCol,stringCol,shortCol','bad_records_action'='force')

select * from negativeTable

insert into negativeTable select 0,null,-10

insert into negativeTable select null,'inserted',20

select * from negativeTable

update negativeTable set (intCol) = (5) where intCol=0

select * from negativeTable



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)