Dremio cached error issues

Uncategorized
1

All physical tables and views were cached. My query use view AC to join view B, which uses cache of view A1 and view B.

While I found that Physical table C directly queries MongoDB from MongoDB log.If I remove the cache of view A1 and execute the same query again, Dremio will use the cache of view AC and view B.

Why?

query flow:

截屏2020-07-02 下午6.04.03
截屏2020-07-02 下午6.04.032114×1230 268 KB

can cached:
3960e241-3ef9-49fe-b284-277515c14779.zip (116.3 KB)

cached error:
01d81f97-a84c-47cc-b3b5-a9e11a38d753.zip (428.0 KB)

2

@leoliew

I assume when you say cached, you mean reflections. I see the below in the error profile

  • loan (mongo_bi.cash_loan)
    • Raw Reflection (raw): considered, not matched.
  • baseRepaymentPlan (mongo_bi.cash_loan)
    • Raw Reflection (raw): considered, not matched.
  • group (india_collect_mysql.cash_loan_collection)
    • Raw Reflection (raw): considered, not matched.
  • strategy_accept (share.cash_loan_project)
    • Raw Reflection (raw): considered, not matched.
  • baseLoanIdData (baseView)
    • Raw Reflection (raw): considered, matched, chosen.
  • find_group_member (orange)
    • Raw Reflection (raw): considered, not matched.
  • pass_strategy (share.cash_loan_project)
    • Raw Reflection (raw): considered, not matched.
  • repaymentPlan_View (baseView)
    • Raw Reflection (raw): considered, not matched.
  • dailyCollectionOrder_View (baseView)
    • Raw Reflection (raw): considered, not matched.
  • collectionAssignment (india_collect_mysql.cash_loan_collection)
    • Raw Reflection (raw): considered, not matched.
  • bd_loan (share.cash_loan_project)
    • Raw Reflection (raw): considered, not matched.
  • collectionAssignment_View (baseView)
    • Raw Reflection (raw): considered, matched, chosen.
  • CollectorTags (BusinessView)
    • Raw Reflection (raw): considered, not matched.
  • collector_case_amount (c0.collection)
    • Aggregation Reflection (agg): considered, not matched.
    • Raw Reflection (raw): considered, not matched.
  • repaymentPlan (mongo_bi.cash_loan)
    • Raw Reflection (raw): considered, not matched.
  • repaymentPlan (india_collect_mysql.cash_loan_collection)
    • Raw Reflection (raw): considered, not matched.
  • baseRepaymentPlan_extendInfo (mongo_bi.cash_loan)
    • Raw Reflection (raw): considered, not matched.

Which ones of the above were you expecting to be chosen?