============================================================================ USER COMMAND: /*+ cache(pref_mem ttl:52689142) */ SELECT StreamAccountNOSX.StreamAccount_StreamChannelI AS StreamAccountNOSX_StreamAcco1, StreamChannel.StreamChannel AS StreamChannel_StreamChannel, SUM(StreamAccountNOSX.StreamAccount_StreamAcID) AS StreamAccountNOSX_StreamAcco, StreamAccountNOSX.StreamAccount_StreamChannelI AS StreamAccountNOSX_StreamAcco31, StreamChannel.StreamChannel AS StreamChannel_StreamChannel1, SUM(StreamAccountNOSX.StreamAccount_StreamAcID) AS StreamAccountNOSX_StreamAcco2 FROM ((((CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX LEFT OUTER JOIN h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel ON StreamAccountNOSX.StreamAccount_StreamChannelI = StreamChannel.StreamChannelID) LEFT OUTER JOIN CEBanksBusinessModel.CEGlobalView AS CEGlobalView ON StreamAccountNOSX.StreamAccount_CustomerID = CEGlobalView.Customer_CustomerID) LEFT OUTER JOIN h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag ON CEGlobalView.Customer_CustomerID = CustomerTag.Customer_CustomerID AND ((CustomerTag.EndDateTime > convert(CURDATE(), timestamp)) OR (CustomerTag.EndDateTime IS NULL))) LEFT OUTER JOIN h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue ON CustomerTag.TagValue_TagValueID = TagValue.TagValueID) LEFT OUTER JOIN h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName ON TagValue.TagName_TagNameID = TagName.TagNameID AND TagName.TagType_TagTypeID = 1 AND TagName.TagScope_TagScopeID = 1 WHERE (StreamAccountNOSX.StreamAccount_DateTime4 >= '2015-07') AND (StreamAccountNOSX.StreamAccount_DateTime4 <= '2016-07') AND (TagName.TagName = 'Behavior') GROUP BY StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel ORDER BY StreamChannel_StreamChannel, StreamAccountNOSX_StreamAcco1 ---------------------------------------------------------------------------- OPTIMIZE: /*+ cache(pref_mem ttl:52689142) */ SELECT StreamAccountNOSX.StreamAccount_StreamChannelI AS StreamAccountNOSX_StreamAcco1, StreamChannel.StreamChannel AS StreamChannel_StreamChannel, SUM(StreamAccountNOSX.StreamAccount_StreamAcID) AS StreamAccountNOSX_StreamAcco, StreamAccountNOSX.StreamAccount_StreamChannelI AS StreamAccountNOSX_StreamAcco31, StreamChannel.StreamChannel AS StreamChannel_StreamChannel1, SUM(StreamAccountNOSX.StreamAccount_StreamAcID) AS StreamAccountNOSX_StreamAcco2 FROM ((((CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX LEFT OUTER JOIN h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel ON StreamAccountNOSX.StreamAccount_StreamChannelI = StreamChannel.StreamChannelID) LEFT OUTER JOIN CEBanksBusinessModel.CEGlobalView AS CEGlobalView ON StreamAccountNOSX.StreamAccount_CustomerID = CEGlobalView.Customer_CustomerID) LEFT OUTER JOIN h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag ON CEGlobalView.Customer_CustomerID = CustomerTag.Customer_CustomerID AND ((CustomerTag.EndDateTime > convert(CURDATE(), timestamp)) OR (CustomerTag.EndDateTime IS NULL))) LEFT OUTER JOIN h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue ON CustomerTag.TagValue_TagValueID = TagValue.TagValueID) LEFT OUTER JOIN h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName ON TagValue.TagName_TagNameID = TagName.TagNameID AND TagName.TagType_TagTypeID = 1 AND TagName.TagScope_TagScopeID = 1 WHERE (StreamAccountNOSX.StreamAccount_DateTime4 >= '2015-07') AND (StreamAccountNOSX.StreamAccount_DateTime4 <= '2016-07') AND (TagName.TagName = 'Behavior') GROUP BY StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel ORDER BY StreamChannel_StreamChannel, StreamAccountNOSX_StreamAcco1 ---------------------------------------------------------------------------- GENERATE CANONICAL: /*+ cache(pref_mem ttl:52689142) */ SELECT StreamAccountNOSX.StreamAccount_StreamChannelI AS StreamAccountNOSX_StreamAcco1, StreamChannel.StreamChannel AS StreamChannel_StreamChannel, SUM(StreamAccountNOSX.StreamAccount_StreamAcID) AS StreamAccountNOSX_StreamAcco, StreamAccountNOSX.StreamAccount_StreamChannelI AS StreamAccountNOSX_StreamAcco31, StreamChannel.StreamChannel AS StreamChannel_StreamChannel1, SUM(StreamAccountNOSX.StreamAccount_StreamAcID) AS StreamAccountNOSX_StreamAcco2 FROM ((((CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX LEFT OUTER JOIN h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel ON StreamAccountNOSX.StreamAccount_StreamChannelI = StreamChannel.StreamChannelID) LEFT OUTER JOIN CEBanksBusinessModel.CEGlobalView AS CEGlobalView ON StreamAccountNOSX.StreamAccount_CustomerID = CEGlobalView.Customer_CustomerID) LEFT OUTER JOIN h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag ON CEGlobalView.Customer_CustomerID = CustomerTag.Customer_CustomerID AND ((CustomerTag.EndDateTime > convert(CURDATE(), timestamp)) OR (CustomerTag.EndDateTime IS NULL))) LEFT OUTER JOIN h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue ON CustomerTag.TagValue_TagValueID = TagValue.TagValueID) LEFT OUTER JOIN h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName ON TagValue.TagName_TagNameID = TagName.TagNameID AND TagName.TagType_TagTypeID = 1 AND TagName.TagScope_TagScopeID = 1 WHERE (StreamAccountNOSX.StreamAccount_DateTime4 >= '2015-07') AND (StreamAccountNOSX.StreamAccount_DateTime4 <= '2016-07') AND (TagName.TagName = 'Behavior') GROUP BY StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel ORDER BY StreamChannel_StreamChannel, StreamAccountNOSX_StreamAcco1 LOW [Materialized View] The query against CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX was redirected to the materialization table h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX. - null LOW [Materialized View] The query against CEBanksBusinessModel.CEGlobalView AS CEGlobalView was redirected to the materialization table h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView. - null CANONICAL PLAN: Sort(groups=[anon_grp0], props={SORT_ORDER=ORDER BY StreamChannel_StreamChannel, StreamAccountNOSX_StreamAcco1}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco1, anon_grp0.gcol3 AS StreamChannel_StreamChannel, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco, anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco31, anon_grp0.gcol3 AS StreamChannel_StreamChannel1, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco2]}) Group(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX, anon_grp0], props={GROUP_COLS=[StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel], SYMBOL_MAP={anon_grp0.gcol0=StreamAccountNOSX.StreamAccount_StreamChannelI, anon_grp0.gcol1=StreamChannel.StreamChannel, anon_grp0.gcol2=StreamAccountNOSX.StreamAccount_StreamChannelI, anon_grp0.gcol3=StreamChannel.StreamChannel, anon_grp0.agg0=SUM(StreamAccountNOSX.StreamAccount_StreamAcID)}}) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={SELECT_CRITERIA=TagName.TagName = 'Behavior'}) Select(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX], props={SELECT_CRITERIA=StreamAccountNOSX.StreamAccount_DateTime4 <= '2016-07'}) Select(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX], props={SELECT_CRITERIA=StreamAccountNOSX.StreamAccount_DateTime4 >= '2015-07'}) Join(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX, h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, CEBanksBusinessModel.CEGlobalView AS CEGlobalView, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TagValue.TagName_TagNameID = TagName.TagNameID, TagName.TagType_TagTypeID = 1, TagName.TagScope_TagScopeID = 1]}) Join(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX, h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, CEBanksBusinessModel.CEGlobalView AS CEGlobalView, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[CustomerTag.TagValue_TagValueID = TagValue.TagValueID]}) Join(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX, h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, CEBanksBusinessModel.CEGlobalView AS CEGlobalView, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[CEGlobalView.Customer_CustomerID = CustomerTag.Customer_CustomerID, (CustomerTag.EndDateTime > convert(CURDATE(), timestamp)) OR (CustomerTag.EndDateTime IS NULL)]}) Join(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX, h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, CEBanksBusinessModel.CEGlobalView AS CEGlobalView], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[StreamAccountNOSX.StreamAccount_CustomerID = CEGlobalView.Customer_CustomerID]}) Join(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX, h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[StreamAccountNOSX.StreamAccount_StreamChannelI = StreamChannel.StreamChannelID]}) Source(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX], props={NESTED_COMMAND=SELECT StreamAccount_CustomerID, StreamAccount_Amount, StreamAccount_StreamAcID, StreamAccount_DateTime, StreamAccount_Account, StreamAccount_BranchID, StreamAccount_CurrencyID, StreamAccount_OfficerID, StreamAccount_ProductID, StreamAccount_StreamChannelI, StreamAccount_StreamTypeID, StreamAccount_DateTime1, StreamAccount_DateTime2, StreamAccount_DateTime3, StreamAccount_DateTime4 FROM h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, SYMBOL_MAP={StreamAccountNOSX.StreamAccount_CustomerID=StreamAccount_CustomerID, StreamAccountNOSX.StreamAccount_Amount=StreamAccount_Amount, StreamAccountNOSX.StreamAccount_StreamAcID=StreamAccount_StreamAcID, StreamAccountNOSX.StreamAccount_DateTime=StreamAccount_DateTime, StreamAccountNOSX.StreamAccount_Account=StreamAccount_Account, StreamAccountNOSX.StreamAccount_BranchID=StreamAccount_BranchID, StreamAccountNOSX.StreamAccount_CurrencyID=StreamAccount_CurrencyID, StreamAccountNOSX.StreamAccount_OfficerID=StreamAccount_OfficerID, StreamAccountNOSX.StreamAccount_ProductID=StreamAccount_ProductID, StreamAccountNOSX.StreamAccount_StreamChannelI=StreamAccount_StreamChannelI, StreamAccountNOSX.StreamAccount_StreamTypeID=StreamAccount_StreamTypeID, StreamAccountNOSX.StreamAccount_DateTime1=StreamAccount_DateTime1, StreamAccountNOSX.StreamAccount_DateTime2=StreamAccount_DateTime2, StreamAccountNOSX.StreamAccount_DateTime3=StreamAccount_DateTime3, StreamAccountNOSX.StreamAccount_DateTime4=StreamAccount_DateTime4}}) Project(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={PROJECT_COLS=[StreamAccount_CustomerID, StreamAccount_Amount, StreamAccount_StreamAcID, StreamAccount_DateTime, StreamAccount_Account, StreamAccount_BranchID, StreamAccount_CurrencyID, StreamAccount_OfficerID, StreamAccount_ProductID, StreamAccount_StreamChannelI, StreamAccount_StreamTypeID, StreamAccount_DateTime1, StreamAccount_DateTime2, StreamAccount_DateTime3, StreamAccount_DateTime4]}) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel]) Source(groups=[CEBanksBusinessModel.CEGlobalView AS CEGlobalView], props={NESTED_COMMAND=SELECT Customer_BirthDate, Customer_CustomerID, Customer_Email, Customer_FirstName, Customer_IDstring, Customer_IsCorporate, Customer_LastName, Customer_Mobile, Customer_Name, Customer_NationalID, Customer_Photo, Customer_StartDate, Customer_AddressID, Customer_BranchID, Customer_ChurnProbability, Customer_CityID, Customer_CountryID, Customer_Dependents, Customer_GenderID, Customer_IDint, Customer_MaritalStatusID, Customer_MonthlyIncome, Customer_OccupationID, CalculatedField, CalculatedField1, CalculatedField2, CalculatedField3, CalculatedField4, CalculatedField5, CalculatedField6, CalculatedField7, CalculatedField8, CalculatedField9, CalculatedField10, CalculatedField11, CalculatedField12, CalculatedField13, CalculatedField15, StreamCards_DateTime, StreamAccount_DateTime, StreamLoans_DateTime, StreamCardsvt3r_StreamCards_, StreamCardsvt3r_StreamCards_1, RecomProduct_ProductID, AgeSegments_BMM_170616_AgeSe, AgeSegments_BMM_170616_Segme FROM h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView, SYMBOL_MAP={CEGlobalView.Customer_BirthDate=Customer_BirthDate, CEGlobalView.Customer_CustomerID=Customer_CustomerID, CEGlobalView.Customer_Email=Customer_Email, CEGlobalView.Customer_FirstName=Customer_FirstName, CEGlobalView.Customer_IDstring=Customer_IDstring, CEGlobalView.Customer_IsCorporate=Customer_IsCorporate, CEGlobalView.Customer_LastName=Customer_LastName, CEGlobalView.Customer_Mobile=Customer_Mobile, CEGlobalView.Customer_Name=Customer_Name, CEGlobalView.Customer_NationalID=Customer_NationalID, CEGlobalView.Customer_Photo=Customer_Photo, CEGlobalView.Customer_StartDate=Customer_StartDate, CEGlobalView.Customer_AddressID=Customer_AddressID, CEGlobalView.Customer_BranchID=Customer_BranchID, CEGlobalView.Customer_ChurnProbability=Customer_ChurnProbability, CEGlobalView.Customer_CityID=Customer_CityID, CEGlobalView.Customer_CountryID=Customer_CountryID, CEGlobalView.Customer_Dependents=Customer_Dependents, CEGlobalView.Customer_GenderID=Customer_GenderID, CEGlobalView.Customer_IDint=Customer_IDint, CEGlobalView.Customer_MaritalStatusID=Customer_MaritalStatusID, CEGlobalView.Customer_MonthlyIncome=Customer_MonthlyIncome, CEGlobalView.Customer_OccupationID=Customer_OccupationID, CEGlobalView.CalculatedField=CalculatedField, CEGlobalView.CalculatedField1=CalculatedField1, CEGlobalView.CalculatedField2=CalculatedField2, CEGlobalView.CalculatedField3=CalculatedField3, CEGlobalView.CalculatedField4=CalculatedField4, CEGlobalView.CalculatedField5=CalculatedField5, CEGlobalView.CalculatedField6=CalculatedField6, CEGlobalView.CalculatedField7=CalculatedField7, CEGlobalView.CalculatedField8=CalculatedField8, CEGlobalView.CalculatedField9=CalculatedField9, CEGlobalView.CalculatedField10=CalculatedField10, CEGlobalView.CalculatedField11=CalculatedField11, CEGlobalView.CalculatedField12=CalculatedField12, CEGlobalView.CalculatedField13=CalculatedField13, CEGlobalView.CalculatedField15=CalculatedField15, CEGlobalView.StreamCards_DateTime=StreamCards_DateTime, CEGlobalView.StreamAccount_DateTime=StreamAccount_DateTime, CEGlobalView.StreamLoans_DateTime=StreamLoans_DateTime, CEGlobalView.StreamCardsvt3r_StreamCards_=StreamCardsvt3r_StreamCards_, CEGlobalView.StreamCardsvt3r_StreamCards_1=StreamCardsvt3r_StreamCards_1, CEGlobalView.RecomProduct_ProductID=RecomProduct_ProductID, CEGlobalView.AgeSegments_BMM_170616_AgeSe=AgeSegments_BMM_170616_AgeSe, CEGlobalView.AgeSegments_BMM_170616_Segme=AgeSegments_BMM_170616_Segme}}) Project(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={PROJECT_COLS=[Customer_BirthDate, Customer_CustomerID, Customer_Email, Customer_FirstName, Customer_IDstring, Customer_IsCorporate, Customer_LastName, Customer_Mobile, Customer_Name, Customer_NationalID, Customer_Photo, Customer_StartDate, Customer_AddressID, Customer_BranchID, Customer_ChurnProbability, Customer_CityID, Customer_CountryID, Customer_Dependents, Customer_GenderID, Customer_IDint, Customer_MaritalStatusID, Customer_MonthlyIncome, Customer_OccupationID, CalculatedField, CalculatedField1, CalculatedField2, CalculatedField3, CalculatedField4, CalculatedField5, CalculatedField6, CalculatedField7, CalculatedField8, CalculatedField9, CalculatedField10, CalculatedField11, CalculatedField12, CalculatedField13, CalculatedField15, StreamCards_DateTime, StreamAccount_DateTime, StreamLoans_DateTime, StreamCardsvt3r_StreamCards_, StreamCardsvt3r_StreamCards_1, RecomProduct_ProductID, AgeSegments_BMM_170616_AgeSe, AgeSegments_BMM_170616_Segme]}) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) ============================================================================ EXECUTING PlaceAccess AFTER: Sort(groups=[anon_grp0], props={SORT_ORDER=ORDER BY StreamChannel_StreamChannel, StreamAccountNOSX_StreamAcco1}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco1, anon_grp0.gcol3 AS StreamChannel_StreamChannel, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco, anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco31, anon_grp0.gcol3 AS StreamChannel_StreamChannel1, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco2]}) Group(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX, anon_grp0], props={GROUP_COLS=[StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel], SYMBOL_MAP={anon_grp0.gcol0=StreamAccountNOSX.StreamAccount_StreamChannelI, anon_grp0.gcol1=StreamChannel.StreamChannel, anon_grp0.gcol2=StreamAccountNOSX.StreamAccount_StreamChannelI, anon_grp0.gcol3=StreamChannel.StreamChannel, anon_grp0.agg0=SUM(StreamAccountNOSX.StreamAccount_StreamAcID)}}) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={SELECT_CRITERIA=TagName.TagName = 'Behavior'}) Select(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX], props={SELECT_CRITERIA=StreamAccountNOSX.StreamAccount_DateTime4 <= '2016-07'}) Select(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX], props={SELECT_CRITERIA=StreamAccountNOSX.StreamAccount_DateTime4 >= '2015-07'}) Join(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX, h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, CEBanksBusinessModel.CEGlobalView AS CEGlobalView, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TagValue.TagName_TagNameID = TagName.TagNameID, TagName.TagType_TagTypeID = 1, TagName.TagScope_TagScopeID = 1]}) Join(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX, h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, CEBanksBusinessModel.CEGlobalView AS CEGlobalView, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[CustomerTag.TagValue_TagValueID = TagValue.TagValueID]}) Join(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX, h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, CEBanksBusinessModel.CEGlobalView AS CEGlobalView, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[CEGlobalView.Customer_CustomerID = CustomerTag.Customer_CustomerID, (CustomerTag.EndDateTime > convert(CURDATE(), timestamp)) OR (CustomerTag.EndDateTime IS NULL)]}) Join(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX, h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, CEBanksBusinessModel.CEGlobalView AS CEGlobalView], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[StreamAccountNOSX.StreamAccount_CustomerID = CEGlobalView.Customer_CustomerID]}) Join(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX, h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[StreamAccountNOSX.StreamAccount_StreamChannelI = StreamChannel.StreamChannelID]}) Source(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX], props={NESTED_COMMAND=SELECT StreamAccount_CustomerID, StreamAccount_Amount, StreamAccount_StreamAcID, StreamAccount_DateTime, StreamAccount_Account, StreamAccount_BranchID, StreamAccount_CurrencyID, StreamAccount_OfficerID, StreamAccount_ProductID, StreamAccount_StreamChannelI, StreamAccount_StreamTypeID, StreamAccount_DateTime1, StreamAccount_DateTime2, StreamAccount_DateTime3, StreamAccount_DateTime4 FROM h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, SYMBOL_MAP={StreamAccountNOSX.StreamAccount_CustomerID=StreamAccount_CustomerID, StreamAccountNOSX.StreamAccount_Amount=StreamAccount_Amount, StreamAccountNOSX.StreamAccount_StreamAcID=StreamAccount_StreamAcID, StreamAccountNOSX.StreamAccount_DateTime=StreamAccount_DateTime, StreamAccountNOSX.StreamAccount_Account=StreamAccount_Account, StreamAccountNOSX.StreamAccount_BranchID=StreamAccount_BranchID, StreamAccountNOSX.StreamAccount_CurrencyID=StreamAccount_CurrencyID, StreamAccountNOSX.StreamAccount_OfficerID=StreamAccount_OfficerID, StreamAccountNOSX.StreamAccount_ProductID=StreamAccount_ProductID, StreamAccountNOSX.StreamAccount_StreamChannelI=StreamAccount_StreamChannelI, StreamAccountNOSX.StreamAccount_StreamTypeID=StreamAccount_StreamTypeID, StreamAccountNOSX.StreamAccount_DateTime1=StreamAccount_DateTime1, StreamAccountNOSX.StreamAccount_DateTime2=StreamAccount_DateTime2, StreamAccountNOSX.StreamAccount_DateTime3=StreamAccount_DateTime3, StreamAccountNOSX.StreamAccount_DateTime4=StreamAccount_DateTime4}}) Project(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={PROJECT_COLS=[StreamAccount_CustomerID, StreamAccount_Amount, StreamAccount_StreamAcID, StreamAccount_DateTime, StreamAccount_Account, StreamAccount_BranchID, StreamAccount_CurrencyID, StreamAccount_OfficerID, StreamAccount_ProductID, StreamAccount_StreamChannelI, StreamAccount_StreamTypeID, StreamAccount_DateTime1, StreamAccount_DateTime2, StreamAccount_DateTime3, StreamAccount_DateTime4]}) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_ST, nameInSource=null, uuid=tid:c8889da6a91d-23ce207f-00000000}) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel]) Source(groups=[CEBanksBusinessModel.CEGlobalView AS CEGlobalView], props={NESTED_COMMAND=SELECT Customer_BirthDate, Customer_CustomerID, Customer_Email, Customer_FirstName, Customer_IDstring, Customer_IsCorporate, Customer_LastName, Customer_Mobile, Customer_Name, Customer_NationalID, Customer_Photo, Customer_StartDate, Customer_AddressID, Customer_BranchID, Customer_ChurnProbability, Customer_CityID, Customer_CountryID, Customer_Dependents, Customer_GenderID, Customer_IDint, Customer_MaritalStatusID, Customer_MonthlyIncome, Customer_OccupationID, CalculatedField, CalculatedField1, CalculatedField2, CalculatedField3, CalculatedField4, CalculatedField5, CalculatedField6, CalculatedField7, CalculatedField8, CalculatedField9, CalculatedField10, CalculatedField11, CalculatedField12, CalculatedField13, CalculatedField15, StreamCards_DateTime, StreamAccount_DateTime, StreamLoans_DateTime, StreamCardsvt3r_StreamCards_, StreamCardsvt3r_StreamCards_1, RecomProduct_ProductID, AgeSegments_BMM_170616_AgeSe, AgeSegments_BMM_170616_Segme FROM h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView, SYMBOL_MAP={CEGlobalView.Customer_BirthDate=Customer_BirthDate, CEGlobalView.Customer_CustomerID=Customer_CustomerID, CEGlobalView.Customer_Email=Customer_Email, CEGlobalView.Customer_FirstName=Customer_FirstName, CEGlobalView.Customer_IDstring=Customer_IDstring, CEGlobalView.Customer_IsCorporate=Customer_IsCorporate, CEGlobalView.Customer_LastName=Customer_LastName, CEGlobalView.Customer_Mobile=Customer_Mobile, CEGlobalView.Customer_Name=Customer_Name, CEGlobalView.Customer_NationalID=Customer_NationalID, CEGlobalView.Customer_Photo=Customer_Photo, CEGlobalView.Customer_StartDate=Customer_StartDate, CEGlobalView.Customer_AddressID=Customer_AddressID, CEGlobalView.Customer_BranchID=Customer_BranchID, CEGlobalView.Customer_ChurnProbability=Customer_ChurnProbability, CEGlobalView.Customer_CityID=Customer_CityID, CEGlobalView.Customer_CountryID=Customer_CountryID, CEGlobalView.Customer_Dependents=Customer_Dependents, CEGlobalView.Customer_GenderID=Customer_GenderID, CEGlobalView.Customer_IDint=Customer_IDint, CEGlobalView.Customer_MaritalStatusID=Customer_MaritalStatusID, CEGlobalView.Customer_MonthlyIncome=Customer_MonthlyIncome, CEGlobalView.Customer_OccupationID=Customer_OccupationID, CEGlobalView.CalculatedField=CalculatedField, CEGlobalView.CalculatedField1=CalculatedField1, CEGlobalView.CalculatedField2=CalculatedField2, CEGlobalView.CalculatedField3=CalculatedField3, CEGlobalView.CalculatedField4=CalculatedField4, CEGlobalView.CalculatedField5=CalculatedField5, CEGlobalView.CalculatedField6=CalculatedField6, CEGlobalView.CalculatedField7=CalculatedField7, CEGlobalView.CalculatedField8=CalculatedField8, CEGlobalView.CalculatedField9=CalculatedField9, CEGlobalView.CalculatedField10=CalculatedField10, CEGlobalView.CalculatedField11=CalculatedField11, CEGlobalView.CalculatedField12=CalculatedField12, CEGlobalView.CalculatedField13=CalculatedField13, CEGlobalView.CalculatedField15=CalculatedField15, CEGlobalView.StreamCards_DateTime=StreamCards_DateTime, CEGlobalView.StreamAccount_DateTime=StreamAccount_DateTime, CEGlobalView.StreamLoans_DateTime=StreamLoans_DateTime, CEGlobalView.StreamCardsvt3r_StreamCards_=StreamCardsvt3r_StreamCards_, CEGlobalView.StreamCardsvt3r_StreamCards_1=StreamCardsvt3r_StreamCards_1, CEGlobalView.RecomProduct_ProductID=RecomProduct_ProductID, CEGlobalView.AgeSegments_BMM_170616_AgeSe=AgeSegments_BMM_170616_AgeSe, CEGlobalView.AgeSegments_BMM_170616_Segme=AgeSegments_BMM_170616_Segme}}) Project(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={PROJECT_COLS=[Customer_BirthDate, Customer_CustomerID, Customer_Email, Customer_FirstName, Customer_IDstring, Customer_IsCorporate, Customer_LastName, Customer_Mobile, Customer_Name, Customer_NationalID, Customer_Photo, Customer_StartDate, Customer_AddressID, Customer_BranchID, Customer_ChurnProbability, Customer_CityID, Customer_CountryID, Customer_Dependents, Customer_GenderID, Customer_IDint, Customer_MaritalStatusID, Customer_MonthlyIncome, Customer_OccupationID, CalculatedField, CalculatedField1, CalculatedField2, CalculatedField3, CalculatedField4, CalculatedField5, CalculatedField6, CalculatedField7, CalculatedField8, CalculatedField9, CalculatedField10, CalculatedField11, CalculatedField12, CalculatedField13, CalculatedField15, StreamCards_DateTime, StreamAccount_DateTime, StreamLoans_DateTime, StreamCardsvt3r_StreamCards_, StreamCardsvt3r_StreamCards_1, RecomProduct_ProductID, AgeSegments_BMM_170616_AgeSe, AgeSegments_BMM_170616_Segme]}) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_ST, nameInSource=null, uuid=tid:c8889da6a91d-23ce207f-00000000}) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) ============================================================================ EXECUTING AssignOutputElements AFTER: Sort(groups=[anon_grp0], props={SORT_ORDER=ORDER BY StreamChannel_StreamChannel, StreamAccountNOSX_StreamAcco1, OUTPUT_COLS=[anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco1, anon_grp0.gcol3 AS StreamChannel_StreamChannel, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco, anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco31, anon_grp0.gcol3 AS StreamChannel_StreamChannel1, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco2], UNRELATED_SORT=false}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco1, anon_grp0.gcol3 AS StreamChannel_StreamChannel, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco, anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco31, anon_grp0.gcol3 AS StreamChannel_StreamChannel1, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco2], OUTPUT_COLS=[anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco1, anon_grp0.gcol3 AS StreamChannel_StreamChannel, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco, anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco31, anon_grp0.gcol3 AS StreamChannel_StreamChannel1, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco2]}) Group(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX, anon_grp0], props={GROUP_COLS=[StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel], SYMBOL_MAP={anon_grp0.gcol0=StreamAccountNOSX.StreamAccount_StreamChannelI, anon_grp0.gcol1=StreamChannel.StreamChannel, anon_grp0.gcol2=StreamAccountNOSX.StreamAccount_StreamChannelI, anon_grp0.gcol3=StreamChannel.StreamChannel, anon_grp0.agg0=SUM(StreamAccountNOSX.StreamAccount_StreamAcID)}, OUTPUT_COLS=[anon_grp0.gcol2, anon_grp0.gcol3, anon_grp0.agg0]}) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={SELECT_CRITERIA=TagName.TagName = 'Behavior', OUTPUT_COLS=[StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID]}) Select(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX], props={SELECT_CRITERIA=StreamAccountNOSX.StreamAccount_DateTime4 <= '2016-07', OUTPUT_COLS=[TagName.TagName, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID]}) Select(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX], props={SELECT_CRITERIA=StreamAccountNOSX.StreamAccount_DateTime4 >= '2015-07', OUTPUT_COLS=[StreamAccountNOSX.StreamAccount_DateTime4, TagName.TagName, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID]}) Join(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX, h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, CEBanksBusinessModel.CEGlobalView AS CEGlobalView, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TagValue.TagName_TagNameID = TagName.TagNameID, TagName.TagType_TagTypeID = 1, TagName.TagScope_TagScopeID = 1], OUTPUT_COLS=[StreamAccountNOSX.StreamAccount_DateTime4, TagName.TagName, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID]}) Join(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX, h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, CEBanksBusinessModel.CEGlobalView AS CEGlobalView, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[CustomerTag.TagValue_TagValueID = TagValue.TagValueID], OUTPUT_COLS=[TagValue.TagName_TagNameID, StreamAccountNOSX.StreamAccount_DateTime4, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID]}) Join(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX, h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, CEBanksBusinessModel.CEGlobalView AS CEGlobalView, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[CEGlobalView.Customer_CustomerID = CustomerTag.Customer_CustomerID, (CustomerTag.EndDateTime > convert(CURDATE(), timestamp)) OR (CustomerTag.EndDateTime IS NULL)], OUTPUT_COLS=[CustomerTag.TagValue_TagValueID, StreamAccountNOSX.StreamAccount_DateTime4, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID]}) Join(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX, h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, CEBanksBusinessModel.CEGlobalView AS CEGlobalView], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[StreamAccountNOSX.StreamAccount_CustomerID = CEGlobalView.Customer_CustomerID], OUTPUT_COLS=[CEGlobalView.Customer_CustomerID, StreamAccountNOSX.StreamAccount_DateTime4, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID]}) Join(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX, h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[StreamAccountNOSX.StreamAccount_StreamChannelI = StreamChannel.StreamChannelID], OUTPUT_COLS=[StreamAccountNOSX.StreamAccount_CustomerID, StreamAccountNOSX.StreamAccount_DateTime4, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID]}) Source(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX], props={NESTED_COMMAND=SELECT StreamAccount_CustomerID, StreamAccount_Amount, StreamAccount_StreamAcID, StreamAccount_DateTime, StreamAccount_Account, StreamAccount_BranchID, StreamAccount_CurrencyID, StreamAccount_OfficerID, StreamAccount_ProductID, StreamAccount_StreamChannelI, StreamAccount_StreamTypeID, StreamAccount_DateTime1, StreamAccount_DateTime2, StreamAccount_DateTime3, StreamAccount_DateTime4 FROM h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, SYMBOL_MAP={StreamAccountNOSX.StreamAccount_StreamChannelI=StreamAccount_StreamChannelI, StreamAccountNOSX.StreamAccount_CustomerID=StreamAccount_CustomerID, StreamAccountNOSX.StreamAccount_DateTime4=StreamAccount_DateTime4, StreamAccountNOSX.StreamAccount_StreamAcID=StreamAccount_StreamAcID}, OUTPUT_COLS=[StreamAccountNOSX.StreamAccount_StreamChannelI, StreamAccountNOSX.StreamAccount_CustomerID, StreamAccountNOSX.StreamAccount_DateTime4, StreamAccountNOSX.StreamAccount_StreamAcID]}) Project(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={PROJECT_COLS=[StreamAccount_StreamChannelI, StreamAccount_CustomerID, StreamAccount_DateTime4, StreamAccount_StreamAcID], OUTPUT_COLS=[StreamAccount_StreamChannelI, StreamAccount_CustomerID, StreamAccount_DateTime4, StreamAccount_StreamAcID]}) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_ST, nameInSource=null, uuid=tid:c8889da6a91d-23ce207f-00000000, OUTPUT_COLS=[StreamAccount_StreamChannelI, StreamAccount_CustomerID, StreamAccount_DateTime4, StreamAccount_StreamAcID]}) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={OUTPUT_COLS=[StreamAccount_StreamChannelI, StreamAccount_CustomerID, StreamAccount_DateTime4, StreamAccount_StreamAcID]}) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=[StreamChannel.StreamChannelID, StreamChannel.StreamChannel]}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel], props={OUTPUT_COLS=[StreamChannel.StreamChannelID, StreamChannel.StreamChannel]}) Source(groups=[CEBanksBusinessModel.CEGlobalView AS CEGlobalView], props={NESTED_COMMAND=SELECT Customer_BirthDate, Customer_CustomerID, Customer_Email, Customer_FirstName, Customer_IDstring, Customer_IsCorporate, Customer_LastName, Customer_Mobile, Customer_Name, Customer_NationalID, Customer_Photo, Customer_StartDate, Customer_AddressID, Customer_BranchID, Customer_ChurnProbability, Customer_CityID, Customer_CountryID, Customer_Dependents, Customer_GenderID, Customer_IDint, Customer_MaritalStatusID, Customer_MonthlyIncome, Customer_OccupationID, CalculatedField, CalculatedField1, CalculatedField2, CalculatedField3, CalculatedField4, CalculatedField5, CalculatedField6, CalculatedField7, CalculatedField8, CalculatedField9, CalculatedField10, CalculatedField11, CalculatedField12, CalculatedField13, CalculatedField15, StreamCards_DateTime, StreamAccount_DateTime, StreamLoans_DateTime, StreamCardsvt3r_StreamCards_, StreamCardsvt3r_StreamCards_1, RecomProduct_ProductID, AgeSegments_BMM_170616_AgeSe, AgeSegments_BMM_170616_Segme FROM h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView, SYMBOL_MAP={CEGlobalView.Customer_CustomerID=Customer_CustomerID}, OUTPUT_COLS=[CEGlobalView.Customer_CustomerID]}) Project(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={PROJECT_COLS=[Customer_CustomerID], OUTPUT_COLS=[Customer_CustomerID]}) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_ST, nameInSource=null, uuid=tid:c8889da6a91d-23ce207f-00000000, OUTPUT_COLS=[Customer_CustomerID]}) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={OUTPUT_COLS=[Customer_CustomerID]}) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=[CustomerTag.Customer_CustomerID, CustomerTag.EndDateTime, CustomerTag.TagValue_TagValueID]}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={OUTPUT_COLS=[CustomerTag.Customer_CustomerID, CustomerTag.EndDateTime, CustomerTag.TagValue_TagValueID]}) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=[TagValue.TagValueID, TagValue.TagName_TagNameID]}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue], props={OUTPUT_COLS=[TagValue.TagValueID, TagValue.TagName_TagNameID]}) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=[TagName.TagNameID, TagName.TagType_TagTypeID, TagName.TagScope_TagScopeID, TagName.TagName]}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={OUTPUT_COLS=[TagName.TagNameID, TagName.TagType_TagTypeID, TagName.TagScope_TagScopeID, TagName.TagName]}) ============================================================================ EXECUTING RemoveOptionalJoins AFTER: Sort(groups=[anon_grp0]) Project(groups=[anon_grp0]) Group(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX, anon_grp0]) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={SELECT_CRITERIA=TagName.TagName = 'Behavior', OUTPUT_COLS=[StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID]}) Select(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX]) Select(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX]) Join(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX, h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, CEBanksBusinessModel.CEGlobalView AS CEGlobalView, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TagValue.TagName_TagNameID = TagName.TagNameID, TagName.TagType_TagTypeID = 1, TagName.TagScope_TagScopeID = 1], OUTPUT_COLS=[StreamAccountNOSX.StreamAccount_DateTime4, TagName.TagName, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID]}) Join(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX, h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, CEBanksBusinessModel.CEGlobalView AS CEGlobalView, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[CustomerTag.TagValue_TagValueID = TagValue.TagValueID], OUTPUT_COLS=[TagValue.TagName_TagNameID, StreamAccountNOSX.StreamAccount_DateTime4, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID]}) Join(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX, h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, CEBanksBusinessModel.CEGlobalView AS CEGlobalView, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[CEGlobalView.Customer_CustomerID = CustomerTag.Customer_CustomerID, (CustomerTag.EndDateTime > convert(CURDATE(), timestamp)) OR (CustomerTag.EndDateTime IS NULL)], OUTPUT_COLS=[CustomerTag.TagValue_TagValueID, StreamAccountNOSX.StreamAccount_DateTime4, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID]}) Join(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX, h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, CEBanksBusinessModel.CEGlobalView AS CEGlobalView], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[StreamAccountNOSX.StreamAccount_CustomerID = CEGlobalView.Customer_CustomerID], OUTPUT_COLS=[CEGlobalView.Customer_CustomerID, StreamAccountNOSX.StreamAccount_DateTime4, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID]}) Join(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX, h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[StreamAccountNOSX.StreamAccount_StreamChannelI = StreamChannel.StreamChannelID], OUTPUT_COLS=[StreamAccountNOSX.StreamAccount_CustomerID, StreamAccountNOSX.StreamAccount_DateTime4, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID]}) Source(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX]) Project(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_ST, nameInSource=null, uuid=tid:c8889da6a91d-23ce207f-00000000, OUTPUT_COLS=[StreamAccount_StreamChannelI, StreamAccount_CustomerID, StreamAccount_DateTime4, StreamAccount_StreamAcID]}) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel]) Source(groups=[CEBanksBusinessModel.CEGlobalView AS CEGlobalView]) Project(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView]) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_ST, nameInSource=null, uuid=tid:c8889da6a91d-23ce207f-00000000, OUTPUT_COLS=[Customer_CustomerID]}) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) ============================================================================ EXECUTING PushSelectCriteria AFTER: Sort(groups=[anon_grp0]) Project(groups=[anon_grp0]) Group(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX, anon_grp0], props={GROUP_COLS=[StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel], SYMBOL_MAP={anon_grp0.gcol0=StreamAccountNOSX.StreamAccount_StreamChannelI, anon_grp0.gcol1=StreamChannel.StreamChannel, anon_grp0.gcol2=StreamAccountNOSX.StreamAccount_StreamChannelI, anon_grp0.gcol3=StreamChannel.StreamChannel, anon_grp0.agg0=SUM(StreamAccountNOSX.StreamAccount_StreamAcID)}, OUTPUT_COLS=[anon_grp0.gcol2, anon_grp0.gcol3, anon_grp0.agg0]}) Join(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX, h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, CEBanksBusinessModel.CEGlobalView AS CEGlobalView, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TagValue.TagName_TagNameID = TagName.TagNameID, TagName.TagType_TagTypeID = 1, TagName.TagScope_TagScopeID = 1], OUTPUT_COLS=[StreamAccountNOSX.StreamAccount_DateTime4, TagName.TagName, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID]}) Join(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX, h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, CEBanksBusinessModel.CEGlobalView AS CEGlobalView, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[CustomerTag.TagValue_TagValueID = TagValue.TagValueID], OUTPUT_COLS=[TagValue.TagName_TagNameID, StreamAccountNOSX.StreamAccount_DateTime4, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID]}) Join(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX, h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, CEBanksBusinessModel.CEGlobalView AS CEGlobalView, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[CEGlobalView.Customer_CustomerID = CustomerTag.Customer_CustomerID, (CustomerTag.EndDateTime > convert(CURDATE(), timestamp)) OR (CustomerTag.EndDateTime IS NULL)], OUTPUT_COLS=[CustomerTag.TagValue_TagValueID, StreamAccountNOSX.StreamAccount_DateTime4, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID]}) Join(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX, h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, CEBanksBusinessModel.CEGlobalView AS CEGlobalView], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[StreamAccountNOSX.StreamAccount_CustomerID = CEGlobalView.Customer_CustomerID], OUTPUT_COLS=[CEGlobalView.Customer_CustomerID, StreamAccountNOSX.StreamAccount_DateTime4, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID]}) Join(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX, h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[StreamAccountNOSX.StreamAccount_StreamChannelI = StreamChannel.StreamChannelID], OUTPUT_COLS=[StreamAccountNOSX.StreamAccount_CustomerID, StreamAccountNOSX.StreamAccount_DateTime4, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID]}) Select(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX], props={SELECT_CRITERIA=StreamAccountNOSX.StreamAccount_DateTime4 <= '2016-07', OUTPUT_COLS=[TagName.TagName, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID], IS_PHANTOM=true}) Select(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX], props={SELECT_CRITERIA=StreamAccountNOSX.StreamAccount_DateTime4 >= '2015-07', OUTPUT_COLS=[StreamAccountNOSX.StreamAccount_DateTime4, TagName.TagName, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID], IS_PHANTOM=true}) Source(groups=[CEBanksBusinessModel.StreamAccountNOSX AS StreamAccountNOSX], props={NESTED_COMMAND=SELECT StreamAccount_CustomerID, StreamAccount_Amount, StreamAccount_StreamAcID, StreamAccount_DateTime, StreamAccount_Account, StreamAccount_BranchID, StreamAccount_CurrencyID, StreamAccount_OfficerID, StreamAccount_ProductID, StreamAccount_StreamChannelI, StreamAccount_StreamTypeID, StreamAccount_DateTime1, StreamAccount_DateTime2, StreamAccount_DateTime3, StreamAccount_DateTime4 FROM h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, SYMBOL_MAP={StreamAccountNOSX.StreamAccount_StreamChannelI=StreamAccount_StreamChannelI, StreamAccountNOSX.StreamAccount_CustomerID=StreamAccount_CustomerID, StreamAccountNOSX.StreamAccount_DateTime4=StreamAccount_DateTime4, StreamAccountNOSX.StreamAccount_StreamAcID=StreamAccount_StreamAcID}, OUTPUT_COLS=[StreamAccountNOSX.StreamAccount_StreamChannelI, StreamAccountNOSX.StreamAccount_CustomerID, StreamAccountNOSX.StreamAccount_DateTime4, StreamAccountNOSX.StreamAccount_StreamAcID]}) Project(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={PROJECT_COLS=[StreamAccount_StreamChannelI, StreamAccount_CustomerID, StreamAccount_DateTime4, StreamAccount_StreamAcID], OUTPUT_COLS=[StreamAccount_StreamChannelI, StreamAccount_CustomerID, StreamAccount_DateTime4, StreamAccount_StreamAcID]}) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_ST, nameInSource=null, uuid=tid:c8889da6a91d-23ce207f-00000000, OUTPUT_COLS=[StreamAccount_StreamChannelI, StreamAccount_CustomerID, StreamAccount_DateTime4, StreamAccount_StreamAcID]}) Select(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={SELECT_CRITERIA=(StreamAccount_DateTime4 >= '2015-07') AND (StreamAccount_DateTime4 <= '2016-07')}) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={OUTPUT_COLS=[StreamAccount_StreamChannelI, StreamAccount_CustomerID, StreamAccount_DateTime4, StreamAccount_StreamAcID]}) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel]) Source(groups=[CEBanksBusinessModel.CEGlobalView AS CEGlobalView]) Project(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView]) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView]) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=[TagName.TagNameID, TagName.TagType_TagTypeID, TagName.TagScope_TagScopeID, TagName.TagName]}) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={SELECT_CRITERIA=TagName.TagName = 'Behavior', OUTPUT_COLS=[StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID]}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={OUTPUT_COLS=[TagName.TagNameID, TagName.TagType_TagTypeID, TagName.TagScope_TagScopeID, TagName.TagName]}) ============================================================================ EXECUTING MergeVirtual AFTER: Sort(groups=[anon_grp0], props={SORT_ORDER=ORDER BY StreamChannel_StreamChannel, StreamAccountNOSX_StreamAcco1, OUTPUT_COLS=[anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco1, anon_grp0.gcol3 AS StreamChannel_StreamChannel, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco, anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco31, anon_grp0.gcol3 AS StreamChannel_StreamChannel1, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco2], UNRELATED_SORT=false}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco1, anon_grp0.gcol3 AS StreamChannel_StreamChannel, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco, anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco31, anon_grp0.gcol3 AS StreamChannel_StreamChannel1, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco2], OUTPUT_COLS=[anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco1, anon_grp0.gcol3 AS StreamChannel_StreamChannel, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco, anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco31, anon_grp0.gcol3 AS StreamChannel_StreamChannel1, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco2]}) Group(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, anon_grp0, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={GROUP_COLS=[StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccount_StreamChannelI, StreamChannel.StreamChannel], SYMBOL_MAP={anon_grp0.gcol0=StreamAccount_StreamChannelI, anon_grp0.gcol1=StreamChannel.StreamChannel, anon_grp0.gcol2=StreamAccount_StreamChannelI, anon_grp0.gcol3=StreamChannel.StreamChannel, anon_grp0.agg0=SUM(StreamAccount_StreamAcID)}, OUTPUT_COLS=[anon_grp0.gcol2, anon_grp0.gcol3, anon_grp0.agg0]}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TagValue.TagName_TagNameID = TagName.TagNameID, TagName.TagType_TagTypeID = 1, TagName.TagScope_TagScopeID = 1], OUTPUT_COLS=[StreamAccountNOSX.StreamAccount_DateTime4, TagName.TagName, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID]}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[CustomerTag.TagValue_TagValueID = TagValue.TagValueID], OUTPUT_COLS=[TagValue.TagName_TagNameID, StreamAccountNOSX.StreamAccount_DateTime4, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID]}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[Customer_CustomerID = CustomerTag.Customer_CustomerID, (CustomerTag.EndDateTime > convert(CURDATE(), timestamp)) OR (CustomerTag.EndDateTime IS NULL)], OUTPUT_COLS=[CustomerTag.TagValue_TagValueID, StreamAccountNOSX.StreamAccount_DateTime4, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID]}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[StreamAccount_CustomerID = Customer_CustomerID], OUTPUT_COLS=[CEGlobalView.Customer_CustomerID, StreamAccountNOSX.StreamAccount_DateTime4, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID]}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[StreamAccount_StreamChannelI = StreamChannel.StreamChannelID], OUTPUT_COLS=[StreamAccountNOSX.StreamAccount_CustomerID, StreamAccountNOSX.StreamAccount_DateTime4, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID]}) Select(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={SELECT_CRITERIA=StreamAccount_DateTime4 <= '2016-07', OUTPUT_COLS=[TagName.TagName, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID], IS_PHANTOM=true}) Select(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={SELECT_CRITERIA=StreamAccount_DateTime4 >= '2015-07', OUTPUT_COLS=[StreamAccountNOSX.StreamAccount_DateTime4, TagName.TagName, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID], IS_PHANTOM=true}) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_ST, nameInSource=null, uuid=tid:c8889da6a91d-23ce207f-00000000, OUTPUT_COLS=[StreamAccount_StreamChannelI, StreamAccount_CustomerID, StreamAccount_DateTime4, StreamAccount_StreamAcID]}) Select(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel]) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_ST, nameInSource=null, uuid=tid:c8889da6a91d-23ce207f-00000000, OUTPUT_COLS=[Customer_CustomerID]}) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) ============================================================================ EXECUTING PushNonJoinCriteria AFTER: Sort(groups=[anon_grp0]) Project(groups=[anon_grp0]) Group(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, anon_grp0, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TagValue.TagName_TagNameID = TagName.TagNameID], OUTPUT_COLS=[StreamAccountNOSX.StreamAccount_DateTime4, TagName.TagName, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID]}) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue], props={SELECT_CRITERIA=TagValue.TagName_TagNameID IS NOT NULL, IS_TEMPORARY=true}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[CustomerTag.TagValue_TagValueID = TagValue.TagValueID], OUTPUT_COLS=[TagValue.TagName_TagNameID, StreamAccountNOSX.StreamAccount_DateTime4, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID]}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[Customer_CustomerID = CustomerTag.Customer_CustomerID], OUTPUT_COLS=[CustomerTag.TagValue_TagValueID, StreamAccountNOSX.StreamAccount_DateTime4, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID]}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[StreamAccount_CustomerID = Customer_CustomerID], OUTPUT_COLS=[CEGlobalView.Customer_CustomerID, StreamAccountNOSX.StreamAccount_DateTime4, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID]}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[StreamAccount_StreamChannelI = StreamChannel.StreamChannelID], OUTPUT_COLS=[StreamAccountNOSX.StreamAccount_CustomerID, StreamAccountNOSX.StreamAccount_DateTime4, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID]}) Select(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Select(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Select(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel]) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView]) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView]) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={SELECT_CRITERIA=(CustomerTag.EndDateTime > convert(CURDATE(), timestamp)) OR (CustomerTag.EndDateTime IS NULL)}) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=[CustomerTag.Customer_CustomerID, CustomerTag.EndDateTime, CustomerTag.TagValue_TagValueID]}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue]) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={SELECT_CRITERIA=TagName.TagScope_TagScopeID = 1}) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={SELECT_CRITERIA=TagName.TagType_TagTypeID = 1}) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=[TagName.TagNameID, TagName.TagType_TagTypeID, TagName.TagScope_TagScopeID, TagName.TagName]}) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) ============================================================================ EXECUTING PushSelectCriteria AFTER: Sort(groups=[anon_grp0]) Project(groups=[anon_grp0]) Group(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, anon_grp0, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TagValue.TagName_TagNameID = TagName.TagNameID], OUTPUT_COLS=[StreamAccountNOSX.StreamAccount_DateTime4, TagName.TagName, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID]}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[CustomerTag.TagValue_TagValueID = TagValue.TagValueID], OUTPUT_COLS=[TagValue.TagName_TagNameID, StreamAccountNOSX.StreamAccount_DateTime4, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID]}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[Customer_CustomerID = CustomerTag.Customer_CustomerID], OUTPUT_COLS=[CustomerTag.TagValue_TagValueID, StreamAccountNOSX.StreamAccount_DateTime4, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID]}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView]) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Select(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={SELECT_CRITERIA=StreamAccount_DateTime4 <= '2016-07', OUTPUT_COLS=[TagName.TagName, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID], IS_PHANTOM=true}) Select(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={SELECT_CRITERIA=StreamAccount_DateTime4 >= '2015-07', OUTPUT_COLS=[StreamAccountNOSX.StreamAccount_DateTime4, TagName.TagName, StreamAccountNOSX.StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccountNOSX.StreamAccount_StreamAcID], IS_PHANTOM=true}) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Select(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel]) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView]) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=[CustomerTag.Customer_CustomerID, CustomerTag.EndDateTime, CustomerTag.TagValue_TagValueID]}) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={SELECT_CRITERIA=(CustomerTag.EndDateTime > convert(CURDATE(), timestamp)) OR (CustomerTag.EndDateTime IS NULL)}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={OUTPUT_COLS=[CustomerTag.Customer_CustomerID, CustomerTag.EndDateTime, CustomerTag.TagValue_TagValueID]}) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=[TagValue.TagValueID, TagValue.TagName_TagNameID]}) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue], props={SELECT_CRITERIA=TagValue.TagName_TagNameID IS NOT NULL, IS_TEMPORARY=true}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue], props={OUTPUT_COLS=[TagValue.TagValueID, TagValue.TagName_TagNameID]}) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=[TagName.TagNameID, TagName.TagType_TagTypeID, TagName.TagScope_TagScopeID, TagName.TagName]}) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={SELECT_CRITERIA=(TagName.TagName = 'Behavior') AND (TagName.TagType_TagTypeID = 1) AND (TagName.TagScope_TagScopeID = 1)}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={OUTPUT_COLS=[TagName.TagNameID, TagName.TagType_TagTypeID, TagName.TagScope_TagScopeID, TagName.TagName]}) ============================================================================ EXECUTING CleanCriteria AFTER: Sort(groups=[anon_grp0], props={SORT_ORDER=ORDER BY StreamChannel_StreamChannel, StreamAccountNOSX_StreamAcco1, OUTPUT_COLS=null, UNRELATED_SORT=false}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco1, anon_grp0.gcol3 AS StreamChannel_StreamChannel, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco, anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco31, anon_grp0.gcol3 AS StreamChannel_StreamChannel1, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco2], OUTPUT_COLS=null}) Group(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, anon_grp0, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={GROUP_COLS=[StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccount_StreamChannelI, StreamChannel.StreamChannel], SYMBOL_MAP={anon_grp0.gcol0=StreamAccount_StreamChannelI, anon_grp0.gcol1=StreamChannel.StreamChannel, anon_grp0.gcol2=StreamAccount_StreamChannelI, anon_grp0.gcol3=StreamChannel.StreamChannel, anon_grp0.agg0=SUM(StreamAccount_StreamAcID)}, OUTPUT_COLS=null}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TagValue.TagName_TagNameID = TagName.TagNameID], OUTPUT_COLS=null}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[CustomerTag.TagValue_TagValueID = TagValue.TagValueID], OUTPUT_COLS=null}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[Customer_CustomerID = CustomerTag.Customer_CustomerID], OUTPUT_COLS=null}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[StreamAccount_CustomerID = Customer_CustomerID], OUTPUT_COLS=null}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[StreamAccount_StreamChannelI = StreamChannel.StreamChannelID], OUTPUT_COLS=null}) Select(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={SELECT_CRITERIA=StreamAccount_DateTime4 <= '2016-07', OUTPUT_COLS=null, IS_PHANTOM=true}) Select(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={SELECT_CRITERIA=StreamAccount_DateTime4 >= '2015-07', OUTPUT_COLS=null, IS_PHANTOM=true}) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_ST, nameInSource=null, uuid=tid:c8889da6a91d-23ce207f-00000000, OUTPUT_COLS=null}) Select(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={SELECT_CRITERIA=(StreamAccount_DateTime4 >= '2015-07') AND (StreamAccount_DateTime4 <= '2016-07'), OUTPUT_COLS=null}) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={OUTPUT_COLS=null}) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=null}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel], props={OUTPUT_COLS=null}) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_ST, nameInSource=null, uuid=tid:c8889da6a91d-23ce207f-00000000, OUTPUT_COLS=null}) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={OUTPUT_COLS=null}) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=null}) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={SELECT_CRITERIA=(CustomerTag.EndDateTime > convert(CURDATE(), timestamp)) OR (CustomerTag.EndDateTime IS NULL), OUTPUT_COLS=null}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={OUTPUT_COLS=null}) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=null}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue], props={OUTPUT_COLS=null}) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=null}) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={SELECT_CRITERIA=(TagName.TagName = 'Behavior') AND (TagName.TagType_TagTypeID = 1) AND (TagName.TagScope_TagScopeID = 1), OUTPUT_COLS=null}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING RaiseAccess AFTER: Sort(groups=[anon_grp0]) Project(groups=[anon_grp0]) Group(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, anon_grp0, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TagValue.TagName_TagNameID = TagName.TagNameID], OUTPUT_COLS=null}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[CustomerTag.TagValue_TagValueID = TagValue.TagValueID], OUTPUT_COLS=null}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[Customer_CustomerID = CustomerTag.Customer_CustomerID], OUTPUT_COLS=null}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[StreamAccount_CustomerID = Customer_CustomerID], OUTPUT_COLS=null}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[StreamAccount_StreamChannelI = StreamChannel.StreamChannelID], OUTPUT_COLS=null}) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_ST, nameInSource=null, uuid=tid:c8889da6a91d-23ce207f-00000000, OUTPUT_COLS=null}) Select(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={SELECT_CRITERIA=StreamAccount_DateTime4 <= '2016-07', OUTPUT_COLS=null, IS_PHANTOM=true}) Select(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={SELECT_CRITERIA=StreamAccount_DateTime4 >= '2015-07', OUTPUT_COLS=null, IS_PHANTOM=true}) Select(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={SELECT_CRITERIA=(StreamAccount_DateTime4 >= '2015-07') AND (StreamAccount_DateTime4 <= '2016-07'), OUTPUT_COLS=null}) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=null}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel]) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_ST, nameInSource=null, uuid=tid:c8889da6a91d-23ce207f-00000000, OUTPUT_COLS=null}) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=null}) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=null}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=null}) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) ============================================================================ EXECUTING CopyCriteria AFTER: Sort(groups=[anon_grp0]) Project(groups=[anon_grp0]) Group(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, anon_grp0, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TagValue.TagName_TagNameID = TagName.TagNameID], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[CustomerTag.TagValue_TagValueID = TagValue.TagValueID], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[Customer_CustomerID = CustomerTag.Customer_CustomerID], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[StreamAccount_CustomerID = Customer_CustomerID], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[StreamAccount_StreamChannelI = StreamChannel.StreamChannelID], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Select(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={SELECT_CRITERIA=StreamAccount_DateTime4 <= '2016-07', OUTPUT_COLS=null, IS_PHANTOM=true, IS_COPIED=true}) Select(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={SELECT_CRITERIA=StreamAccount_DateTime4 >= '2015-07', OUTPUT_COLS=null, IS_PHANTOM=true, IS_COPIED=true}) Select(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={SELECT_CRITERIA=(StreamAccount_DateTime4 >= '2015-07') AND (StreamAccount_DateTime4 <= '2016-07'), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel]) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView]) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag]) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={SELECT_CRITERIA=(CustomerTag.EndDateTime > convert(CURDATE(), timestamp)) OR (CustomerTag.EndDateTime IS NULL), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={SELECT_CRITERIA=(TagName.TagName = 'Behavior') AND (TagName.TagType_TagTypeID = 1) AND (TagName.TagScope_TagScopeID = 1), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) ============================================================================ EXECUTING CleanCriteria AFTER: Sort(groups=[anon_grp0], props={SORT_ORDER=ORDER BY StreamChannel_StreamChannel, StreamAccountNOSX_StreamAcco1, OUTPUT_COLS=null, UNRELATED_SORT=false}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco1, anon_grp0.gcol3 AS StreamChannel_StreamChannel, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco, anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco31, anon_grp0.gcol3 AS StreamChannel_StreamChannel1, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco2], OUTPUT_COLS=null}) Group(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, anon_grp0, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={GROUP_COLS=[StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccount_StreamChannelI, StreamChannel.StreamChannel], SYMBOL_MAP={anon_grp0.gcol0=StreamAccount_StreamChannelI, anon_grp0.gcol1=StreamChannel.StreamChannel, anon_grp0.gcol2=StreamAccount_StreamChannelI, anon_grp0.gcol3=StreamChannel.StreamChannel, anon_grp0.agg0=SUM(StreamAccount_StreamAcID)}, OUTPUT_COLS=null}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TagValue.TagName_TagNameID = TagName.TagNameID], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[CustomerTag.TagValue_TagValueID = TagValue.TagValueID], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[Customer_CustomerID = CustomerTag.Customer_CustomerID], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[StreamAccount_CustomerID = Customer_CustomerID], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[StreamAccount_StreamChannelI = StreamChannel.StreamChannelID], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_ST, nameInSource=null, uuid=tid:c8889da6a91d-23ce207f-00000000, OUTPUT_COLS=null}) Select(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={SELECT_CRITERIA=(StreamAccount_DateTime4 >= '2015-07') AND (StreamAccount_DateTime4 <= '2016-07'), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={OUTPUT_COLS=null}) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=null}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel], props={OUTPUT_COLS=null}) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_ST, nameInSource=null, uuid=tid:c8889da6a91d-23ce207f-00000000, OUTPUT_COLS=null}) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={OUTPUT_COLS=null}) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=null}) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={SELECT_CRITERIA=(CustomerTag.EndDateTime > convert(CURDATE(), timestamp)) OR (CustomerTag.EndDateTime IS NULL), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={OUTPUT_COLS=null}) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=null}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue], props={OUTPUT_COLS=null}) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=null}) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={SELECT_CRITERIA=(TagName.TagName = 'Behavior') AND (TagName.TagType_TagTypeID = 1) AND (TagName.TagScope_TagScopeID = 1), OUTPUT_COLS=null, IS_COPIED=true}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING PlanJoins AFTER: Sort(groups=[anon_grp0]) Project(groups=[anon_grp0]) Group(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, anon_grp0, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={GROUP_COLS=[StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccount_StreamChannelI, StreamChannel.StreamChannel], SYMBOL_MAP={anon_grp0.gcol0=StreamAccount_StreamChannelI, anon_grp0.gcol1=StreamChannel.StreamChannel, anon_grp0.gcol2=StreamAccount_StreamChannelI, anon_grp0.gcol3=StreamChannel.StreamChannel, anon_grp0.agg0=SUM(StreamAccount_StreamAcID)}, OUTPUT_COLS=null}) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={SELECT_CRITERIA=CustomerTag.TagValue_TagValueID = TagValue.TagValueID, EST_SELECTIVITY=0.12577777}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[Customer_CustomerID = CustomerTag.Customer_CustomerID], OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=-1.0}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[StreamAccount_CustomerID = Customer_CustomerID], OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=-1.0}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[StreamAccount_StreamChannelI = StreamChannel.StreamChannelID], OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=-1.0}) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_ST, nameInSource=null, uuid=tid:c8889da6a91d-23ce207f-00000000, OUTPUT_COLS=null, EST_CARDINALITY=-1.0}) Select(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={SELECT_CRITERIA=(StreamAccount_DateTime4 >= '2015-07') AND (StreamAccount_DateTime4 <= '2016-07'), OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=-1.0}) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={OUTPUT_COLS=null, EST_COL_STATS={h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX.StreamAccount_CustomerID=[-1.0, -1.0], h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX.StreamAccount_Amount=[-1.0, -1.0], h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX.StreamAccount_StreamAcID=[-1.0, -1.0], h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX.StreamAccount_DateTime=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=null, EST_CARDINALITY=-1.0}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel], props={OUTPUT_COLS=null, EST_COL_STATS={StreamChannel.StreamChannelID=[-1.0, -1.0], StreamChannel.StreamChannel=[-1.0, -1.0], StreamChannel.IDint=[-1.0, -1.0], StreamChannel.IDstring=[-1.0, -1.0]}, EST_CARDINALITY=-1.0}) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_ST, nameInSource=null, uuid=tid:c8889da6a91d-23ce207f-00000000, OUTPUT_COLS=null, EST_CARDINALITY=-1.0}) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={OUTPUT_COLS=null, EST_COL_STATS={h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView.Customer_BirthDate=[-1.0, -1.0], h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView.Customer_CustomerID=[-1.0, -1.0], h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView.Customer_Email=[-1.0, -1.0], h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView.Customer_FirstName=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=null, EST_CARDINALITY=-1.0}) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={SELECT_CRITERIA=(CustomerTag.EndDateTime > convert(CURDATE(), timestamp)) OR (CustomerTag.EndDateTime IS NULL), OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=-1.0}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={OUTPUT_COLS=null, EST_COL_STATS={CustomerTag.CustomerTagID=[-1.0, -1.0], CustomerTag.TagValue_TagValueID=[-1.0, -1.0], CustomerTag.Customer_CustomerID=[-1.0, -1.0], CustomerTag.StartDateTime=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=-1.0}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TagValue.TagName_TagNameID = TagName.TagNameID], MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, EST_CARDINALITY=-1.0}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue], props={OUTPUT_COLS=null, EST_COL_STATS={TagValue.TagValueID=[-1.0, -1.0], TagValue.TextValue=[-1.0, -1.0], TagValue.TagName_TagNameID=[-1.0, -1.0], TagValue.NumValue=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={SELECT_CRITERIA=(TagName.TagName = 'Behavior') AND (TagName.TagType_TagTypeID = 1) AND (TagName.TagScope_TagScopeID = 1), OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=-1.0}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={OUTPUT_COLS=null, EST_COL_STATS={TagName.TagNameID=[-1.0, -1.0], TagName.TagName=[-1.0, -1.0], TagName.TagType_TagTypeID=[-1.0, -1.0], TagName.DataType_DataTypeID=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) ============================================================================ EXECUTING PushSelectCriteria AFTER: Sort(groups=[anon_grp0]) Project(groups=[anon_grp0]) Group(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, anon_grp0, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={GROUP_COLS=[StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccount_StreamChannelI, StreamChannel.StreamChannel], SYMBOL_MAP={anon_grp0.gcol0=StreamAccount_StreamChannelI, anon_grp0.gcol1=StreamChannel.StreamChannel, anon_grp0.gcol2=StreamAccount_StreamChannelI, anon_grp0.gcol3=StreamChannel.StreamChannel, anon_grp0.agg0=SUM(StreamAccount_StreamAcID)}, OUTPUT_COLS=null}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[CustomerTag.TagValue_TagValueID = TagValue.TagValueID]}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView]) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView]) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Select(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={SELECT_CRITERIA=(StreamAccount_DateTime4 >= '2015-07') AND (StreamAccount_DateTime4 <= '2016-07'), OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=-1.0}) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel]) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView]) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag]) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={SELECT_CRITERIA=(CustomerTag.EndDateTime > convert(CURDATE(), timestamp)) OR (CustomerTag.EndDateTime IS NULL), OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=-1.0}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue]) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={SELECT_CRITERIA=(TagName.TagName = 'Behavior') AND (TagName.TagType_TagTypeID = 1) AND (TagName.TagScope_TagScopeID = 1), OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=-1.0}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) ============================================================================ EXECUTING RaiseAccess AFTER: Sort(groups=[anon_grp0]) Project(groups=[anon_grp0]) Group(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, anon_grp0, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[CustomerTag.TagValue_TagValueID = TagValue.TagValueID]}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[Customer_CustomerID = CustomerTag.Customer_CustomerID], OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=-1.0}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[StreamAccount_CustomerID = Customer_CustomerID], OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=-1.0}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[StreamAccount_StreamChannelI = StreamChannel.StreamChannelID], OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=-1.0}) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_ST, nameInSource=null, uuid=tid:c8889da6a91d-23ce207f-00000000, OUTPUT_COLS=null, EST_CARDINALITY=-1.0}) Select(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=null, EST_CARDINALITY=-1.0}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel]) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_ST, nameInSource=null, uuid=tid:c8889da6a91d-23ce207f-00000000, OUTPUT_COLS=null, EST_CARDINALITY=-1.0}) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=null, EST_CARDINALITY=-1.0}) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=-1.0}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue]) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) ============================================================================ EXECUTING PlanOuterJoins AFTER: Sort(groups=[anon_grp0]) Project(groups=[anon_grp0]) Group(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, anon_grp0, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[CustomerTag.TagValue_TagValueID = TagValue.TagValueID]}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[Customer_CustomerID = CustomerTag.Customer_CustomerID], OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=-1.0}) Join(groups=[], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[StreamAccount_StreamChannelI = StreamChannel.StreamChannelID]}) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_ST, nameInSource=null, uuid=tid:c8889da6a91d-23ce207f-00000000, OUTPUT_COLS=null, EST_CARDINALITY=-1.0, CONFORMED_SOURCES=null}) Join(groups=[], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[StreamAccount_CustomerID = Customer_CustomerID], MODEL_ID=Schema name=h2dbimplify_data_cebankModel_ST, nameInSource=null, uuid=tid:c8889da6a91d-23ce207f-00000000}) Select(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={SELECT_CRITERIA=(StreamAccount_DateTime4 >= '2015-07') AND (StreamAccount_DateTime4 <= '2016-07'), OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=-1.0}) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={OUTPUT_COLS=null, EST_COL_STATS={h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView.Customer_BirthDate=[-1.0, -1.0], h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView.Customer_CustomerID=[-1.0, -1.0], h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView.Customer_Email=[-1.0, -1.0], h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView.Customer_FirstName=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=null, EST_CARDINALITY=-1.0}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=null, EST_CARDINALITY=-1.0}) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue]) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) ============================================================================ EXECUTING ChooseJoinStrategy AFTER: Sort(groups=[anon_grp0]) Project(groups=[anon_grp0]) Group(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, anon_grp0, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[CustomerTag.TagValue_TagValueID = TagValue.TagValueID], LEFT_EXPRESSIONS=[CustomerTag.TagValue_TagValueID], RIGHT_EXPRESSIONS=[TagValue.TagValueID], NON_EQUI_JOIN_CRITERIA=[]}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[Customer_CustomerID = CustomerTag.Customer_CustomerID], OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=-1.0}) Join(groups=[], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[StreamAccount_StreamChannelI = StreamChannel.StreamChannelID], LEFT_EXPRESSIONS=[StreamAccount_StreamChannelI], RIGHT_EXPRESSIONS=[StreamChannel.StreamChannelID], NON_EQUI_JOIN_CRITERIA=[]}) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView]) Join(groups=[]) Select(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag]) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue]) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) ============================================================================ EXECUTING ChooseDependent LOW [Relational Planner] parent join has no equa-join predicates - Rejecting dependent join Join(groups=[], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[StreamAccount_StreamChannelI = StreamChannel.StreamChannelID], LEFT_EXPRESSIONS=[StreamAccount_StreamChannelI], RIGHT_EXPRESSIONS=[StreamChannel.StreamChannelID], NON_EQUI_JOIN_CRITERIA=[]} LOW [Relational Planner] parent join has no equa-join predicates - Rejecting dependent join Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=null, EST_CARDINALITY=-1.0} AFTER: Sort(groups=[anon_grp0]) Project(groups=[anon_grp0]) Group(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, anon_grp0, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[CustomerTag.TagValue_TagValueID = TagValue.TagValueID], LEFT_EXPRESSIONS=[CustomerTag.TagValue_TagValueID], RIGHT_EXPRESSIONS=[TagValue.TagValueID], NON_EQUI_JOIN_CRITERIA=[]}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[Customer_CustomerID = CustomerTag.Customer_CustomerID], OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=-1.0}) Join(groups=[], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[StreamAccount_StreamChannelI = StreamChannel.StreamChannelID], LEFT_EXPRESSIONS=[StreamAccount_StreamChannelI], RIGHT_EXPRESSIONS=[StreamChannel.StreamChannelID], NON_EQUI_JOIN_CRITERIA=[]}) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView]) Join(groups=[]) Select(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag]) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue]) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) ============================================================================ EXECUTING PushAggregates AFTER: Sort(groups=[anon_grp0]) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco1, anon_grp0.gcol3 AS StreamChannel_StreamChannel, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco, anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco31, anon_grp0.gcol3 AS StreamChannel_StreamChannel1, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco2], OUTPUT_COLS=null}) Group(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, anon_grp0, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={GROUP_COLS=[StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccount_StreamChannelI, StreamChannel.StreamChannel], SYMBOL_MAP={anon_grp0.gcol0=StreamAccount_StreamChannelI, anon_grp0.gcol1=StreamChannel.StreamChannel, anon_grp0.gcol2=StreamAccount_StreamChannelI, anon_grp0.gcol3=StreamChannel.StreamChannel, anon_grp0.agg0=SUM(StreamAccount_StreamAcID)}, OUTPUT_COLS=null}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView]) Join(groups=[]) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView]) Join(groups=[]) Select(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag]) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue]) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) ============================================================================ EXECUTING ChooseDependent LOW [Relational Planner] parent join has no equa-join predicates - Rejecting dependent join Join(groups=[], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[StreamAccount_StreamChannelI = StreamChannel.StreamChannelID], LEFT_EXPRESSIONS=[StreamAccount_StreamChannelI], RIGHT_EXPRESSIONS=[StreamChannel.StreamChannelID], NON_EQUI_JOIN_CRITERIA=[]} LOW [Relational Planner] parent join has no equa-join predicates - Rejecting dependent join Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=null, EST_CARDINALITY=-1.0} AFTER: Sort(groups=[anon_grp0]) Project(groups=[anon_grp0]) Group(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, anon_grp0, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[CustomerTag.TagValue_TagValueID = TagValue.TagValueID], LEFT_EXPRESSIONS=[CustomerTag.TagValue_TagValueID], RIGHT_EXPRESSIONS=[TagValue.TagValueID], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=null}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[Customer_CustomerID = CustomerTag.Customer_CustomerID], OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=-1.0}) Join(groups=[], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[StreamAccount_StreamChannelI = StreamChannel.StreamChannelID], LEFT_EXPRESSIONS=[StreamAccount_StreamChannelI], RIGHT_EXPRESSIONS=[StreamChannel.StreamChannelID], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=-1.0}) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_ST, nameInSource=null, uuid=tid:c8889da6a91d-23ce207f-00000000, OUTPUT_COLS=null, EST_CARDINALITY=-1.0, CONFORMED_SOURCES=null}) Join(groups=[], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[StreamAccount_CustomerID = Customer_CustomerID], MODEL_ID=Schema name=h2dbimplify_data_cebankModel_ST, nameInSource=null, uuid=tid:c8889da6a91d-23ce207f-00000000, EST_CARDINALITY=-1.0}) Select(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={SELECT_CRITERIA=(StreamAccount_DateTime4 >= '2015-07') AND (StreamAccount_DateTime4 <= '2016-07'), OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=-1.0}) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={OUTPUT_COLS=null, EST_COL_STATS={h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX.StreamAccount_CustomerID=[-1.0, -1.0], h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX.StreamAccount_Amount=[-1.0, -1.0], h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX.StreamAccount_StreamAcID=[-1.0, -1.0], h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX.StreamAccount_DateTime=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={OUTPUT_COLS=null, EST_COL_STATS={h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView.Customer_BirthDate=[-1.0, -1.0], h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView.Customer_CustomerID=[-1.0, -1.0], h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView.Customer_Email=[-1.0, -1.0], h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView.Customer_FirstName=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=null, EST_CARDINALITY=-1.0}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel], props={OUTPUT_COLS=null, EST_COL_STATS={StreamChannel.StreamChannelID=[-1.0, -1.0], StreamChannel.StreamChannel=[-1.0, -1.0], StreamChannel.IDint=[-1.0, -1.0], StreamChannel.IDstring=[-1.0, -1.0]}, EST_CARDINALITY=-1.0}) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=null, EST_CARDINALITY=-1.0}) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={SELECT_CRITERIA=(CustomerTag.EndDateTime > convert(CURDATE(), timestamp)) OR (CustomerTag.EndDateTime IS NULL), OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=-1.0}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={OUTPUT_COLS=null, EST_COL_STATS={CustomerTag.CustomerTagID=[-1.0, -1.0], CustomerTag.TagValue_TagValueID=[-1.0, -1.0], CustomerTag.Customer_CustomerID=[-1.0, -1.0], CustomerTag.StartDateTime=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=-1.0}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TagValue.TagName_TagNameID = TagName.TagNameID], MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, EST_CARDINALITY=-1.0}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue], props={OUTPUT_COLS=null, EST_COL_STATS={TagValue.TagValueID=[-1.0, -1.0], TagValue.TextValue=[-1.0, -1.0], TagValue.TagName_TagNameID=[-1.0, -1.0], TagValue.NumValue=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={SELECT_CRITERIA=(TagName.TagName = 'Behavior') AND (TagName.TagType_TagTypeID = 1) AND (TagName.TagScope_TagScopeID = 1), OUTPUT_COLS=null, IS_COPIED=true, EST_CARDINALITY=-1.0}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={OUTPUT_COLS=null, EST_COL_STATS={TagName.TagNameID=[-1.0, -1.0], TagName.TagName=[-1.0, -1.0], TagName.TagType_TagTypeID=[-1.0, -1.0], TagName.DataType_DataTypeID=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) ============================================================================ EXECUTING AssignOutputElements AFTER: Sort(groups=[anon_grp0], props={SORT_ORDER=ORDER BY StreamChannel_StreamChannel, StreamAccountNOSX_StreamAcco1, OUTPUT_COLS=[anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco1, anon_grp0.gcol3 AS StreamChannel_StreamChannel, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco, anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco31, anon_grp0.gcol3 AS StreamChannel_StreamChannel1, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco2], UNRELATED_SORT=false}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco1, anon_grp0.gcol3 AS StreamChannel_StreamChannel, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco, anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco31, anon_grp0.gcol3 AS StreamChannel_StreamChannel1, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco2], OUTPUT_COLS=[anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco1, anon_grp0.gcol3 AS StreamChannel_StreamChannel, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco, anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco31, anon_grp0.gcol3 AS StreamChannel_StreamChannel1, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco2]}) Group(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, anon_grp0, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={GROUP_COLS=[StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccount_StreamChannelI, StreamChannel.StreamChannel], SYMBOL_MAP={anon_grp0.gcol0=StreamAccount_StreamChannelI, anon_grp0.gcol1=StreamChannel.StreamChannel, anon_grp0.gcol2=StreamAccount_StreamChannelI, anon_grp0.gcol3=StreamChannel.StreamChannel, anon_grp0.agg0=SUM(StreamAccount_StreamAcID)}, OUTPUT_COLS=[anon_grp0.gcol2, anon_grp0.gcol3, anon_grp0.agg0]}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[CustomerTag.TagValue_TagValueID = TagValue.TagValueID], LEFT_EXPRESSIONS=[CustomerTag.TagValue_TagValueID], RIGHT_EXPRESSIONS=[TagValue.TagValueID], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=null, OUTPUT_COLS=[StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccount_StreamAcID]}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[Customer_CustomerID = CustomerTag.Customer_CustomerID], OUTPUT_COLS=[CustomerTag.TagValue_TagValueID, StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccount_StreamAcID], IS_COPIED=true, EST_CARDINALITY=-1.0}) Join(groups=[], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[StreamAccount_StreamChannelI = StreamChannel.StreamChannelID], LEFT_EXPRESSIONS=[StreamAccount_StreamChannelI], RIGHT_EXPRESSIONS=[StreamChannel.StreamChannelID], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=-1.0, OUTPUT_COLS=[]}) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_ST, nameInSource=null, uuid=tid:c8889da6a91d-23ce207f-00000000, OUTPUT_COLS=[StreamAccount_StreamChannelI], EST_CARDINALITY=-1.0, CONFORMED_SOURCES=null}) Join(groups=[], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[StreamAccount_CustomerID = Customer_CustomerID], MODEL_ID=Schema name=h2dbimplify_data_cebankModel_ST, nameInSource=null, uuid=tid:c8889da6a91d-23ce207f-00000000, EST_CARDINALITY=-1.0, OUTPUT_COLS=[StreamAccount_StreamChannelI]}) Select(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={SELECT_CRITERIA=(StreamAccount_DateTime4 >= '2015-07') AND (StreamAccount_DateTime4 <= '2016-07'), OUTPUT_COLS=[StreamAccount_CustomerID, StreamAccount_StreamChannelI], IS_COPIED=true, EST_CARDINALITY=-1.0}) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={OUTPUT_COLS=[StreamAccount_DateTime4, StreamAccount_CustomerID, StreamAccount_StreamChannelI], EST_COL_STATS={h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX.StreamAccount_CustomerID=[-1.0, -1.0], h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX.StreamAccount_Amount=[-1.0, -1.0], h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX.StreamAccount_StreamAcID=[-1.0, -1.0], h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX.StreamAccount_DateTime=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={OUTPUT_COLS=[Customer_CustomerID], EST_COL_STATS={h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView.Customer_BirthDate=[-1.0, -1.0], h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView.Customer_CustomerID=[-1.0, -1.0], h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView.Customer_Email=[-1.0, -1.0], h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView.Customer_FirstName=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=[StreamChannel.StreamChannelID], EST_CARDINALITY=-1.0}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel], props={OUTPUT_COLS=[StreamChannel.StreamChannelID], EST_COL_STATS={StreamChannel.StreamChannelID=[-1.0, -1.0], StreamChannel.StreamChannel=[-1.0, -1.0], StreamChannel.IDint=[-1.0, -1.0], StreamChannel.IDstring=[-1.0, -1.0]}, EST_CARDINALITY=-1.0}) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=[CustomerTag.Customer_CustomerID, CustomerTag.TagValue_TagValueID], EST_CARDINALITY=-1.0}) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={SELECT_CRITERIA=(CustomerTag.EndDateTime > convert(CURDATE(), timestamp)) OR (CustomerTag.EndDateTime IS NULL), OUTPUT_COLS=[CustomerTag.Customer_CustomerID, CustomerTag.TagValue_TagValueID], IS_COPIED=true, EST_CARDINALITY=-1.0}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={OUTPUT_COLS=[CustomerTag.EndDateTime, CustomerTag.Customer_CustomerID, CustomerTag.TagValue_TagValueID], EST_COL_STATS={CustomerTag.CustomerTagID=[-1.0, -1.0], CustomerTag.TagValue_TagValueID=[-1.0, -1.0], CustomerTag.Customer_CustomerID=[-1.0, -1.0], CustomerTag.StartDateTime=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=[TagValue.TagValueID], CONFORMED_SOURCES=null, EST_CARDINALITY=-1.0}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TagValue.TagName_TagNameID = TagName.TagNameID], MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, EST_CARDINALITY=-1.0, OUTPUT_COLS=[TagValue.TagValueID]}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue], props={OUTPUT_COLS=[TagValue.TagName_TagNameID, TagValue.TagValueID], EST_COL_STATS={TagValue.TagValueID=[-1.0, -1.0], TagValue.TextValue=[-1.0, -1.0], TagValue.TagName_TagNameID=[-1.0, -1.0], TagValue.NumValue=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={SELECT_CRITERIA=(TagName.TagName = 'Behavior') AND (TagName.TagType_TagTypeID = 1) AND (TagName.TagScope_TagScopeID = 1), OUTPUT_COLS=[TagName.TagNameID], IS_COPIED=true, EST_CARDINALITY=-1.0}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={OUTPUT_COLS=[TagName.TagName, TagName.TagType_TagTypeID, TagName.TagScope_TagScopeID, TagName.TagNameID], EST_COL_STATS={TagName.TagNameID=[-1.0, -1.0], TagName.TagName=[-1.0, -1.0], TagName.TagType_TagTypeID=[-1.0, -1.0], TagName.DataType_DataTypeID=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) ============================================================================ EXECUTING CalculateCost AFTER: Sort(groups=[anon_grp0], props={SORT_ORDER=ORDER BY StreamChannel_StreamChannel, StreamAccountNOSX_StreamAcco1, OUTPUT_COLS=[anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco1, anon_grp0.gcol3 AS StreamChannel_StreamChannel, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco, anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco31, anon_grp0.gcol3 AS StreamChannel_StreamChannel1, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco2], UNRELATED_SORT=false, EST_CARDINALITY=-1.0}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco1, anon_grp0.gcol3 AS StreamChannel_StreamChannel, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco, anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco31, anon_grp0.gcol3 AS StreamChannel_StreamChannel1, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco2], OUTPUT_COLS=[anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco1, anon_grp0.gcol3 AS StreamChannel_StreamChannel, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco, anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco31, anon_grp0.gcol3 AS StreamChannel_StreamChannel1, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco2], EST_CARDINALITY=-1.0}) Group(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, anon_grp0, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={GROUP_COLS=[StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccount_StreamChannelI, StreamChannel.StreamChannel], SYMBOL_MAP={anon_grp0.gcol0=StreamAccount_StreamChannelI, anon_grp0.gcol1=StreamChannel.StreamChannel, anon_grp0.gcol2=StreamAccount_StreamChannelI, anon_grp0.gcol3=StreamChannel.StreamChannel, anon_grp0.agg0=SUM(StreamAccount_StreamAcID)}, OUTPUT_COLS=[anon_grp0.gcol2, anon_grp0.gcol3, anon_grp0.agg0], EST_CARDINALITY=-1.0}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[CustomerTag.TagValue_TagValueID = TagValue.TagValueID], LEFT_EXPRESSIONS=[CustomerTag.TagValue_TagValueID], RIGHT_EXPRESSIONS=[TagValue.TagValueID], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=-1.0, OUTPUT_COLS=[StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccount_StreamAcID]}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[Customer_CustomerID = CustomerTag.Customer_CustomerID], OUTPUT_COLS=[CustomerTag.TagValue_TagValueID, StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccount_StreamAcID], IS_COPIED=true, EST_CARDINALITY=-1.0}) Join(groups=[], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[StreamAccount_StreamChannelI = StreamChannel.StreamChannelID], LEFT_EXPRESSIONS=[StreamAccount_StreamChannelI], RIGHT_EXPRESSIONS=[StreamChannel.StreamChannelID], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=-1.0, OUTPUT_COLS=[]}) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_ST, nameInSource=null, uuid=tid:c8889da6a91d-23ce207f-00000000, OUTPUT_COLS=[StreamAccount_StreamChannelI], EST_CARDINALITY=-1.0, CONFORMED_SOURCES=null}) Join(groups=[], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[StreamAccount_CustomerID = Customer_CustomerID], MODEL_ID=Schema name=h2dbimplify_data_cebankModel_ST, nameInSource=null, uuid=tid:c8889da6a91d-23ce207f-00000000, EST_CARDINALITY=-1.0, OUTPUT_COLS=[StreamAccount_StreamChannelI]}) Select(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={SELECT_CRITERIA=(StreamAccount_DateTime4 >= '2015-07') AND (StreamAccount_DateTime4 <= '2016-07'), OUTPUT_COLS=[StreamAccount_CustomerID, StreamAccount_StreamChannelI], IS_COPIED=true, EST_CARDINALITY=-1.0}) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={OUTPUT_COLS=[StreamAccount_DateTime4, StreamAccount_CustomerID, StreamAccount_StreamChannelI], EST_COL_STATS={h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX.StreamAccount_CustomerID=[-1.0, -1.0], h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX.StreamAccount_Amount=[-1.0, -1.0], h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX.StreamAccount_StreamAcID=[-1.0, -1.0], h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX.StreamAccount_DateTime=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={OUTPUT_COLS=[Customer_CustomerID], EST_COL_STATS={h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView.Customer_BirthDate=[-1.0, -1.0], h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView.Customer_CustomerID=[-1.0, -1.0], h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView.Customer_Email=[-1.0, -1.0], h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView.Customer_FirstName=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=[StreamChannel.StreamChannelID], EST_CARDINALITY=-1.0}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel], props={OUTPUT_COLS=[StreamChannel.StreamChannelID], EST_COL_STATS={StreamChannel.StreamChannelID=[-1.0, -1.0], StreamChannel.StreamChannel=[-1.0, -1.0], StreamChannel.IDint=[-1.0, -1.0], StreamChannel.IDstring=[-1.0, -1.0]}, EST_CARDINALITY=-1.0}) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=[CustomerTag.Customer_CustomerID, CustomerTag.TagValue_TagValueID], EST_CARDINALITY=-1.0}) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={SELECT_CRITERIA=(CustomerTag.EndDateTime > convert(CURDATE(), timestamp)) OR (CustomerTag.EndDateTime IS NULL), OUTPUT_COLS=[CustomerTag.Customer_CustomerID, CustomerTag.TagValue_TagValueID], IS_COPIED=true, EST_CARDINALITY=-1.0}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={OUTPUT_COLS=[CustomerTag.EndDateTime, CustomerTag.Customer_CustomerID, CustomerTag.TagValue_TagValueID], EST_COL_STATS={CustomerTag.CustomerTagID=[-1.0, -1.0], CustomerTag.TagValue_TagValueID=[-1.0, -1.0], CustomerTag.Customer_CustomerID=[-1.0, -1.0], CustomerTag.StartDateTime=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=[TagValue.TagValueID], CONFORMED_SOURCES=null, EST_CARDINALITY=-1.0}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TagValue.TagName_TagNameID = TagName.TagNameID], MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, EST_CARDINALITY=-1.0, OUTPUT_COLS=[TagValue.TagValueID]}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue], props={OUTPUT_COLS=[TagValue.TagName_TagNameID, TagValue.TagValueID], EST_COL_STATS={TagValue.TagValueID=[-1.0, -1.0], TagValue.TextValue=[-1.0, -1.0], TagValue.TagName_TagNameID=[-1.0, -1.0], TagValue.NumValue=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={SELECT_CRITERIA=(TagName.TagName = 'Behavior') AND (TagName.TagType_TagTypeID = 1) AND (TagName.TagScope_TagScopeID = 1), OUTPUT_COLS=[TagName.TagNameID], IS_COPIED=true, EST_CARDINALITY=-1.0}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={OUTPUT_COLS=[TagName.TagName, TagName.TagType_TagTypeID, TagName.TagScope_TagScopeID, TagName.TagNameID], EST_COL_STATS={TagName.TagNameID=[-1.0, -1.0], TagName.TagName=[-1.0, -1.0], TagName.TagType_TagTypeID=[-1.0, -1.0], TagName.DataType_DataTypeID=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) ============================================================================ EXECUTING ImplementJoinStrategy AFTER: Sort(groups=[anon_grp0]) Project(groups=[anon_grp0]) Group(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, anon_grp0, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=ENHANCED_SORT, JOIN_CRITERIA=[CustomerTag.TagValue_TagValueID = TagValue.TagValueID], LEFT_EXPRESSIONS=[CustomerTag.TagValue_TagValueID], RIGHT_EXPRESSIONS=[TagValue.TagValueID], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=-1.0, OUTPUT_COLS=[StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccount_StreamAcID], SORT_LEFT=SORT}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[Customer_CustomerID = CustomerTag.Customer_CustomerID], OUTPUT_COLS=[CustomerTag.TagValue_TagValueID, StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccount_StreamAcID], IS_COPIED=true, EST_CARDINALITY=-1.0}) Join(groups=[], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[StreamAccount_StreamChannelI = StreamChannel.StreamChannelID], LEFT_EXPRESSIONS=[StreamAccount_StreamChannelI], RIGHT_EXPRESSIONS=[StreamChannel.StreamChannelID], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=-1.0, OUTPUT_COLS=[]}) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_ST, nameInSource=null, uuid=tid:c8889da6a91d-23ce207f-00000000, OUTPUT_COLS=[StreamAccount_StreamChannelI], EST_CARDINALITY=-1.0, CONFORMED_SOURCES=null}) Sort(groups=[], props={SORT_ORDER=ORDER BY StreamAccount_StreamChannelI, OUTPUT_COLS=[StreamAccount_StreamChannelI]}) Join(groups=[], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[StreamAccount_CustomerID = Customer_CustomerID], MODEL_ID=Schema name=h2dbimplify_data_cebankModel_ST, nameInSource=null, uuid=tid:c8889da6a91d-23ce207f-00000000, EST_CARDINALITY=-1.0, OUTPUT_COLS=[StreamAccount_StreamChannelI]}) Select(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={SELECT_CRITERIA=(StreamAccount_DateTime4 >= '2015-07') AND (StreamAccount_DateTime4 <= '2016-07'), OUTPUT_COLS=[StreamAccount_CustomerID, StreamAccount_StreamChannelI], IS_COPIED=true, EST_CARDINALITY=-1.0}) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={OUTPUT_COLS=[StreamAccount_DateTime4, StreamAccount_CustomerID, StreamAccount_StreamChannelI], EST_COL_STATS={h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX.StreamAccount_CustomerID=[-1.0, -1.0], h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX.StreamAccount_Amount=[-1.0, -1.0], h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX.StreamAccount_StreamAcID=[-1.0, -1.0], h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX.StreamAccount_DateTime=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={OUTPUT_COLS=[Customer_CustomerID], EST_COL_STATS={h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView.Customer_BirthDate=[-1.0, -1.0], h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView.Customer_CustomerID=[-1.0, -1.0], h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView.Customer_Email=[-1.0, -1.0], h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView.Customer_FirstName=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=[StreamChannel.StreamChannelID], EST_CARDINALITY=-1.0}) Sort(groups=[], props={SORT_ORDER=ORDER BY StreamChannel.StreamChannelID, OUTPUT_COLS=[StreamChannel.StreamChannelID]}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel], props={OUTPUT_COLS=[StreamChannel.StreamChannelID], EST_COL_STATS={StreamChannel.StreamChannelID=[-1.0, -1.0], StreamChannel.StreamChannel=[-1.0, -1.0], StreamChannel.IDint=[-1.0, -1.0], StreamChannel.IDstring=[-1.0, -1.0]}, EST_CARDINALITY=-1.0}) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=[CustomerTag.Customer_CustomerID, CustomerTag.TagValue_TagValueID], EST_CARDINALITY=-1.0}) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={SELECT_CRITERIA=(CustomerTag.EndDateTime > convert(CURDATE(), timestamp)) OR (CustomerTag.EndDateTime IS NULL), OUTPUT_COLS=[CustomerTag.Customer_CustomerID, CustomerTag.TagValue_TagValueID], IS_COPIED=true, EST_CARDINALITY=-1.0}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={OUTPUT_COLS=[CustomerTag.EndDateTime, CustomerTag.Customer_CustomerID, CustomerTag.TagValue_TagValueID], EST_COL_STATS={CustomerTag.CustomerTagID=[-1.0, -1.0], CustomerTag.TagValue_TagValueID=[-1.0, -1.0], CustomerTag.Customer_CustomerID=[-1.0, -1.0], CustomerTag.StartDateTime=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=[TagValue.TagValueID], CONFORMED_SOURCES=null, EST_CARDINALITY=-1.0}) Sort(groups=[], props={SORT_ORDER=ORDER BY TagValue.TagValueID, OUTPUT_COLS=[TagValue.TagValueID]}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[TagValue.TagName_TagNameID = TagName.TagNameID], MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, EST_CARDINALITY=-1.0, OUTPUT_COLS=[TagValue.TagValueID]}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue], props={OUTPUT_COLS=[TagValue.TagName_TagNameID, TagValue.TagValueID], EST_COL_STATS={TagValue.TagValueID=[-1.0, -1.0], TagValue.TextValue=[-1.0, -1.0], TagValue.TagName_TagNameID=[-1.0, -1.0], TagValue.NumValue=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={SELECT_CRITERIA=(TagName.TagName = 'Behavior') AND (TagName.TagType_TagTypeID = 1) AND (TagName.TagScope_TagScopeID = 1), OUTPUT_COLS=[TagName.TagNameID], IS_COPIED=true, EST_CARDINALITY=-1.0}) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={OUTPUT_COLS=[TagName.TagName, TagName.TagType_TagTypeID, TagName.TagScope_TagScopeID, TagName.TagNameID], EST_COL_STATS={TagName.TagNameID=[-1.0, -1.0], TagName.TagName=[-1.0, -1.0], TagName.TagType_TagTypeID=[-1.0, -1.0], TagName.DataType_DataTypeID=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) ============================================================================ EXECUTING MergeCriteria AFTER: Sort(groups=[anon_grp0]) Project(groups=[anon_grp0]) Group(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, anon_grp0, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView]) Join(groups=[]) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView]) Sort(groups=[]) Join(groups=[]) Select(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel]) Sort(groups=[]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag]) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) Sort(groups=[]) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue]) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) ============================================================================ EXECUTING PlanSorts AFTER: Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco1, anon_grp0.gcol3 AS StreamChannel_StreamChannel, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco, anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco31, anon_grp0.gcol3 AS StreamChannel_StreamChannel1, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco2], OUTPUT_COLS=[anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco1, anon_grp0.gcol3 AS StreamChannel_StreamChannel, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco, anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco31, anon_grp0.gcol3 AS StreamChannel_StreamChannel1, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco2], EST_CARDINALITY=-1.0}) Group(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, anon_grp0, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={GROUP_COLS=[StreamChannel.StreamChannel, StreamAccount_StreamChannelI], SYMBOL_MAP={anon_grp0.gcol0=StreamAccount_StreamChannelI, anon_grp0.gcol1=StreamChannel.StreamChannel, anon_grp0.gcol2=StreamAccount_StreamChannelI, anon_grp0.gcol3=StreamChannel.StreamChannel, anon_grp0.agg0=SUM(StreamAccount_StreamAcID)}, OUTPUT_COLS=[anon_grp0.gcol2, anon_grp0.gcol3, anon_grp0.agg0], EST_CARDINALITY=-1.0, SORT_ORDER=ORDER BY StreamChannel_StreamChannel, StreamAccountNOSX_StreamAcco1}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=ENHANCED_SORT, JOIN_CRITERIA=[CustomerTag.TagValue_TagValueID = TagValue.TagValueID], LEFT_EXPRESSIONS=[CustomerTag.TagValue_TagValueID], RIGHT_EXPRESSIONS=[TagValue.TagValueID], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=-1.0, OUTPUT_COLS=[StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccount_StreamAcID], SORT_LEFT=SORT}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[Customer_CustomerID = CustomerTag.Customer_CustomerID], OUTPUT_COLS=[CustomerTag.TagValue_TagValueID, StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccount_StreamAcID], IS_COPIED=true, EST_CARDINALITY=-1.0}) Join(groups=[], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[StreamAccount_StreamChannelI = StreamChannel.StreamChannelID], LEFT_EXPRESSIONS=[StreamAccount_StreamChannelI], RIGHT_EXPRESSIONS=[StreamChannel.StreamChannelID], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=-1.0, OUTPUT_COLS=[]}) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView]) Sort(groups=[]) Join(groups=[]) Select(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX]) Source(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel]) Sort(groups=[]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag]) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag]) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) Sort(groups=[]) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue]) Select(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) Source(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) ============================================================================ EXECUTING CollapseSource AFTER: Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco1, anon_grp0.gcol3 AS StreamChannel_StreamChannel, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco, anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco31, anon_grp0.gcol3 AS StreamChannel_StreamChannel1, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco2], OUTPUT_COLS=[anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco1, anon_grp0.gcol3 AS StreamChannel_StreamChannel, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco, anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco31, anon_grp0.gcol3 AS StreamChannel_StreamChannel1, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco2], EST_CARDINALITY=-1.0}) Group(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, anon_grp0, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX], props={GROUP_COLS=[StreamChannel.StreamChannel, StreamAccount_StreamChannelI], SYMBOL_MAP={anon_grp0.gcol0=StreamAccount_StreamChannelI, anon_grp0.gcol1=StreamChannel.StreamChannel, anon_grp0.gcol2=StreamAccount_StreamChannelI, anon_grp0.gcol3=StreamChannel.StreamChannel, anon_grp0.agg0=SUM(StreamAccount_StreamAcID)}, OUTPUT_COLS=[anon_grp0.gcol2, anon_grp0.gcol3, anon_grp0.agg0], EST_CARDINALITY=-1.0, SORT_ORDER=ORDER BY StreamChannel_StreamChannel, StreamAccountNOSX_StreamAcco1}) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName]) Join(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel, h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag, h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView]) Join(groups=[]) Access(groups=[h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX, h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_ST, nameInSource=null, uuid=tid:c8889da6a91d-23ce207f-00000000, OUTPUT_COLS=[StreamAccount_StreamChannelI], EST_CARDINALITY=-1.0, CONFORMED_SOURCES=null, ATOMIC_REQUEST=SELECT StreamAccount_StreamChannelI FROM h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX LEFT OUTER JOIN h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView ON StreamAccount_CustomerID = Customer_CustomerID WHERE (StreamAccount_DateTime4 >= '2015-07') AND (StreamAccount_DateTime4 <= '2016-07') ORDER BY StreamAccount_StreamChannelI}) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=[StreamChannel.StreamChannelID], EST_CARDINALITY=-1.0, ATOMIC_REQUEST=SELECT StreamChannel.StreamChannelID FROM h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS StreamChannel ORDER BY StreamChannel.StreamChannelID}) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=[CustomerTag.Customer_CustomerID, CustomerTag.TagValue_TagValueID], EST_CARDINALITY=-1.0, ATOMIC_REQUEST=SELECT CustomerTag.Customer_CustomerID, CustomerTag.TagValue_TagValueID FROM h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS CustomerTag WHERE (CustomerTag.EndDateTime > convert(CURDATE(), timestamp)) OR (CustomerTag.EndDateTime IS NULL)}) Access(groups=[h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName], props={SOURCE_HINT=null, MODEL_ID=Schema name=h2dbimplify_data_cebankModel_fR, nameInSource=null, uuid=tid:c8889da6ab68-23ce22ca-00000000, OUTPUT_COLS=[TagValue.TagValueID], CONFORMED_SOURCES=null, EST_CARDINALITY=-1.0, ATOMIC_REQUEST=SELECT TagValue.TagValueID FROM h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS TagValue, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS TagName WHERE (TagValue.TagName_TagNameID = TagName.TagNameID) AND (TagName.TagName = 'Behavior') AND (TagName.TagType_TagTypeID = 1) AND (TagName.TagScope_TagScopeID = 1) ORDER BY TagValue.TagValueID}) ============================================================================ CONVERTING PLAN TREE TO PROCESS TREE PROCESS PLAN = ProjectNode(1) output=[anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco1, anon_grp0.gcol3 AS StreamChannel_StreamChannel, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco, anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco31, anon_grp0.gcol3 AS StreamChannel_StreamChannel1, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco2] [anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco1, anon_grp0.gcol3 AS StreamChannel_StreamChannel, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco, anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco31, anon_grp0.gcol3 AS StreamChannel_StreamChannel1, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco2] GroupingNode(2) output=[anon_grp0.gcol2, anon_grp0.gcol3, anon_grp0.agg0] [StreamChannel.StreamChannel, StreamAccount_StreamChannelI]{anon_grp0.gcol0=StreamAccount_StreamChannelI, anon_grp0.gcol1=StreamChannel.StreamChannel, anon_grp0.gcol2=StreamAccount_StreamChannelI, anon_grp0.gcol3=StreamChannel.StreamChannel, anon_grp0.agg0=SUM(StreamAccount_StreamAcID)} JoinNode(3) [ENHANCED SORT JOIN (SORT/ALREADY_SORTED)] [INNER JOIN] criteria=[CustomerTag.TagValue_TagValueID=TagValue.TagValueID] output=[StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccount_StreamAcID] JoinNode(4) [NESTED LOOP JOIN] [LEFT OUTER JOIN] criteria=[Customer_CustomerID = CustomerTag.Customer_CustomerID] output=[CustomerTag.TagValue_TagValueID, StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccount_StreamAcID] JoinNode(5) [MERGE JOIN (ALREADY_SORTED/ALREADY_SORTED)] [LEFT OUTER JOIN] criteria=[StreamAccount_StreamChannelI=StreamChannel.StreamChannelID] output=[] AccessNode(6) output=[StreamAccount_StreamChannelI] SELECT g_0.StreamAccount_StreamChannelI AS c_0 FROM h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX AS g_0 LEFT OUTER JOIN h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView AS g_1 ON g_0.StreamAccount_CustomerID = g_1.Customer_CustomerID WHERE (g_0.StreamAccount_DateTime4 >= '2015-07') AND (g_0.StreamAccount_DateTime4 <= '2016-07') ORDER BY c_0 AccessNode(7) output=[StreamChannel.StreamChannelID] SELECT g_0.StreamChannelID AS c_0 FROM h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS g_0 ORDER BY c_0 AccessNode(8) output=[CustomerTag.Customer_CustomerID, CustomerTag.TagValue_TagValueID] SELECT g_0.Customer_CustomerID, g_0.TagValue_TagValueID FROM h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS g_0 WHERE (g_0.EndDateTime > convert(CURDATE(), timestamp)) OR (g_0.EndDateTime IS NULL) AccessNode(9) output=[TagValue.TagValueID] SELECT g_0.TagValueID AS c_0 FROM h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS g_0, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS g_1 WHERE (g_0.TagName_TagNameID = g_1.TagNameID) AND (g_1.TagName = 'Behavior') AND (g_1.TagType_TagTypeID = 1) AND (g_1.TagScope_TagScopeID = 1) ORDER BY c_0 ============================================================================ ---------------------------------------------------------------------------- OPTIMIZATION COMPLETE: PROCESSOR PLAN: ProjectNode(1) output=[anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco1, anon_grp0.gcol3 AS StreamChannel_StreamChannel, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco, anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco31, anon_grp0.gcol3 AS StreamChannel_StreamChannel1, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco2] [anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco1, anon_grp0.gcol3 AS StreamChannel_StreamChannel, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco, anon_grp0.gcol2 AS StreamAccountNOSX_StreamAcco31, anon_grp0.gcol3 AS StreamChannel_StreamChannel1, anon_grp0.agg0 AS StreamAccountNOSX_StreamAcco2] GroupingNode(2) output=[anon_grp0.gcol2, anon_grp0.gcol3, anon_grp0.agg0] [StreamChannel.StreamChannel, StreamAccount_StreamChannelI]{anon_grp0.gcol0=StreamAccount_StreamChannelI, anon_grp0.gcol1=StreamChannel.StreamChannel, anon_grp0.gcol2=StreamAccount_StreamChannelI, anon_grp0.gcol3=StreamChannel.StreamChannel, anon_grp0.agg0=SUM(StreamAccount_StreamAcID)} JoinNode(3) [ENHANCED SORT JOIN (SORT/ALREADY_SORTED)] [INNER JOIN] criteria=[CustomerTag.TagValue_TagValueID=TagValue.TagValueID] output=[StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccount_StreamAcID] JoinNode(4) [NESTED LOOP JOIN] [LEFT OUTER JOIN] criteria=[Customer_CustomerID = CustomerTag.Customer_CustomerID] output=[CustomerTag.TagValue_TagValueID, StreamAccount_StreamChannelI, StreamChannel.StreamChannel, StreamAccount_StreamAcID] JoinNode(5) [MERGE JOIN (ALREADY_SORTED/ALREADY_SORTED)] [LEFT OUTER JOIN] criteria=[StreamAccount_StreamChannelI=StreamChannel.StreamChannelID] output=[] AccessNode(6) output=[StreamAccount_StreamChannelI] SELECT g_0.StreamAccount_StreamChannelI AS c_0 FROM h2dbimplify_data_cebankModel_ST.implify_data_cebank.StreamAccountNOSX AS g_0 LEFT OUTER JOIN h2dbimplify_data_cebankModel_ST.implify_data_cebank.CEGlobalView AS g_1 ON g_0.StreamAccount_CustomerID = g_1.Customer_CustomerID WHERE (g_0.StreamAccount_DateTime4 >= '2015-07') AND (g_0.StreamAccount_DateTime4 <= '2016-07') ORDER BY c_0 AccessNode(7) output=[StreamChannel.StreamChannelID] SELECT g_0.StreamChannelID AS c_0 FROM h2dbimplify_data_cebankModel_fR.implify_data_cebank.StreamChannel AS g_0 ORDER BY c_0 AccessNode(8) output=[CustomerTag.Customer_CustomerID, CustomerTag.TagValue_TagValueID] SELECT g_0.Customer_CustomerID, g_0.TagValue_TagValueID FROM h2dbimplify_data_cebankModel_fR.implify_data_cebank.CustomerTag AS g_0 WHERE (g_0.EndDateTime > convert(CURDATE(), timestamp)) OR (g_0.EndDateTime IS NULL) AccessNode(9) output=[TagValue.TagValueID] SELECT g_0.TagValueID AS c_0 FROM h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagValue AS g_0, h2dbimplify_data_cebankModel_fR.implify_data_cebank.TagName AS g_1 WHERE (g_0.TagName_TagNameID = g_1.TagNameID) AND (g_1.TagName = 'Behavior') AND (g_1.TagType_TagTypeID = 1) AND (g_1.TagScope_TagScopeID = 1) ORDER BY c_0 ============================================================================