[
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
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
CREATE TABLE smartcare_mv_test.sdr_signal_s1mme_cgisai_15min_17938_1kw_288Loads
(
batchno bigint ,
starttime bigint ,
mme_id bigint ,
ran_ne_id bigint ,
rat bigint ,
cgisai string ,
roam_direction bigint ,
mcc string ,
mnc string ,
homemcc string ,
homemnc string ,
s1mme_attach_req_times bigint ,
s1mme_attach_succ_times bigint ,
s1mme_attach_delay_msel bigint ,
s1mme_eps_attach_req_times bigint ,
s1mme_eps_attach_succ_times bigint ,
s1mme_eps_attach_delay_msel bigint ,
s1mme_combined_eps_imsi_attach_req_times bigint ,
s1mme_combined_eps_imsi_attach_succ_times bigint ,
s1mme_combined_eps_imsi_attach_delay_msel bigint ,
s1mme_authentication_req_times bigint ,
s1mme_authentication_succ_times bigint ,
s1mme_authentication_delay_msel bigint ,
s1mme_sec_mode_req_times bigint ,
s1mme_sec_mode_succ_times bigint ,
s1mme_sec_mode_delay_msel bigint ,
s1mme_identity_req_times bigint ,
s1mme_identity_succ_times bigint ,
s1mme_identity_delay_msel bigint ,
s1mme_def_bearer_req_times bigint ,
s1mme_def_bearer_succ_times bigint ,
s1mme_def_bearer_delay_msel bigint ,
s1mme_ded_bearer_req_times bigint ,
s1mme_ded_bearer_succ_times bigint ,
s1mme_ded_bearer_delay_msel bigint ,
initial_ctx_req_times bigint ,
initial_ctx_succ_times bigint ,
initial_ctx_delay_msel bigint ,
ue_pdn_conn_req_times bigint ,
ue_pdn_conn_succ_times bigint ,
ue_pdn_conn_delay_msel bigint ,
s1mme_ue_detach_req_times bigint ,
s1mme_ue_detach_succ_times bigint ,
s1mme_ue_detach_delay_msel bigint ,
s1mme_nw_detach_req_times bigint ,
s1mme_nw_detach_succ_times bigint ,
s1mme_nw_detach_delay_msel bigint ,
normal_tau_req_times bigint ,
normal_tau_succ_times bigint ,
normal_tau_delay_msel bigint ,
combined_tala_update_req_times bigint ,
combined_tala_update_succ_times bigint ,
combined_tala_update_delay_msel bigint ,
periodic_tau_req_times bigint ,
periodic_tau_succ_times bigint ,
periodic_tau_delay_msel bigint ,
s1mme_service_req_times bigint ,
s1mme_service_succ_times bigint ,
s1mme_service_delay_msel bigint ,
erab_setup_req_times bigint ,
erab_setup_succ_times bigint ,
erab_setup_delay_msel bigint ,
ue_pdn_disconn_req_times bigint ,
ue_pdn_disconn_succ_times bigint ,
ue_pdn_disconn_delay_msel bigint ,
s1mme_eps_bearer_deact_req_times bigint ,
s1mme_eps_bearer_deact_succ_times bigint ,
s1mme_eps_bearer_deact_delay_msel bigint ,
erab_rls_req_times bigint ,
erab_rls_succ_times bigint ,
erab_rls_delay_msel bigint ,
ue_bearer_modify_req_times bigint ,
ue_bearer_modify_succ_times bigint ,
ue_bearer_modify_delay_msel bigint ,
s1mme_eps_bearer_mod_req_times bigint ,
s1mme_eps_bearer_mod_succ_times bigint ,
s1mme_eps_bearer_mod_delay_msel bigint ,
erab_modify_req_times bigint ,
erab_modify_succ_times bigint ,
erab_modify_delay_msel bigint ,
ue_bearer_alloc_req_times bigint ,
ue_bearer_alloc_succ_times bigint ,
ue_bearer_alloc_delay_msel bigint ,
path_switch_req_times bigint ,
path_switch_succ_times bigint ,
path_switch_delay_msel bigint ,
ho_prep_req_times bigint ,
ho_prep_succ_times bigint ,
ho_prep_delay_msel bigint ,
ho_res_alloc_req_times bigint ,
ho_res_alloc_succ_times bigint ,
ho_res_alloc_delay_msel bigint ,
ho_cancel_req_times bigint ,
ho_cancel_succ_times bigint ,
ho_cancel_delay_msel bigint ,
guti_realloc_req_times bigint ,
guti_realloc_succ_times bigint ,
guti_realloc_delay_msel bigint ,
mme_reset_req_times bigint ,
mme_reset_succ_times bigint ,
mme_reset_delay_msel bigint ,
utran_reset_req_times bigint ,
utran_reset_succ_times bigint ,
utran_reset_delay_msel bigint ,
s1_setup_req_times bigint ,
s1_setup_succ_times bigint ,
s1_setup_delay_msel bigint ,
ue_ctx_rls_cmd_times bigint ,
ue_ctx_rls_succ_times bigint ,
ue_ctx_rls_delay_msel bigint ,
ue_ctx_modify_req_times bigint ,
ue_ctx_modify_succ_times bigint ,
ue_ctx_modify_delay_msel bigint ,
enb_config_update_req_times bigint ,
enb_config_update_succ_times bigint ,
enb_config_update_delay_msel bigint ,
mme_config_update_req_times bigint ,
mme_config_update_succ_times bigint ,
mme_config_update_delay_msel bigint ,
write_replace_warn_req_times bigint ,
write_replace_warn_succ_times bigint ,
write_replace_warn_delay_msel bigint ,
overload_start_times bigint ,
overload_stop_times bigint ,
erab_rls_ind_times bigint ,
layer1id bigint ,
layer2id bigint ,
layer3id bigint ,
layer4id bigint ,
layer5id bigint ,
layer6id bigint ,
rai_tai string ,
paging_req_times bigint ,
paging_succeed_times bigint ,
paging_delay_msel bigint ,
working_mode string ,
erab_modify_indication_req_times bigint ,
erab_modify_indication_succ_times bigint ,
erab_modify_indication_delay_msel bigint ,
ue_ctx_modify_indication_req_times bigint ,
ue_ctx_modify_indication_succ_times bigint ,
ue_ctx_modify_indication_delay_msel bigint
)STORED BY 'carbondata'
TBLPROPERTIES('SORT_COLUMNS'='starttime', 'TABLE_BLOCKSIZE'='128',
'SORT_SCOPE'='LOCAL_SORT',local_dictionary_enable='false');
CREATE TABLE DIM_REGION (
ID bigint ,
L6REGIONID int ,
L6REGIONNAME string ,
L5REGIONID int ,
L5REGIONNAME string ,
L4REGIONID int ,
L4REGIONNAME string ,
L3REGIONID int ,
L3REGIONNAME string ,
L2REGIONID int ,
L2REGIONNAME string ,
L1REGIONID int ,
L1REGIONNAME string
)STORED BY 'carbondata'
TBLPROPERTIES('SORT_COLUMNS'='ID', 'TABLE_BLOCKSIZE'='128',
'SORT_SCOPE'='LOCAL_SORT',local_dictionary_enable='false')
CREATE TABLE DIM_LOC_CGISAI (
ID bigint,
CGISAI string,
CELL_NAME string,
XPOS bigint,
YPOS bigint,
DIRECTIONANGLE bigint,
TCHNUM bigint,
RADIUS bigint,
BSCRNC_ID bigint,
BSCRNC_NAME string,
LAI string,
SGSN_ID int,
SGSN_NAME string,
ACCESS_TYPE_ID int,
ACCESS_TYPE string,
VALID_FLAG int,
CHANGE_TIME string,
THROUGHPUT int,
MMEID int,
POOL_TAG int,
POOL_ID int,
POOL_NAME string,
LAYER1ID int,
LAYER1NAME string,
LAYER2ID int,
LAYER2NAME string,
LAYER3ID int,
LAYER3NAME string,
LAYER4ID int,
LAYER4NAME string,
LAYER5ID int,
LAYER5NAME string,
LAYER6ID int,
LAYER6NAME string,
SITE_NAME string,
SGSNPOOL_TAG bigint,
CELL_STATUS int,
CGI_DEC string,
MCC string,
MNC string,
ECI_DEC string,
WORKING_MODE string,
TAC string ,
RAN_NE_VENDOR string,
CELL_COVERAGE_TYPE bigint,
SITETYPE bigint,
BAND string,
OPERATOR string,
OPTI_NUMBER string,
ANTENNA_IS_INDOOR string,
RESERVED1 string,
RESERVED2 string,
RESERVED3 string,
RESERVED4 string,
RESERVED5 string
)STORED BY 'carbondata'
TBLPROPERTIES('SORT_COLUMNS'='ID', 'TABLE_BLOCKSIZE'='128',
'SORT_SCOPE'='LOCAL_SORT',local_dictionary_enable='false')
> 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
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
