Hello! Do you really need such huge number of fields to join? Isn't it easier to introduce an affinity field? Anyway, you seem to create an index with a huge number of fields. Consider only keeping fields which are necessary for performing that join. You might even need to boil it down to some single field (I'm not sure how actual distributedJoins is implemented).
If you could frame it as stand-alone project, somebody from community could try and tweak it until it works. Regards, -- Ilya Kasnacheev чт, 28 мар. 2019 г. в 06:23, Skollur <[email protected]>: > Hello > > I am using apache ignite 2.7 version and trying to join three tables and My > query looks as below. All tables are configured as PARTIONED and also set > "distributedjoin=true" > ============================================== > SELECT > CAS.Group_Customer_ID as groupCustomerId, > CAS.Account_Number as accountNumber, > 'Custody Account' as productTitle, > CAS.Investment_Model as investmentModel, > sum(CAS.Market_Value) AS marketValue, > CSS.Category_Sequence as sequenceNumber, > sum(ASM.Prev_Month_Bal) as preMonthBal, > sum(ASM.Prev_Year_Bal) as preYearBal > FROM > "VwCustodyAccountPositionCpsCache".VW_CUSTODY_ACCOUNT_POSITION_CPS > CAS > INNER JOIN "IdbCpsSequenceCache".IDB_CPS_SEQUENCE CSS ON > CAS.Account_Type = CSS.Account_Type > AND CAS.As_Of_Date BETWEEN '2018-12-31' AND '2018-12-31' > AND CAS.Group_Customer_ID = 61 > INNER JOIN "InvestmentSummaryMonthlyCache".ASSET_SUMMARY_MONTHLY ASM ON > CAS.Group_Customer_ID = ASM.Group_Customer_ID > AND CAS.Account_Number = ASM.Account_Number > AND CAS.As_of_Date = ASM.Effective_Date > AND CAS.Account_Type = ASM.Account_Type > AND CAS.Product = ASM.Product > AND CAS.Asset_Class_Allocation = ASM.Asset_Class > group by > CAS.Group_Customer_ID, > CAS.Account_Number, > CAS.Investment_Model, > CSS.Category_Sequence > ========================================= > I have added index for each fields which are used in each cache table as > below. Example in InvestmentSummaryMonthlyCache:- > > ArrayList<QueryIndex> indexes = new ArrayList<>(); > QueryIndex index = new QueryIndex(); > index.setName("NonClustered_Index_Summary_Monthly"); > index.setIndexType(QueryIndexType.SORTED); > LinkedHashMap<String, Boolean> indFlds = new LinkedHashMap<>(); > indFlds.put("dwId", true); > indFlds.put("groupCustomerId", true); > indFlds.put("accountNumber", true); > indFlds.put("accountType", true); > indFlds.put("product", true); > indFlds.put("productType", true); > indFlds.put("subProduct", true); > indFlds.put("assetClass", true); > indFlds.put("effectiveDate", true); > index.setFields(indFlds); > indexes.add(index); > qryEntity.setIndexes(indexes); > qryEntities.add(qryEntity); > ========================= > When I tried to execute query(I have all fields defined in index as above), > getting an error -> SQL Error [50000]: javax.cache.CacheException: Failed > to > prepare distributed join query: join condition does not use index > [joinedCache=InvestmentSummaryMonthlyCache, What am I missing here? > > > plan=SELECT > CAS__Z0.GROUP_CUSTOMER_ID AS __C0_0, > CAS__Z0.ACCOUNT_NUMBER AS __C0_1, > 'Custody Account' AS __C0_2, > CAS__Z0.INVESTMENT_MODEL AS __C0_3, > SUM(CAS__Z0.MARKET_VALUE) AS __C0_4, > CSS__Z1.CATEGORY_SEQUENCE AS __C0_5, > SUM(ASM__Z2.PREV_MONTH_BAL) AS __C0_6, > SUM(ASM__Z2.PREV_YEAR_BAL) AS __C0_7 > FROM "VwCustodyAccountPositionCpsCache".VW_CUSTODY_ACCOUNT_POSITION_CPS > CAS__Z0 > /* > "VwCustodyAccountPositionCpsCache".VW_CUSTODY_ACCOUNT_POSITION_CPS.__SCAN_ > */ > /* WHERE (CAS__Z0.AS_OF_DATE <= DATE '2018-12-31') > AND ((CAS__Z0.GROUP_CUSTOMER_ID = 80061) > AND (CAS__Z0.AS_OF_DATE >= DATE '2018-12-31')) > */ > INNER JOIN "InvestmentSummaryMonthlyCache".ASSET_SUMMARY_MONTHLY ASM__Z2 > /* batched:broadcast > "InvestmentSummaryMonthlyCache".ASSET_SUMMARY_MONTHLY.__SCAN_ */ > ON 1=1 > /* WHERE (CAS__Z0.ACCOUNT_NUMBER = ASM__Z2.ACCOUNT_NUMBER) > AND ((CAS__Z0.GROUP_CUSTOMER_ID = ASM__Z2.GROUP_CUSTOMER_ID) > AND ((CAS__Z0.AS_OF_DATE = ASM__Z2.EFFECTIVE_DATE) > AND ((CAS__Z0.ACCOUNT_TYPE = ASM__Z2.ACCOUNT_TYPE) > AND ((CAS__Z0.ASSET_CLASS_ALLOCATION = ASM__Z2.ASSET_CLASS) > AND (CAS__Z0.PRODUCT = ASM__Z2.PRODUCT))))) > */ > INNER JOIN "IdbCpsSequenceCache".IDB_CPS_SEQUENCE CSS__Z1 > /* batched:broadcast "IdbCpsSequenceCache".NONCLUSTERED_INDEX_LC: > ACCOUNT_TYPE = CAS__Z0.ACCOUNT_TYPE */ > ON 1=1 > WHERE ((CAS__Z0.GROUP_CUSTOMER_ID = 80061) > AND ((CAS__Z0.ACCOUNT_TYPE = CSS__Z1.ACCOUNT_TYPE) > AND ((CAS__Z0.AS_OF_DATE >= DATE '2018-12-31') > AND (CAS__Z0.AS_OF_DATE <= DATE '2018-12-31')))) > AND ((CAS__Z0.ASSET_CLASS_ALLOCATION = ASM__Z2.ASSET_CLASS) > AND ((CAS__Z0.PRODUCT = ASM__Z2.PRODUCT) > AND ((CAS__Z0.ACCOUNT_TYPE = ASM__Z2.ACCOUNT_TYPE) > AND ((CAS__Z0.AS_OF_DATE = ASM__Z2.EFFECTIVE_DATE) > AND ((CAS__Z0.GROUP_CUSTOMER_ID = ASM__Z2.GROUP_CUSTOMER_ID) > AND (CAS__Z0.ACCOUNT_NUMBER = ASM__Z2.ACCOUNT_NUMBER)))))) > GROUP BY CAS__Z0.GROUP_CUSTOMER_ID, CAS__Z0.ACCOUNT_NUMBER, > CAS__Z0.INVESTMENT_MODEL, CSS__Z1.CATEGORY_SEQUENCE] > SQL Error [50000]: javax.cache.CacheException: Failed to prepare > distributed join query: join condition does not use index > [joinedCache=InvestmentSummaryMonthlyCache, plan=SELECT > CAS__Z0.GROUP_CUSTOMER_ID AS __C0_0, > CAS__Z0.ACCOUNT_NUMBER AS __C0_1, > 'Custody Account' AS __C0_2, > CAS__Z0.INVESTMENT_MODEL AS __C0_3, > SUM(CAS__Z0.MARKET_VALUE) AS __C0_4, > CSS__Z1.CATEGORY_SEQUENCE AS __C0_5, > SUM(ASM__Z2.PREV_MONTH_BAL) AS __C0_6, > SUM(ASM__Z2.PREV_YEAR_BAL) AS __C0_7 > FROM "VwCustodyAccountPositionCpsCache".VW_CUSTODY_ACCOUNT_POSITION_CPS > CAS__Z0 > /* > "VwCustodyAccountPositionCpsCache".VW_CUSTODY_ACCOUNT_POSITION_CPS.__SCAN_ > */ > /* WHERE (CAS__Z0.AS_OF_DATE <= DATE '2018-12-31') > AND ((CAS__Z0.GROUP_CUSTOMER_ID = 80061) > AND (CAS__Z0.AS_OF_DATE >= DATE '2018-12-31')) > */ > INNER JOIN "InvestmentSummaryMonthlyCache".ASSET_SUMMARY_MONTHLY ASM__Z2 > /* batched:broadcast > "InvestmentSummaryMonthlyCache".ASSET_SUMMARY_MONTHLY.__SCAN_ */ > ON 1=1 > /* WHERE (CAS__Z0.ACCOUNT_NUMBER = ASM__Z2.ACCOUNT_NUMBER) > AND ((CAS__Z0.GROUP_CUSTOMER_ID = ASM__Z2.GROUP_CUSTOMER_ID) > AND ((CAS__Z0.AS_OF_DATE = ASM__Z2.EFFECTIVE_DATE) > AND ((CAS__Z0.ACCOUNT_TYPE = ASM__Z2.ACCOUNT_TYPE) > AND ((CAS__Z0.ASSET_CLASS_ALLOCATION = ASM__Z2.ASSET_CLASS) > AND (CAS__Z0.PRODUCT = ASM__Z2.PRODUCT))))) > */ > INNER JOIN "IdbCpsSequenceCache".IDB_CPS_SEQUENCE CSS__Z1 > /* batched:broadcast "IdbCpsSequenceCache".NONCLUSTERED_INDEX_LC: > ACCOUNT_TYPE = CAS__Z0.ACCOUNT_TYPE */ > ON 1=1 > WHERE ((CAS__Z0.GROUP_CUSTOMER_ID = 80061) > AND ((CAS__Z0.ACCOUNT_TYPE = CSS__Z1.ACCOUNT_TYPE) > AND ((CAS__Z0.AS_OF_DATE >= DATE '2018-12-31') > AND (CAS__Z0.AS_OF_DATE <= DATE '2018-12-31')))) > AND ((CAS__Z0.ASSET_CLASS_ALLOCATION = ASM__Z2.ASSET_CLASS) > AND ((CAS__Z0.PRODUCT = ASM__Z2.PRODUCT) > AND ((CAS__Z0.ACCOUNT_TYPE = ASM__Z2.ACCOUNT_TYPE) > AND ((CAS__Z0.AS_OF_DATE = ASM__Z2.EFFECTIVE_DATE) > AND ((CAS__Z0.GROUP_CUSTOMER_ID = ASM__Z2.GROUP_CUSTOMER_ID) > AND (CAS__Z0.ACCOUNT_NUMBER = ASM__Z2.ACCOUNT_NUMBER)))))) > GROUP BY CAS__Z0.GROUP_CUSTOMER_ID, CAS__Z0.ACCOUNT_NUMBER, > CAS__Z0.INVESTMENT_MODEL, CSS__Z1.CATEGORY_SEQUENCE] > SQL Error [50000]: javax.cache.CacheException: Failed to prepare > distributed join query: join condition does not use index > [joinedCache=InvestmentSummaryMonthlyCache, plan=SELECT > CAS__Z0.GROUP_CUSTOMER_ID AS __C0_0, > CAS__Z0.ACCOUNT_NUMBER AS __C0_1, > 'Custody Account' AS __C0_2, > CAS__Z0.INVESTMENT_MODEL AS __C0_3, > SUM(CAS__Z0.MARKET_VALUE) AS __C0_4, > CSS__Z1.CATEGORY_SEQUENCE AS __C0_5, > SUM(ASM__Z2.PREV_MONTH_BAL) AS __C0_6, > SUM(ASM__Z2.PREV_YEAR_BAL) AS __C0_7 > FROM "VwCustodyAccountPositionCpsCache".VW_CUSTODY_ACCOUNT_POSITION_CPS > CAS__Z0 > /* > "VwCustodyAccountPositionCpsCache".VW_CUSTODY_ACCOUNT_POSITION_CPS.__SCAN_ > */ > /* WHERE (CAS__Z0.AS_OF_DATE <= DATE '2018-12-31') > AND ((CAS__Z0.GROUP_CUSTOMER_ID = 80061) > AND (CAS__Z0.AS_OF_DATE >= DATE '2018-12-31')) > */ > INNER JOIN "InvestmentSummaryMonthlyCache".ASSET_SUMMARY_MONTHLY ASM__Z2 > /* batched:broadcast > "InvestmentSummaryMonthlyCache".ASSET_SUMMARY_MONTHLY.__SCAN_ */ > ON 1=1 > /* WHERE (CAS__Z0.ACCOUNT_NUMBER = ASM__Z2.ACCOUNT_NUMBER) > AND ((CAS__Z0.GROUP_CUSTOMER_ID = ASM__Z2.GROUP_CUSTOMER_ID) > AND ((CAS__Z0.AS_OF_DATE = ASM__Z2.EFFECTIVE_DATE) > AND ((CAS__Z0.ACCOUNT_TYPE = ASM__Z2.ACCOUNT_TYPE) > AND ((CAS__Z0.ASSET_CLASS_ALLOCATION = ASM__Z2.ASSET_CLASS) > AND (CAS__Z0.PRODUCT = ASM__Z2.PRODUCT))))) > */ > INNER JOIN "IdbCpsSequenceCache".IDB_CPS_SEQUENCE CSS__Z1 > /* batched:broadcast "IdbCpsSequenceCache".NONCLUSTERED_INDEX_LC: > ACCOUNT_TYPE = CAS__Z0.ACCOUNT_TYPE */ > ON 1=1 > WHERE ((CAS__Z0.GROUP_CUSTOMER_ID = 80061) > AND ((CAS__Z0.ACCOUNT_TYPE = CSS__Z1.ACCOUNT_TYPE) > AND ((CAS__Z0.AS_OF_DATE >= DATE '2018-12-31') > AND (CAS__Z0.AS_OF_DATE <= DATE '2018-12-31')))) > AND ((CAS__Z0.ASSET_CLASS_ALLOCATION = ASM__Z2.ASSET_CLASS) > AND ((CAS__Z0.PRODUCT = ASM__Z2.PRODUCT) > AND ((CAS__Z0.ACCOUNT_TYPE = ASM__Z2.ACCOUNT_TYPE) > AND ((CAS__Z0.AS_OF_DATE = ASM__Z2.EFFECTIVE_DATE) > AND ((CAS__Z0.GROUP_CUSTOMER_ID = ASM__Z2.GROUP_CUSTOMER_ID) > AND (CAS__Z0.ACCOUNT_NUMBER = ASM__Z2.ACCOUNT_NUMBER)))))) > GROUP BY CAS__Z0.GROUP_CUSTOMER_ID, CAS__Z0.ACCOUNT_NUMBER, > CAS__Z0.INVESTMENT_MODEL, CSS__Z1.CATEGORY_SEQUENCE] > SQL Error [50000]: javax.cache.CacheException: Failed to prepare > distributed join query: join condition does not use index > [joinedCache=InvestmentSummaryMonthlyCache, plan=SELECT > CAS__Z0.GROUP_CUSTOMER_ID AS __C0_0, > CAS__Z0.ACCOUNT_NUMBER AS __C0_1, > 'Custody Account' AS __C0_2, > CAS__Z0.INVESTMENT_MODEL AS __C0_3, > SUM(CAS__Z0.MARKET_VALUE) AS __C0_4, > CSS__Z1.CATEGORY_SEQUENCE AS __C0_5, > SUM(ASM__Z2.PREV_MONTH_BAL) AS __C0_6, > SUM(ASM__Z2.PREV_YEAR_BAL) AS __C0_7 > FROM "VwCustodyAccountPositionCpsCache".VW_CUSTODY_ACCOUNT_POSITION_CPS > CAS__Z0 > /* > "VwCustodyAccountPositionCpsCache".VW_CUSTODY_ACCOUNT_POSITION_CPS.__SCAN_ > */ > /* WHERE (CAS__Z0.AS_OF_DATE <= DATE '2018-12-31') > AND ((CAS__Z0.GROUP_CUSTOMER_ID = 80061) > AND (CAS__Z0.AS_OF_DATE >= DATE '2018-12-31')) > */ > INNER JOIN "InvestmentSummaryMonthlyCache".ASSET_SUMMARY_MONTHLY ASM__Z2 > /* batched:broadcast > "InvestmentSummaryMonthlyCache".ASSET_SUMMARY_MONTHLY.__SCAN_ */ > ON 1=1 > /* WHERE (CAS__Z0.ACCOUNT_NUMBER = ASM__Z2.ACCOUNT_NUMBER) > AND ((CAS__Z0.GROUP_CUSTOMER_ID = ASM__Z2.GROUP_CUSTOMER_ID) > AND ((CAS__Z0.AS_OF_DATE = ASM__Z2.EFFECTIVE_DATE) > AND ((CAS__Z0.ACCOUNT_TYPE = ASM__Z2.ACCOUNT_TYPE) > AND ((CAS__Z0.ASSET_CLASS_ALLOCATION = ASM__Z2.ASSET_CLASS) > AND (CAS__Z0.PRODUCT = ASM__Z2.PRODUCT))))) > */ > INNER JOIN "IdbCpsSequenceCache".IDB_CPS_SEQUENCE CSS__Z1 > /* batched:broadcast "IdbCpsSequenceCache".NONCLUSTERED_INDEX_LC: > ACCOUNT_TYPE = CAS__Z0.ACCOUNT_TYPE */ > ON 1=1 > WHERE ((CAS__Z0.GROUP_CUSTOMER_ID = 80061) > AND ((CAS__Z0.ACCOUNT_TYPE = CSS__Z1.ACCOUNT_TYPE) > AND ((CAS__Z0.AS_OF_DATE >= DATE '2018-12-31') > AND (CAS__Z0.AS_OF_DATE <= DATE '2018-12-31')))) > AND ((CAS__Z0.ASSET_CLASS_ALLOCATION = ASM__Z2.ASSET_CLASS) > AND ((CAS__Z0.PRODUCT = ASM__Z2.PRODUCT) > AND ((CAS__Z0.ACCOUNT_TYPE = ASM__Z2.ACCOUNT_TYPE) > AND ((CAS__Z0.AS_OF_DATE = ASM__Z2.EFFECTIVE_DATE) > AND ((CAS__Z0.GROUP_CUSTOMER_ID = ASM__Z2.GROUP_CUSTOMER_ID) > AND (CAS__Z0.ACCOUNT_NUMBER = ASM__Z2.ACCOUNT_NUMBER)))))) > GROUP BY CAS__Z0.GROUP_CUSTOMER_ID, CAS__Z0.ACCOUNT_NUMBER, > CAS__Z0.INVESTMENT_MODEL, CSS__Z1.CATEGORY_SEQUENCE] > javax.cache.CacheException: Failed to prepare distributed join > query: join condition does not use index > [joinedCache=InvestmentSummaryMonthlyCache, plan=SELECT > CAS__Z0.GROUP_CUSTOMER_ID AS __C0_0, > CAS__Z0.ACCOUNT_NUMBER AS __C0_1, > 'Custody Account' AS __C0_2, > CAS__Z0.INVESTMENT_MODEL AS __C0_3, > SUM(CAS__Z0.MARKET_VALUE) AS __C0_4, > CSS__Z1.CATEGORY_SEQUENCE AS __C0_5, > SUM(ASM__Z2.PREV_MONTH_BAL) AS __C0_6, > SUM(ASM__Z2.PREV_YEAR_BAL) AS __C0_7 > FROM "VwCustodyAccountPositionCpsCache".VW_CUSTODY_ACCOUNT_POSITION_CPS > CAS__Z0 > /* > "VwCustodyAccountPositionCpsCache".VW_CUSTODY_ACCOUNT_POSITION_CPS.__SCAN_ > */ > /* WHERE (CAS__Z0.AS_OF_DATE <= DATE '2018-12-31') > AND ((CAS__Z0.GROUP_CUSTOMER_ID = 80061) > AND (CAS__Z0.AS_OF_DATE >= DATE '2018-12-31')) > */ > INNER JOIN "InvestmentSummaryMonthlyCache".ASSET_SUMMARY_MONTHLY ASM__Z2 > /* batched:broadcast > "InvestmentSummaryMonthlyCache".ASSET_SUMMARY_MONTHLY.__SCAN_ */ > ON 1=1 > /* WHERE (CAS__Z0.ACCOUNT_NUMBER = ASM__Z2.ACCOUNT_NUMBER) > AND ((CAS__Z0.GROUP_CUSTOMER_ID = ASM__Z2.GROUP_CUSTOMER_ID) > AND ((CAS__Z0.AS_OF_DATE = ASM__Z2.EFFECTIVE_DATE) > AND ((CAS__Z0.ACCOUNT_TYPE = ASM__Z2.ACCOUNT_TYPE) > AND ((CAS__Z0.ASSET_CLASS_ALLOCATION = ASM__Z2.ASSET_CLASS) > AND (CAS__Z0.PRODUCT = ASM__Z2.PRODUCT))))) > */ > INNER JOIN "IdbCpsSequenceCache".IDB_CPS_SEQUENCE CSS__Z1 > /* batched:broadcast "IdbCpsSequenceCache".NONCLUSTERED_INDEX_LC: > ACCOUNT_TYPE = CAS__Z0.ACCOUNT_TYPE */ > ON 1=1 > WHERE ((CAS__Z0.GROUP_CUSTOMER_ID = 80061) > AND ((CAS__Z0.ACCOUNT_TYPE = CSS__Z1.ACCOUNT_TYPE) > AND ((CAS__Z0.AS_OF_DATE >= DATE '2018-12-31') > AND (CAS__Z0.AS_OF_DATE <= DATE '2018-12-31')))) > AND ((CAS__Z0.ASSET_CLASS_ALLOCATION = ASM__Z2.ASSET_CLASS) > AND ((CAS__Z0.PRODUCT = ASM__Z2.PRODUCT) > AND ((CAS__Z0.ACCOUNT_TYPE = ASM__Z2.ACCOUNT_TYPE) > AND ((CAS__Z0.AS_OF_DATE = ASM__Z2.EFFECTIVE_DATE) > AND ((CAS__Z0.GROUP_CUSTOMER_ID = ASM__Z2.GROUP_CUSTOMER_ID) > AND (CAS__Z0.ACCOUNT_NUMBER = ASM__Z2.ACCOUNT_NUMBER)))))) > GROUP BY CAS__Z0.GROUP_CUSTOMER_ID, CAS__Z0.ACCOUNT_NUMBER, > CAS__Z0.INVESTMENT_MODEL, CSS__Z1.CATEGORY_SEQUENCE] > javax.cache.CacheException: Failed to prepare distributed join > query: join condition does not use index > [joinedCache=InvestmentSummaryMonthlyCache, plan=SELECT > CAS__Z0.GROUP_CUSTOMER_ID AS __C0_0, > CAS__Z0.ACCOUNT_NUMBER AS __C0_1, > 'Custody Account' AS __C0_2, > CAS__Z0.INVESTMENT_MODEL AS __C0_3, > SUM(CAS__Z0.MARKET_VALUE) AS __C0_4, > CSS__Z1.CATEGORY_SEQUENCE AS __C0_5, > SUM(ASM__Z2.PREV_MONTH_BAL) AS __C0_6, > SUM(ASM__Z2.PREV_YEAR_BAL) AS __C0_7 > FROM "VwCustodyAccountPositionCpsCache".VW_CUSTODY_ACCOUNT_POSITION_CPS > CAS__Z0 > /* > "VwCustodyAccountPositionCpsCache".VW_CUSTODY_ACCOUNT_POSITION_CPS.__SCAN_ > */ > /* WHERE (CAS__Z0.AS_OF_DATE <= DATE '2018-12-31') > AND ((CAS__Z0.GROUP_CUSTOMER_ID = 80061) > AND (CAS__Z0.AS_OF_DATE >= DATE '2018-12-31')) > */ > INNER JOIN "InvestmentSummaryMonthlyCache".ASSET_SUMMARY_MONTHLY ASM__Z2 > /* batched:broadcast > "InvestmentSummaryMonthlyCache".ASSET_SUMMARY_MONTHLY.__SCAN_ */ > ON 1=1 > /* WHERE (CAS__Z0.ACCOUNT_NUMBER = ASM__Z2.ACCOUNT_NUMBER) > AND ((CAS__Z0.GROUP_CUSTOMER_ID = ASM__Z2.GROUP_CUSTOMER_ID) > AND ((CAS__Z0.AS_OF_DATE = ASM__Z2.EFFECTIVE_DATE) > AND ((CAS__Z0.ACCOUNT_TYPE = ASM__Z2.ACCOUNT_TYPE) > AND ((CAS__Z0.ASSET_CLASS_ALLOCATION = ASM__Z2.ASSET_CLASS) > AND (CAS__Z0.PRODUCT = ASM__Z2.PRODUCT))))) > */ > INNER JOIN "IdbCpsSequenceCache".IDB_CPS_SEQUENCE CSS__Z1 > /* batched:broadcast "IdbCpsSequenceCache".NONCLUSTERED_INDEX_LC: > ACCOUNT_TYPE = CAS__Z0.ACCOUNT_TYPE */ > ON 1=1 > WHERE ((CAS__Z0.GROUP_CUSTOMER_ID = 80061) > AND ((CAS__Z0.ACCOUNT_TYPE = CSS__Z1.ACCOUNT_TYPE) > AND ((CAS__Z0.AS_OF_DATE >= DATE '2018-12-31') > AND (CAS__Z0.AS_OF_DATE <= DATE '2018-12-31')))) > AND ((CAS__Z0.ASSET_CLASS_ALLOCATION = ASM__Z2.ASSET_CLASS) > AND ((CAS__Z0.PRODUCT = ASM__Z2.PRODUCT) > AND ((CAS__Z0.ACCOUNT_TYPE = ASM__Z2.ACCOUNT_TYPE) > AND ((CAS__Z0.AS_OF_DATE = ASM__Z2.EFFECTIVE_DATE) > AND ((CAS__Z0.GROUP_CUSTOMER_ID = ASM__Z2.GROUP_CUSTOMER_ID) > AND (CAS__Z0.ACCOUNT_NUMBER = ASM__Z2.ACCOUNT_NUMBER)))))) > GROUP BY CAS__Z0.GROUP_CUSTOMER_ID, CAS__Z0.ACCOUNT_NUMBER, > CAS__Z0.INVESTMENT_MODEL, CSS__Z1.CATEGORY_SEQUENCE] > > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
