Details
-
Bug
-
Status: Resolved
-
Minor
-
Resolution: Fixed
-
None
-
None
-
None
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
def updatePlan(plan: ModularPlan): ModularPlan = {
// get all the outputlist from relation
val dmOutputList = plan.collect
.flatten
val newPlan = plan.transform {
case plan =>
plan.transformExpressions {
case attr: Attribute =>
val existingCol = dmOutputList.find(_.exprId.equals(attr.exprId))
if (existingCol.isDefined)
else
{ attr } }
}
newPlan
}
Attachments
Issue Links
- links to