[jira] [Created] (CARBONDATA-3403) MV is not working for like and filter AND and OR queries

[Akash R Nilugal (Jira)]

Akash R Nilugal created CARBONDATA-3403:
-------------------------------------------

             Summary: MV is not working for like and filter AND and OR queries
                 Key: CARBONDATA-3403
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-3403
             Project: CarbonData
          Issue Type: Bug
            Reporter: Akash R Nilugal


MV is not working for like and filter AND and OR queries

 

Steps:

create table brinjal (imei string,AMSize string,channelsId string,ActiveCountry string, Activecity string,gamePointId double,deviceInformationId double,productionDate Timestamp,deliveryDate timestamp,deliverycharge double) STORED BY 'org.apache.carbondata.format' ;

 

create datamap brinjal_mv_tab_nlz_aa016 on table brinjal using 'mv' as select imei,AMSize,channelsId from brinjal where ActiveCountry NOT LIKE 'US' group by imei,AMSize,channelsId;


create datamap brinjal_mv_tab_nlz_aa018 on table brinjal using 'mv' as select imei,AMSize,channelsId,ActiveCountry from brinjal where ActiveCountry ='Chinese' or channelsId =4 group by imei,AMSize,channelsId,ActiveCountry;

 

then 

select imei,AMSize,channelsId from brinjal where ActiveCountry NOT LIKE 'US' group by imei,AMSize,channelsId; and 

  select imei,AMSize,channelsId,ActiveCountry from brinjal where ActiveCountry ='Chinese' or channelsId =4 group by imei,AMSize,channelsId,ActiveCountry;

are not hitting the datamap cretaed



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