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

[Akash R Nilugal (JIRA)]

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

Akash R Nilugal updated CARBONDATA-3403:
----------------------------------------
    Description: 
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


 private def updatePredicateList(plan: modular.Select): modular.Select = {
    // update the AttributeRefrence name, if already the name is its table name,
    // here qualifier name is gen_subsumer_,
    val updatedPlan = plan.transformExpressions {
      case ref: Attribute if ref.name.contains(CarbonCommonConstants.POINT) =>
        val newName = 
ref.name.substring(ref.name.lastIndexOf(CarbonCommonConstants.POINT) + 1, 
ref.name.length)
        AttributeReference(newName, ref.dataType)(exprId = ref.exprId, 
qualifier = ref.qualifier)
    }
    updatedPlan
  }

  was:
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





> 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
>            Priority: Minor
>             Fix For: 1.6.0
>
>          Time Spent: 1h 40m
>  Remaining Estimate: 0h
>
> 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
>  private def updatePredicateList(plan: modular.Select): modular.Select = {
>     // update the AttributeRefrence name, if already the name is its table 
> name,
>     // here qualifier name is gen_subsumer_,
>     val updatedPlan = plan.transformExpressions {
>       case ref: Attribute if ref.name.contains(CarbonCommonConstants.POINT) =>
>         val newName = 
> ref.name.substring(ref.name.lastIndexOf(CarbonCommonConstants.POINT) + 1, 
> ref.name.length)
>         AttributeReference(newName, ref.dataType)(exprId = ref.exprId, 
> qualifier = ref.qualifier)
>     }
>     updatedPlan
>   }



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