[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


test("ii") {
    sql("drop table IF EXISTS price")
    sql("drop table IF EXISTS akash")
    sql("create table price(product string,price int) stored by 'carbondata'")
    sql("create table akash(product string,quality string) stored by 
'carbondata'")
    sql("create datamap mv using 'mv' as select 
price.product,price.price,akash.product,akash.quality from price,akash where 
price.product = akash.product")
//    sql("select price.product,price.price,akash.product,akash.quality from 
price,akash where price.product = akash.product").show(false)
    sql("explain select price.product from price,akash where price.product = 
akash.product").show(false)
  }




  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
> test("ii") {
>     sql("drop table IF EXISTS price")
>     sql("drop table IF EXISTS akash")
>     sql("create table price(product string,price int) stored by 'carbondata'")
>     sql("create table akash(product string,quality string) stored by 
> 'carbondata'")
>     sql("create datamap mv using 'mv' as select 
> price.product,price.price,akash.product,akash.quality from price,akash where 
> price.product = akash.product")
> //    sql("select price.product,price.price,akash.product,akash.quality from 
> price,akash where price.product = akash.product").show(false)
>     sql("explain select price.product from price,akash where price.product = 
> akash.product").show(false)
>   }



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