[
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("test cast expression with mv") {
// sql("drop table IF EXISTS maintable")
// sql("create table maintable (m_month bigint, c_code string, " +
// "c_country smallint, d_dollar_value double, q_quantity double, u_unit
smallint, b_country smallint, i_id int, y_year smallint) stored by
'carbondata'")
// sql("insert into maintable select 10, 'xxx', 123, 456, 45, 5, 23, 1,
2000")
// sql("drop datamap if exists da_cast")
// sql("select cast(floor((m_month +1000) / 900) * 900 - 2000 AS INT) as a,
c_code as abc from maintable").show(false)
// sql("create datamap da_cast using 'mv' as select q_quantity as a, c_code
as abc from maintable")
// sql("create datamap da_cast using 'mv' as select cast(floor((m_month
+1000) / 900) * 900 - 2000 AS INT) as a, c_code as abc from maintable")
sql(" select cast(floor((m_month +1000) / 900) * 900 - 2000 AS INT) as a
,c_code from maintable").show(false)
// sql("explain select cast(floor((m_month +1000) / 900) * 900 - 2000 AS
INT) as a, c_code as abc from maintable").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("test cast expression with mv") {
> // sql("drop table IF EXISTS maintable")
> // sql("create table maintable (m_month bigint, c_code string, " +
> // "c_country smallint, d_dollar_value double, q_quantity double,
> u_unit smallint, b_country smallint, i_id int, y_year smallint) stored by
> 'carbondata'")
> // sql("insert into maintable select 10, 'xxx', 123, 456, 45, 5, 23, 1,
> 2000")
> // sql("drop datamap if exists da_cast")
> // sql("select cast(floor((m_month +1000) / 900) * 900 - 2000 AS INT) as
> a, c_code as abc from maintable").show(false)
> // sql("create datamap da_cast using 'mv' as select q_quantity as a,
> c_code as abc from maintable")
> // sql("create datamap da_cast using 'mv' as select cast(floor((m_month
> +1000) / 900) * 900 - 2000 AS INT) as a, c_code as abc from maintable")
> sql(" select cast(floor((m_month +1000) / 900) * 900 - 2000 AS INT) as a
> ,c_code from maintable").show(false)
> // sql("explain select cast(floor((m_month +1000) / 900) * 900 - 2000 AS
> INT) as a, c_code as abc from maintable").show(false)
> }
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
