[jira] [Updated] (CARBONDATA-3341) Query is giving NULL in result

[Akash R Nilugal (Jira)]

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

Kunal Kapoor updated CARBONDATA-3341:
-------------------------------------
    Description:
Steps to reproduce:

1 set bad_records_action=force and 

carbon.push.rowfilters.for.vector=true

2. create table t1(a bigint) stored by 'carbondata' TBLPROPERTIES('sort_columns'='a');

3. insert into t1 select 'k';

4. insert into t1 select 1;

5. select * from t1 where a = 1 or a = 0;

 

+--------+-+
|a|

+--------+-+
|NULL|
|1|

+--------+-+

 

  was:
Steps to reproduce:

1. set bad_records_action=force;

2. create table t1(a bigint) stored by 'carbondata' TBLPROPERTIES('sort_columns'='a');

3. insert into t1 select 'k';

4. insert into t1 select 1;

5. select * from t1 where a = 1 or a = 0;

 

+-------+--+
| a |
+-------+--+
| NULL |
| 1 |
+-------+--+

 

> Query is giving NULL in result
> ------------------------------
>
>                 Key: CARBONDATA-3341
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-3341
>             Project: CarbonData
>          Issue Type: Bug
>            Reporter: Kunal Kapoor
>            Assignee: Kunal Kapoor
>            Priority: Major
>
> Steps to reproduce:
> 1 set bad_records_action=force and 
> carbon.push.rowfilters.for.vector=true
> 2. create table t1(a bigint) stored by 'carbondata' TBLPROPERTIES('sort_columns'='a');
> 3. insert into t1 select 'k';
> 4. insert into t1 select 1;
> 5. select * from t1 where a = 1 or a = 0;
>  
> +--------+-+
> |a|
> +--------+-+
> |NULL|
> |1|
> +--------+-+
>  

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