============================================================================ USER COMMAND: SELECT SugarCRMDataSource_public_sales_location.country AS SugarCRMDataSource_public_sales_location_country, FoodmartDataSource_public_store.store_country AS FoodmartDataSource_public_store_store_country, '1|1' AS JS_Discriminator_COL, COUNT(DISTINCT SugarCRMDataSource_public_sales_fact.amount) AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount FROM (SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact INNER JOIN SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location ON SugarCRMDataSource_public_sales_fact.sales_location_id = SugarCRMDataSource_public_sales_location.id) INNER JOIN FoodmartDataSource_public.store AS FoodmartDataSource_public_store ON SugarCRMDataSource_public_sales_location.state = FoodmartDataSource_public_store.store_state GROUP BY SugarCRMDataSource_public_sales_location.country, FoodmartDataSource_public_store.store_country UNION ALL SELECT SugarCRMDataSource_public_sales_location.country AS SugarCRMDataSource_public_sales_location_country, null AS FoodmartDataSource_public_store_store_country, '1|0' AS JS_Discriminator_COL, COUNT(DISTINCT SugarCRMDataSource_public_sales_fact.amount) AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount FROM (SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact INNER JOIN SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location ON SugarCRMDataSource_public_sales_fact.sales_location_id = SugarCRMDataSource_public_sales_location.id) INNER JOIN FoodmartDataSource_public.store AS FoodmartDataSource_public_store ON SugarCRMDataSource_public_sales_location.state = FoodmartDataSource_public_store.store_state GROUP BY SugarCRMDataSource_public_sales_location.country UNION ALL SELECT null AS SugarCRMDataSource_public_sales_location_country, FoodmartDataSource_public_store.store_country AS FoodmartDataSource_public_store_store_country, '0|1' AS JS_Discriminator_COL, COUNT(DISTINCT SugarCRMDataSource_public_sales_fact.amount) AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount FROM (SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact INNER JOIN SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location ON SugarCRMDataSource_public_sales_fact.sales_location_id = SugarCRMDataSource_public_sales_location.id) INNER JOIN FoodmartDataSource_public.store AS FoodmartDataSource_public_store ON SugarCRMDataSource_public_sales_location.state = FoodmartDataSource_public_store.store_state GROUP BY FoodmartDataSource_public_store.store_country UNION ALL SELECT null AS SugarCRMDataSource_public_sales_location_country, null AS FoodmartDataSource_public_store_store_country, '0|0' AS JS_Discriminator_COL, COUNT(DISTINCT SugarCRMDataSource_public_sales_fact.amount) AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount FROM (SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact INNER JOIN SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location ON SugarCRMDataSource_public_sales_fact.sales_location_id = SugarCRMDataSource_public_sales_location.id) INNER JOIN FoodmartDataSource_public.store AS FoodmartDataSource_public_store ON SugarCRMDataSource_public_sales_location.state = FoodmartDataSource_public_store.store_state ORDER BY SugarCRMDataSource_public_sales_location_country, FoodmartDataSource_public_store_store_country LIMIT 1000 ---------------------------------------------------------------------------- OPTIMIZE: SELECT SugarCRMDataSource_public_sales_location.country AS SugarCRMDataSource_public_sales_location_country, FoodmartDataSource_public_store.store_country AS FoodmartDataSource_public_store_store_country, '1|1' AS JS_Discriminator_COL, COUNT(DISTINCT SugarCRMDataSource_public_sales_fact.amount) AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount FROM (SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact INNER JOIN SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location ON SugarCRMDataSource_public_sales_fact.sales_location_id = SugarCRMDataSource_public_sales_location.id) INNER JOIN FoodmartDataSource_public.store AS FoodmartDataSource_public_store ON SugarCRMDataSource_public_sales_location.state = FoodmartDataSource_public_store.store_state GROUP BY SugarCRMDataSource_public_sales_location.country, FoodmartDataSource_public_store.store_country UNION ALL SELECT SugarCRMDataSource_public_sales_location.country AS SugarCRMDataSource_public_sales_location_country, null AS FoodmartDataSource_public_store_store_country, '1|0' AS JS_Discriminator_COL, COUNT(DISTINCT SugarCRMDataSource_public_sales_fact.amount) AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount FROM (SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact INNER JOIN SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location ON SugarCRMDataSource_public_sales_fact.sales_location_id = SugarCRMDataSource_public_sales_location.id) INNER JOIN FoodmartDataSource_public.store AS FoodmartDataSource_public_store ON SugarCRMDataSource_public_sales_location.state = FoodmartDataSource_public_store.store_state GROUP BY SugarCRMDataSource_public_sales_location.country UNION ALL SELECT null AS SugarCRMDataSource_public_sales_location_country, FoodmartDataSource_public_store.store_country AS FoodmartDataSource_public_store_store_country, '0|1' AS JS_Discriminator_COL, COUNT(DISTINCT SugarCRMDataSource_public_sales_fact.amount) AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount FROM (SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact INNER JOIN SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location ON SugarCRMDataSource_public_sales_fact.sales_location_id = SugarCRMDataSource_public_sales_location.id) INNER JOIN FoodmartDataSource_public.store AS FoodmartDataSource_public_store ON SugarCRMDataSource_public_sales_location.state = FoodmartDataSource_public_store.store_state GROUP BY FoodmartDataSource_public_store.store_country UNION ALL SELECT null AS SugarCRMDataSource_public_sales_location_country, null AS FoodmartDataSource_public_store_store_country, '0|0' AS JS_Discriminator_COL, COUNT(DISTINCT SugarCRMDataSource_public_sales_fact.amount) AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount FROM (SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact INNER JOIN SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location ON SugarCRMDataSource_public_sales_fact.sales_location_id = SugarCRMDataSource_public_sales_location.id) INNER JOIN FoodmartDataSource_public.store AS FoodmartDataSource_public_store ON SugarCRMDataSource_public_sales_location.state = FoodmartDataSource_public_store.store_state ORDER BY SugarCRMDataSource_public_sales_location_country, FoodmartDataSource_public_store_store_country LIMIT 1000 ---------------------------------------------------------------------------- GENERATE CANONICAL: SELECT SugarCRMDataSource_public_sales_location.country AS SugarCRMDataSource_public_sales_location_country, FoodmartDataSource_public_store.store_country AS FoodmartDataSource_public_store_store_country, '1|1' AS JS_Discriminator_COL, COUNT(DISTINCT SugarCRMDataSource_public_sales_fact.amount) AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount FROM (SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact INNER JOIN SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location ON SugarCRMDataSource_public_sales_fact.sales_location_id = SugarCRMDataSource_public_sales_location.id) INNER JOIN FoodmartDataSource_public.store AS FoodmartDataSource_public_store ON SugarCRMDataSource_public_sales_location.state = FoodmartDataSource_public_store.store_state GROUP BY SugarCRMDataSource_public_sales_location.country, FoodmartDataSource_public_store.store_country UNION ALL SELECT SugarCRMDataSource_public_sales_location.country AS SugarCRMDataSource_public_sales_location_country, null AS FoodmartDataSource_public_store_store_country, '1|0' AS JS_Discriminator_COL, COUNT(DISTINCT SugarCRMDataSource_public_sales_fact.amount) AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount FROM (SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact INNER JOIN SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location ON SugarCRMDataSource_public_sales_fact.sales_location_id = SugarCRMDataSource_public_sales_location.id) INNER JOIN FoodmartDataSource_public.store AS FoodmartDataSource_public_store ON SugarCRMDataSource_public_sales_location.state = FoodmartDataSource_public_store.store_state GROUP BY SugarCRMDataSource_public_sales_location.country UNION ALL SELECT null AS SugarCRMDataSource_public_sales_location_country, FoodmartDataSource_public_store.store_country AS FoodmartDataSource_public_store_store_country, '0|1' AS JS_Discriminator_COL, COUNT(DISTINCT SugarCRMDataSource_public_sales_fact.amount) AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount FROM (SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact INNER JOIN SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location ON SugarCRMDataSource_public_sales_fact.sales_location_id = SugarCRMDataSource_public_sales_location.id) INNER JOIN FoodmartDataSource_public.store AS FoodmartDataSource_public_store ON SugarCRMDataSource_public_sales_location.state = FoodmartDataSource_public_store.store_state GROUP BY FoodmartDataSource_public_store.store_country UNION ALL SELECT null AS SugarCRMDataSource_public_sales_location_country, null AS FoodmartDataSource_public_store_store_country, '0|0' AS JS_Discriminator_COL, COUNT(DISTINCT SugarCRMDataSource_public_sales_fact.amount) AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount FROM (SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact INNER JOIN SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location ON SugarCRMDataSource_public_sales_fact.sales_location_id = SugarCRMDataSource_public_sales_location.id) INNER JOIN FoodmartDataSource_public.store AS FoodmartDataSource_public_store ON SugarCRMDataSource_public_sales_location.state = FoodmartDataSource_public_store.store_state ORDER BY SugarCRMDataSource_public_sales_location_country, FoodmartDataSource_public_store_store_country LIMIT 1000 CANONICAL PLAN: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1000}) Sort(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location], props={SORT_ORDER=ORDER BY SugarCRMDataSource_public_sales_location_country, FoodmartDataSource_public_store_store_country}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS SugarCRMDataSource_public_sales_location_country, anon_grp0.gcol1 AS FoodmartDataSource_public_store_store_country, '1|1' AS JS_Discriminator_COL, anon_grp0.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount]}) Group(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, anon_grp0], props={GROUP_COLS=[SugarCRMDataSource_public_sales_location.country, FoodmartDataSource_public_store.store_country], SYMBOL_MAP={anon_grp0.gcol0=SugarCRMDataSource_public_sales_location.country, anon_grp0.gcol1=FoodmartDataSource_public_store.store_country, anon_grp0.agg0=COUNT(DISTINCT SugarCRMDataSource_public_sales_fact.amount)}}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, FoodmartDataSource_public.store AS FoodmartDataSource_public_store], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location.state = FoodmartDataSource_public_store.store_state]}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact.sales_location_id = SugarCRMDataSource_public_sales_location.id]}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store]) Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.gcol0 AS SugarCRMDataSource_public_sales_location_country, null AS FoodmartDataSource_public_store_store_country, '1|0' AS JS_Discriminator_COL, anon_grp1.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount]}) Group(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, anon_grp1], props={GROUP_COLS=[SugarCRMDataSource_public_sales_location.country], SYMBOL_MAP={anon_grp1.gcol0=SugarCRMDataSource_public_sales_location.country, anon_grp1.agg0=COUNT(DISTINCT SugarCRMDataSource_public_sales_fact.amount)}}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, FoodmartDataSource_public.store AS FoodmartDataSource_public_store], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location.state = FoodmartDataSource_public_store.store_state]}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact.sales_location_id = SugarCRMDataSource_public_sales_location.id]}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store]) Project(groups=[anon_grp2], props={PROJECT_COLS=[null AS SugarCRMDataSource_public_sales_location_country, anon_grp2.gcol0 AS FoodmartDataSource_public_store_store_country, '0|1' AS JS_Discriminator_COL, anon_grp2.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount]}) Group(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, anon_grp2], props={GROUP_COLS=[FoodmartDataSource_public_store.store_country], SYMBOL_MAP={anon_grp2.gcol0=FoodmartDataSource_public_store.store_country, anon_grp2.agg0=COUNT(DISTINCT SugarCRMDataSource_public_sales_fact.amount)}}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, FoodmartDataSource_public.store AS FoodmartDataSource_public_store], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location.state = FoodmartDataSource_public_store.store_state]}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact.sales_location_id = SugarCRMDataSource_public_sales_location.id]}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store]) Project(groups=[anon_grp3], props={PROJECT_COLS=[null AS SugarCRMDataSource_public_sales_location_country, null AS FoodmartDataSource_public_store_store_country, '0|0' AS JS_Discriminator_COL, anon_grp3.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount]}) Group(groups=[anon_grp3], props={SYMBOL_MAP={anon_grp3.agg0=COUNT(DISTINCT SugarCRMDataSource_public_sales_fact.amount)}}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, FoodmartDataSource_public.store AS FoodmartDataSource_public_store], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location.state = FoodmartDataSource_public_store.store_state]}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact.sales_location_id = SugarCRMDataSource_public_sales_location.id]}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store]) ============================================================================ EXECUTING PlaceAccess AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1000}) Sort(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location], props={SORT_ORDER=ORDER BY SugarCRMDataSource_public_sales_location_country, FoodmartDataSource_public_store_store_country}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS SugarCRMDataSource_public_sales_location_country, anon_grp0.gcol1 AS FoodmartDataSource_public_store_store_country, '1|1' AS JS_Discriminator_COL, anon_grp0.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount]}) Group(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, anon_grp0], props={GROUP_COLS=[SugarCRMDataSource_public_sales_location.country, FoodmartDataSource_public_store.store_country], SYMBOL_MAP={anon_grp0.gcol0=SugarCRMDataSource_public_sales_location.country, anon_grp0.gcol1=FoodmartDataSource_public_store.store_country, anon_grp0.agg0=COUNT(DISTINCT SugarCRMDataSource_public_sales_fact.amount)}}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, FoodmartDataSource_public.store AS FoodmartDataSource_public_store], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location.state = FoodmartDataSource_public_store.store_state]}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact.sales_location_id = SugarCRMDataSource_public_sales_location.id]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact]) Access(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000}) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store]) Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.gcol0 AS SugarCRMDataSource_public_sales_location_country, null AS FoodmartDataSource_public_store_store_country, '1|0' AS JS_Discriminator_COL, anon_grp1.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount]}) Group(groups=[anon_grp1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1], props={GROUP_COLS=[SugarCRMDataSource_public_sales_location__1.country], SYMBOL_MAP={anon_grp1.gcol0=SugarCRMDataSource_public_sales_location__1.country, anon_grp1.agg0=COUNT(DISTINCT SugarCRMDataSource_public_sales_fact__1.amount)}}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__1.state = FoodmartDataSource_public_store__1.store_state]}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact__1.sales_location_id = SugarCRMDataSource_public_sales_location__1.id]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1]) Access(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000}) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1]) Project(groups=[anon_grp2], props={PROJECT_COLS=[null AS SugarCRMDataSource_public_sales_location_country, anon_grp2.gcol0 AS FoodmartDataSource_public_store_store_country, '0|1' AS JS_Discriminator_COL, anon_grp2.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount]}) Group(groups=[anon_grp2, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2], props={GROUP_COLS=[FoodmartDataSource_public_store__2.store_country], SYMBOL_MAP={anon_grp2.gcol0=FoodmartDataSource_public_store__2.store_country, anon_grp2.agg0=COUNT(DISTINCT SugarCRMDataSource_public_sales_fact__2.amount)}}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__2.state = FoodmartDataSource_public_store__2.store_state]}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact__2.sales_location_id = SugarCRMDataSource_public_sales_location__2.id]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2]) Access(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000}) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) Project(groups=[anon_grp3], props={PROJECT_COLS=[null AS SugarCRMDataSource_public_sales_location_country, null AS FoodmartDataSource_public_store_store_country, '0|0' AS JS_Discriminator_COL, anon_grp3.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount]}) Group(groups=[anon_grp3], props={SYMBOL_MAP={anon_grp3.agg0=COUNT(DISTINCT SugarCRMDataSource_public_sales_fact__3.amount)}}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__3.state = FoodmartDataSource_public_store__3.store_state]}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact__3.sales_location_id = SugarCRMDataSource_public_sales_location__3.id]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3]) Access(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000}) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3]) ============================================================================ EXECUTING PushSelectCriteria AFTER: TupleLimit(groups=[]) Sort(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) SetOperation(groups=[]) SetOperation(groups=[]) SetOperation(groups=[]) Project(groups=[anon_grp0]) Group(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, anon_grp0]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, FoodmartDataSource_public.store AS FoodmartDataSource_public_store]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact]) Access(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1]) Access(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1]) Project(groups=[anon_grp2]) Group(groups=[anon_grp2, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2]) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2]) Access(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) Project(groups=[anon_grp3]) Group(groups=[anon_grp3]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3]) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3]) Access(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3]) ============================================================================ EXECUTING MergeVirtual AFTER: TupleLimit(groups=[]) Sort(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) SetOperation(groups=[]) SetOperation(groups=[]) SetOperation(groups=[]) Project(groups=[anon_grp0]) Group(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, anon_grp0]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, FoodmartDataSource_public.store AS FoodmartDataSource_public_store]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact]) Access(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1]) Access(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1]) Project(groups=[anon_grp2]) Group(groups=[anon_grp2, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2]) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2]) Access(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) Project(groups=[anon_grp3]) Group(groups=[anon_grp3]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3]) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3]) Access(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3]) ============================================================================ EXECUTING DecomposeJoin AFTER: TupleLimit(groups=[]) Sort(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) SetOperation(groups=[]) SetOperation(groups=[]) SetOperation(groups=[]) Project(groups=[anon_grp0]) Group(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, anon_grp0]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, FoodmartDataSource_public.store AS FoodmartDataSource_public_store], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location.state = FoodmartDataSource_public_store.store_state]}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact.sales_location_id = SugarCRMDataSource_public_sales_location.id]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact]) Access(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__1.state = FoodmartDataSource_public_store__1.store_state]}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact__1.sales_location_id = SugarCRMDataSource_public_sales_location__1.id]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1]) Access(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1]) Project(groups=[anon_grp2]) Group(groups=[anon_grp2, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__2.state = FoodmartDataSource_public_store__2.store_state]}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact__2.sales_location_id = SugarCRMDataSource_public_sales_location__2.id]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2]) Access(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) Project(groups=[anon_grp3]) Group(groups=[anon_grp3]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__3.state = FoodmartDataSource_public_store__3.store_state]}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact__3.sales_location_id = SugarCRMDataSource_public_sales_location__3.id]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3]) Access(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3]) ============================================================================ EXECUTING PushNonJoinCriteria AFTER: TupleLimit(groups=[]) Sort(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) SetOperation(groups=[]) SetOperation(groups=[]) SetOperation(groups=[]) Project(groups=[anon_grp0]) Group(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, anon_grp0]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, FoodmartDataSource_public.store AS FoodmartDataSource_public_store], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location.state = FoodmartDataSource_public_store.store_state]}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact.sales_location_id = SugarCRMDataSource_public_sales_location.id]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact]) Access(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__1.state = FoodmartDataSource_public_store__1.store_state]}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact__1.sales_location_id = SugarCRMDataSource_public_sales_location__1.id]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1]) Access(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1]) Project(groups=[anon_grp2]) Group(groups=[anon_grp2, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__2.state = FoodmartDataSource_public_store__2.store_state]}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact__2.sales_location_id = SugarCRMDataSource_public_sales_location__2.id]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2]) Access(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) Project(groups=[anon_grp3]) Group(groups=[anon_grp3]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__3.state = FoodmartDataSource_public_store__3.store_state]}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact__3.sales_location_id = SugarCRMDataSource_public_sales_location__3.id]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3]) Access(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3]) ============================================================================ EXECUTING CleanCriteria AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1000, OUTPUT_COLS=null}) Sort(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location], props={SORT_ORDER=ORDER BY SugarCRMDataSource_public_sales_location_country, FoodmartDataSource_public_store_store_country, OUTPUT_COLS=null}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=null}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=null}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=null}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS SugarCRMDataSource_public_sales_location_country, anon_grp0.gcol1 AS FoodmartDataSource_public_store_store_country, '1|1' AS JS_Discriminator_COL, anon_grp0.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount], OUTPUT_COLS=null}) Group(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, anon_grp0], props={GROUP_COLS=[SugarCRMDataSource_public_sales_location.country, FoodmartDataSource_public_store.store_country], SYMBOL_MAP={anon_grp0.gcol0=SugarCRMDataSource_public_sales_location.country, anon_grp0.gcol1=FoodmartDataSource_public_store.store_country, anon_grp0.agg0=COUNT(DISTINCT SugarCRMDataSource_public_sales_fact.amount)}, OUTPUT_COLS=null}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, FoodmartDataSource_public.store AS FoodmartDataSource_public_store], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location.state = FoodmartDataSource_public_store.store_state], OUTPUT_COLS=null}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact.sales_location_id = SugarCRMDataSource_public_sales_location.id], OUTPUT_COLS=null}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact], props={OUTPUT_COLS=null}) Access(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null}) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location], props={OUTPUT_COLS=null}) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000, OUTPUT_COLS=null}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store], props={OUTPUT_COLS=null}) Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.gcol0 AS SugarCRMDataSource_public_sales_location_country, null AS FoodmartDataSource_public_store_store_country, '1|0' AS JS_Discriminator_COL, anon_grp1.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount], OUTPUT_COLS=null}) Group(groups=[anon_grp1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1], props={GROUP_COLS=[SugarCRMDataSource_public_sales_location__1.country], SYMBOL_MAP={anon_grp1.gcol0=SugarCRMDataSource_public_sales_location__1.country, anon_grp1.agg0=COUNT(DISTINCT SugarCRMDataSource_public_sales_fact__1.amount)}, OUTPUT_COLS=null}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__1.state = FoodmartDataSource_public_store__1.store_state], OUTPUT_COLS=null}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact__1.sales_location_id = SugarCRMDataSource_public_sales_location__1.id], OUTPUT_COLS=null}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1], props={OUTPUT_COLS=null}) Access(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null}) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1], props={OUTPUT_COLS=null}) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000, OUTPUT_COLS=null}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1], props={OUTPUT_COLS=null}) Project(groups=[anon_grp2], props={PROJECT_COLS=[null AS SugarCRMDataSource_public_sales_location_country, anon_grp2.gcol0 AS FoodmartDataSource_public_store_store_country, '0|1' AS JS_Discriminator_COL, anon_grp2.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount], OUTPUT_COLS=null}) Group(groups=[anon_grp2, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2], props={GROUP_COLS=[FoodmartDataSource_public_store__2.store_country], SYMBOL_MAP={anon_grp2.gcol0=FoodmartDataSource_public_store__2.store_country, anon_grp2.agg0=COUNT(DISTINCT SugarCRMDataSource_public_sales_fact__2.amount)}, OUTPUT_COLS=null}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__2.state = FoodmartDataSource_public_store__2.store_state], OUTPUT_COLS=null}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact__2.sales_location_id = SugarCRMDataSource_public_sales_location__2.id], OUTPUT_COLS=null}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2], props={OUTPUT_COLS=null}) Access(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null}) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2], props={OUTPUT_COLS=null}) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000, OUTPUT_COLS=null}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2], props={OUTPUT_COLS=null}) Project(groups=[anon_grp3], props={PROJECT_COLS=[null AS SugarCRMDataSource_public_sales_location_country, null AS FoodmartDataSource_public_store_store_country, '0|0' AS JS_Discriminator_COL, anon_grp3.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount], OUTPUT_COLS=null}) Group(groups=[anon_grp3], props={SYMBOL_MAP={anon_grp3.agg0=COUNT(DISTINCT SugarCRMDataSource_public_sales_fact__3.amount)}, OUTPUT_COLS=null}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__3.state = FoodmartDataSource_public_store__3.store_state], OUTPUT_COLS=null}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact__3.sales_location_id = SugarCRMDataSource_public_sales_location__3.id], OUTPUT_COLS=null}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3], props={OUTPUT_COLS=null}) Access(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null}) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3], props={OUTPUT_COLS=null}) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000, OUTPUT_COLS=null}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING PlanUnions AFTER: TupleLimit(groups=[]) Sort(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=null}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=null}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=null}) Project(groups=[anon_grp0]) Group(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, anon_grp0]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, FoodmartDataSource_public.store AS FoodmartDataSource_public_store]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact]) Access(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null}) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000, OUTPUT_COLS=null}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1]) Access(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null}) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000, OUTPUT_COLS=null}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1]) Project(groups=[anon_grp2]) Group(groups=[anon_grp2, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2]) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2]) Access(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null}) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000, OUTPUT_COLS=null}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) Project(groups=[anon_grp3]) Group(groups=[anon_grp3]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3]) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3]) Access(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null}) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000, OUTPUT_COLS=null}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3]) ============================================================================ EXECUTING RaiseAccess AFTER: TupleLimit(groups=[]) Sort(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) SetOperation(groups=[]) SetOperation(groups=[]) SetOperation(groups=[]) Project(groups=[anon_grp0]) Group(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, anon_grp0]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, FoodmartDataSource_public.store AS FoodmartDataSource_public_store], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location.state = FoodmartDataSource_public_store.store_state], OUTPUT_COLS=null}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null, CONFORMED_SOURCES=null}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact.sales_location_id = SugarCRMDataSource_public_sales_location.id], OUTPUT_COLS=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact], props={OUTPUT_COLS=null}) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location], props={OUTPUT_COLS=null}) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000, OUTPUT_COLS=null}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__1.state = FoodmartDataSource_public_store__1.store_state], OUTPUT_COLS=null}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null, CONFORMED_SOURCES=null}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact__1.sales_location_id = SugarCRMDataSource_public_sales_location__1.id], OUTPUT_COLS=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1], props={OUTPUT_COLS=null}) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1], props={OUTPUT_COLS=null}) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000, OUTPUT_COLS=null}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1]) Project(groups=[anon_grp2]) Group(groups=[anon_grp2, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__2.state = FoodmartDataSource_public_store__2.store_state], OUTPUT_COLS=null}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null, CONFORMED_SOURCES=null}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact__2.sales_location_id = SugarCRMDataSource_public_sales_location__2.id], OUTPUT_COLS=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2], props={OUTPUT_COLS=null}) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2], props={OUTPUT_COLS=null}) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000, OUTPUT_COLS=null}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) Project(groups=[anon_grp3]) Group(groups=[anon_grp3]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__3.state = FoodmartDataSource_public_store__3.store_state], OUTPUT_COLS=null}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null, CONFORMED_SOURCES=null}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact__3.sales_location_id = SugarCRMDataSource_public_sales_location__3.id], OUTPUT_COLS=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3], props={OUTPUT_COLS=null}) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3], props={OUTPUT_COLS=null}) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000, OUTPUT_COLS=null}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3]) ============================================================================ EXECUTING CopyCriteria AFTER: TupleLimit(groups=[]) Sort(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) SetOperation(groups=[]) SetOperation(groups=[]) SetOperation(groups=[]) Project(groups=[anon_grp0]) Group(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, anon_grp0]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, FoodmartDataSource_public.store AS FoodmartDataSource_public_store], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location.state = FoodmartDataSource_public_store.store_state], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact.sales_location_id = SugarCRMDataSource_public_sales_location.id], OUTPUT_COLS=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, IS_COPIED=true}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__1.state = FoodmartDataSource_public_store__1.store_state], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact__1.sales_location_id = SugarCRMDataSource_public_sales_location__1.id], OUTPUT_COLS=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, IS_COPIED=true}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1]) Project(groups=[anon_grp2]) Group(groups=[anon_grp2, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__2.state = FoodmartDataSource_public_store__2.store_state], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact__2.sales_location_id = SugarCRMDataSource_public_sales_location__2.id], OUTPUT_COLS=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, IS_COPIED=true}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) Project(groups=[anon_grp3]) Group(groups=[anon_grp3]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__3.state = FoodmartDataSource_public_store__3.store_state], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact__3.sales_location_id = SugarCRMDataSource_public_sales_location__3.id], OUTPUT_COLS=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, IS_COPIED=true}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3]) ============================================================================ EXECUTING CleanCriteria AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1000, OUTPUT_COLS=null}) Sort(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location], props={SORT_ORDER=ORDER BY SugarCRMDataSource_public_sales_location_country, FoodmartDataSource_public_store_store_country, OUTPUT_COLS=null}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=null}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=null}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=null}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS SugarCRMDataSource_public_sales_location_country, anon_grp0.gcol1 AS FoodmartDataSource_public_store_store_country, '1|1' AS JS_Discriminator_COL, anon_grp0.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount], OUTPUT_COLS=null}) Group(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, anon_grp0], props={GROUP_COLS=[SugarCRMDataSource_public_sales_location.country, FoodmartDataSource_public_store.store_country], SYMBOL_MAP={anon_grp0.gcol0=SugarCRMDataSource_public_sales_location.country, anon_grp0.gcol1=FoodmartDataSource_public_store.store_country, anon_grp0.agg0=COUNT(DISTINCT SugarCRMDataSource_public_sales_fact.amount)}, OUTPUT_COLS=null}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, FoodmartDataSource_public.store AS FoodmartDataSource_public_store], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location.state = FoodmartDataSource_public_store.store_state], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null, CONFORMED_SOURCES=null}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact.sales_location_id = SugarCRMDataSource_public_sales_location.id], OUTPUT_COLS=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, IS_COPIED=true}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact], props={OUTPUT_COLS=null}) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location], props={OUTPUT_COLS=null}) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000, OUTPUT_COLS=null}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store], props={OUTPUT_COLS=null}) Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.gcol0 AS SugarCRMDataSource_public_sales_location_country, null AS FoodmartDataSource_public_store_store_country, '1|0' AS JS_Discriminator_COL, anon_grp1.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount], OUTPUT_COLS=null}) Group(groups=[anon_grp1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1], props={GROUP_COLS=[SugarCRMDataSource_public_sales_location__1.country], SYMBOL_MAP={anon_grp1.gcol0=SugarCRMDataSource_public_sales_location__1.country, anon_grp1.agg0=COUNT(DISTINCT SugarCRMDataSource_public_sales_fact__1.amount)}, OUTPUT_COLS=null}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__1.state = FoodmartDataSource_public_store__1.store_state], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null, CONFORMED_SOURCES=null}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact__1.sales_location_id = SugarCRMDataSource_public_sales_location__1.id], OUTPUT_COLS=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, IS_COPIED=true}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1], props={OUTPUT_COLS=null}) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1], props={OUTPUT_COLS=null}) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000, OUTPUT_COLS=null}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1], props={OUTPUT_COLS=null}) Project(groups=[anon_grp2], props={PROJECT_COLS=[null AS SugarCRMDataSource_public_sales_location_country, anon_grp2.gcol0 AS FoodmartDataSource_public_store_store_country, '0|1' AS JS_Discriminator_COL, anon_grp2.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount], OUTPUT_COLS=null}) Group(groups=[anon_grp2, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2], props={GROUP_COLS=[FoodmartDataSource_public_store__2.store_country], SYMBOL_MAP={anon_grp2.gcol0=FoodmartDataSource_public_store__2.store_country, anon_grp2.agg0=COUNT(DISTINCT SugarCRMDataSource_public_sales_fact__2.amount)}, OUTPUT_COLS=null}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__2.state = FoodmartDataSource_public_store__2.store_state], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null, CONFORMED_SOURCES=null}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact__2.sales_location_id = SugarCRMDataSource_public_sales_location__2.id], OUTPUT_COLS=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, IS_COPIED=true}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2], props={OUTPUT_COLS=null}) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2], props={OUTPUT_COLS=null}) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000, OUTPUT_COLS=null}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2], props={OUTPUT_COLS=null}) Project(groups=[anon_grp3], props={PROJECT_COLS=[null AS SugarCRMDataSource_public_sales_location_country, null AS FoodmartDataSource_public_store_store_country, '0|0' AS JS_Discriminator_COL, anon_grp3.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount], OUTPUT_COLS=null}) Group(groups=[anon_grp3], props={SYMBOL_MAP={anon_grp3.agg0=COUNT(DISTINCT SugarCRMDataSource_public_sales_fact__3.amount)}, OUTPUT_COLS=null}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__3.state = FoodmartDataSource_public_store__3.store_state], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null, CONFORMED_SOURCES=null}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact__3.sales_location_id = SugarCRMDataSource_public_sales_location__3.id], OUTPUT_COLS=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, IS_COPIED=true}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3], props={OUTPUT_COLS=null}) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3], props={OUTPUT_COLS=null}) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000, OUTPUT_COLS=null}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING PlanJoins AFTER: TupleLimit(groups=[]) Sort(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) SetOperation(groups=[]) SetOperation(groups=[]) SetOperation(groups=[]) Project(groups=[anon_grp0]) Group(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, anon_grp0], props={GROUP_COLS=[SugarCRMDataSource_public_sales_location.country, FoodmartDataSource_public_store.store_country], SYMBOL_MAP={anon_grp0.gcol0=SugarCRMDataSource_public_sales_location.country, anon_grp0.gcol1=FoodmartDataSource_public_store.store_country, anon_grp0.agg0=COUNT(DISTINCT SugarCRMDataSource_public_sales_fact.amount)}, OUTPUT_COLS=null}) Select(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location], props={SELECT_CRITERIA=SugarCRMDataSource_public_sales_location.state = FoodmartDataSource_public_store.store_state, EST_SELECTIVITY=0.12577777}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, FoodmartDataSource_public.store AS FoodmartDataSource_public_store], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=-1.0}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact.sales_location_id = SugarCRMDataSource_public_sales_location.id], OUTPUT_COLS=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, IS_COPIED=true, EST_CARDINALITY=-1.0}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact], props={OUTPUT_COLS=null, EST_COL_STATS={SugarCRMDataSource_public_sales_fact.id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact.sales_date_of_close_id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact.sales_date_of_start_id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact.sales_person_id=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location], props={OUTPUT_COLS=null, EST_COL_STATS={SugarCRMDataSource_public_sales_location.id=[-1.0, -1.0], SugarCRMDataSource_public_sales_location.zipcode=[-1.0, -1.0], SugarCRMDataSource_public_sales_location.city=[-1.0, -1.0], SugarCRMDataSource_public_sales_location.state=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000, OUTPUT_COLS=null, EST_CARDINALITY=-1.0}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store], props={OUTPUT_COLS=null, EST_COL_STATS={FoodmartDataSource_public_store.store_id=[-1.0, -1.0], FoodmartDataSource_public_store.store_type=[-1.0, -1.0], FoodmartDataSource_public_store.region_id=[-1.0, -1.0], FoodmartDataSource_public_store.store_name=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1], props={GROUP_COLS=[SugarCRMDataSource_public_sales_location__1.country], SYMBOL_MAP={anon_grp1.gcol0=SugarCRMDataSource_public_sales_location__1.country, anon_grp1.agg0=COUNT(DISTINCT SugarCRMDataSource_public_sales_fact__1.amount)}, OUTPUT_COLS=null}) Select(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1], props={SELECT_CRITERIA=SugarCRMDataSource_public_sales_location__1.state = FoodmartDataSource_public_store__1.store_state, EST_SELECTIVITY=0.12577777}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=-1.0}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact__1.sales_location_id = SugarCRMDataSource_public_sales_location__1.id], OUTPUT_COLS=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, IS_COPIED=true, EST_CARDINALITY=-1.0}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1], props={OUTPUT_COLS=null, EST_COL_STATS={SugarCRMDataSource_public_sales_fact__1.id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact__1.sales_date_of_close_id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact__1.sales_date_of_start_id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact__1.sales_person_id=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1], props={OUTPUT_COLS=null, EST_COL_STATS={SugarCRMDataSource_public_sales_location__1.id=[-1.0, -1.0], SugarCRMDataSource_public_sales_location__1.zipcode=[-1.0, -1.0], SugarCRMDataSource_public_sales_location__1.city=[-1.0, -1.0], SugarCRMDataSource_public_sales_location__1.state=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000, OUTPUT_COLS=null, EST_CARDINALITY=-1.0}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1], props={OUTPUT_COLS=null, EST_COL_STATS={FoodmartDataSource_public_store__1.store_id=[-1.0, -1.0], FoodmartDataSource_public_store__1.store_type=[-1.0, -1.0], FoodmartDataSource_public_store__1.region_id=[-1.0, -1.0], FoodmartDataSource_public_store__1.store_name=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Project(groups=[anon_grp2]) Group(groups=[anon_grp2, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2], props={GROUP_COLS=[FoodmartDataSource_public_store__2.store_country], SYMBOL_MAP={anon_grp2.gcol0=FoodmartDataSource_public_store__2.store_country, anon_grp2.agg0=COUNT(DISTINCT SugarCRMDataSource_public_sales_fact__2.amount)}, OUTPUT_COLS=null}) Select(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2], props={SELECT_CRITERIA=SugarCRMDataSource_public_sales_location__2.state = FoodmartDataSource_public_store__2.store_state, EST_SELECTIVITY=0.12577777}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=-1.0}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact__2.sales_location_id = SugarCRMDataSource_public_sales_location__2.id], OUTPUT_COLS=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, IS_COPIED=true, EST_CARDINALITY=-1.0}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2], props={OUTPUT_COLS=null, EST_COL_STATS={SugarCRMDataSource_public_sales_fact__2.id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact__2.sales_date_of_close_id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact__2.sales_date_of_start_id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact__2.sales_person_id=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2], props={OUTPUT_COLS=null, EST_COL_STATS={SugarCRMDataSource_public_sales_location__2.id=[-1.0, -1.0], SugarCRMDataSource_public_sales_location__2.zipcode=[-1.0, -1.0], SugarCRMDataSource_public_sales_location__2.city=[-1.0, -1.0], SugarCRMDataSource_public_sales_location__2.state=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000, OUTPUT_COLS=null, EST_CARDINALITY=-1.0}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2], props={OUTPUT_COLS=null, EST_COL_STATS={FoodmartDataSource_public_store__2.store_id=[-1.0, -1.0], FoodmartDataSource_public_store__2.store_type=[-1.0, -1.0], FoodmartDataSource_public_store__2.region_id=[-1.0, -1.0], FoodmartDataSource_public_store__2.store_name=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Project(groups=[anon_grp3]) Group(groups=[anon_grp3], props={SYMBOL_MAP={anon_grp3.agg0=COUNT(DISTINCT SugarCRMDataSource_public_sales_fact__3.amount)}, OUTPUT_COLS=null}) Select(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3], props={SELECT_CRITERIA=SugarCRMDataSource_public_sales_location__3.state = FoodmartDataSource_public_store__3.store_state, EST_SELECTIVITY=0.12577777}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=-1.0}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact__3.sales_location_id = SugarCRMDataSource_public_sales_location__3.id], OUTPUT_COLS=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, IS_COPIED=true, EST_CARDINALITY=-1.0}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3], props={OUTPUT_COLS=null, EST_COL_STATS={SugarCRMDataSource_public_sales_fact__3.id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact__3.sales_date_of_close_id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact__3.sales_date_of_start_id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact__3.sales_person_id=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3], props={OUTPUT_COLS=null, EST_COL_STATS={SugarCRMDataSource_public_sales_location__3.id=[-1.0, -1.0], SugarCRMDataSource_public_sales_location__3.zipcode=[-1.0, -1.0], SugarCRMDataSource_public_sales_location__3.city=[-1.0, -1.0], SugarCRMDataSource_public_sales_location__3.state=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000, OUTPUT_COLS=null, EST_CARDINALITY=-1.0}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3], props={OUTPUT_COLS=null, EST_COL_STATS={FoodmartDataSource_public_store__3.store_id=[-1.0, -1.0], FoodmartDataSource_public_store__3.store_type=[-1.0, -1.0], FoodmartDataSource_public_store__3.region_id=[-1.0, -1.0], FoodmartDataSource_public_store__3.store_name=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) ============================================================================ EXECUTING PushSelectCriteria AFTER: TupleLimit(groups=[]) Sort(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) SetOperation(groups=[]) SetOperation(groups=[]) SetOperation(groups=[]) Project(groups=[anon_grp0]) Group(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, anon_grp0], props={GROUP_COLS=[SugarCRMDataSource_public_sales_location.country, FoodmartDataSource_public_store.store_country], SYMBOL_MAP={anon_grp0.gcol0=SugarCRMDataSource_public_sales_location.country, anon_grp0.gcol1=FoodmartDataSource_public_store.store_country, anon_grp0.agg0=COUNT(DISTINCT SugarCRMDataSource_public_sales_fact.amount)}, OUTPUT_COLS=null}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, FoodmartDataSource_public.store AS FoodmartDataSource_public_store], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location.state = FoodmartDataSource_public_store.store_state]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1], props={GROUP_COLS=[SugarCRMDataSource_public_sales_location__1.country], SYMBOL_MAP={anon_grp1.gcol0=SugarCRMDataSource_public_sales_location__1.country, anon_grp1.agg0=COUNT(DISTINCT SugarCRMDataSource_public_sales_fact__1.amount)}, OUTPUT_COLS=null}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__1.state = FoodmartDataSource_public_store__1.store_state]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1]) Project(groups=[anon_grp2]) Group(groups=[anon_grp2, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2], props={GROUP_COLS=[FoodmartDataSource_public_store__2.store_country], SYMBOL_MAP={anon_grp2.gcol0=FoodmartDataSource_public_store__2.store_country, anon_grp2.agg0=COUNT(DISTINCT SugarCRMDataSource_public_sales_fact__2.amount)}, OUTPUT_COLS=null}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__2.state = FoodmartDataSource_public_store__2.store_state]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) Project(groups=[anon_grp3]) Group(groups=[anon_grp3], props={SYMBOL_MAP={anon_grp3.agg0=COUNT(DISTINCT SugarCRMDataSource_public_sales_fact__3.amount)}, OUTPUT_COLS=null}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__3.state = FoodmartDataSource_public_store__3.store_state]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3]) ============================================================================ EXECUTING RaiseAccess AFTER: TupleLimit(groups=[]) Sort(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) SetOperation(groups=[]) SetOperation(groups=[]) SetOperation(groups=[]) Project(groups=[anon_grp0]) Group(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, anon_grp0]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, FoodmartDataSource_public.store AS FoodmartDataSource_public_store], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location.state = FoodmartDataSource_public_store.store_state]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=-1.0}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000, OUTPUT_COLS=null, EST_CARDINALITY=-1.0}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__1.state = FoodmartDataSource_public_store__1.store_state]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=-1.0}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000, OUTPUT_COLS=null, EST_CARDINALITY=-1.0}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1]) Project(groups=[anon_grp2]) Group(groups=[anon_grp2, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__2.state = FoodmartDataSource_public_store__2.store_state]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=-1.0}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000, OUTPUT_COLS=null, EST_CARDINALITY=-1.0}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) Project(groups=[anon_grp3]) Group(groups=[anon_grp3]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__3.state = FoodmartDataSource_public_store__3.store_state]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=-1.0}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000, OUTPUT_COLS=null, EST_CARDINALITY=-1.0}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3]) ============================================================================ EXECUTING PlanOuterJoins AFTER: TupleLimit(groups=[]) Sort(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) SetOperation(groups=[]) SetOperation(groups=[]) SetOperation(groups=[]) Project(groups=[anon_grp0]) Group(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, anon_grp0]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, FoodmartDataSource_public.store AS FoodmartDataSource_public_store], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location.state = FoodmartDataSource_public_store.store_state]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__1.state = FoodmartDataSource_public_store__1.store_state]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1]) Project(groups=[anon_grp2]) Group(groups=[anon_grp2, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__2.state = FoodmartDataSource_public_store__2.store_state]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) Project(groups=[anon_grp3]) Group(groups=[anon_grp3]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__3.state = FoodmartDataSource_public_store__3.store_state]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3]) ============================================================================ EXECUTING ChooseJoinStrategy AFTER: TupleLimit(groups=[]) Sort(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) SetOperation(groups=[]) SetOperation(groups=[]) SetOperation(groups=[]) Project(groups=[anon_grp0]) Group(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, anon_grp0]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, FoodmartDataSource_public.store AS FoodmartDataSource_public_store], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location.state = FoodmartDataSource_public_store.store_state], LEFT_EXPRESSIONS=[SugarCRMDataSource_public_sales_location.state], RIGHT_EXPRESSIONS=[FoodmartDataSource_public_store.store_state], NON_EQUI_JOIN_CRITERIA=[]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__1.state = FoodmartDataSource_public_store__1.store_state], LEFT_EXPRESSIONS=[SugarCRMDataSource_public_sales_location__1.state], RIGHT_EXPRESSIONS=[FoodmartDataSource_public_store__1.store_state], NON_EQUI_JOIN_CRITERIA=[]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1]) Project(groups=[anon_grp2]) Group(groups=[anon_grp2, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__2.state = FoodmartDataSource_public_store__2.store_state], LEFT_EXPRESSIONS=[SugarCRMDataSource_public_sales_location__2.state], RIGHT_EXPRESSIONS=[FoodmartDataSource_public_store__2.store_state], NON_EQUI_JOIN_CRITERIA=[]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) Project(groups=[anon_grp3]) Group(groups=[anon_grp3]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__3.state = FoodmartDataSource_public_store__3.store_state], LEFT_EXPRESSIONS=[SugarCRMDataSource_public_sales_location__3.state], RIGHT_EXPRESSIONS=[FoodmartDataSource_public_store__3.store_state], NON_EQUI_JOIN_CRITERIA=[]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3]) ============================================================================ EXECUTING ChooseDependent AFTER: TupleLimit(groups=[]) Sort(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) SetOperation(groups=[]) SetOperation(groups=[]) SetOperation(groups=[]) Project(groups=[anon_grp0]) Group(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, anon_grp0]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, FoodmartDataSource_public.store AS FoodmartDataSource_public_store], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location.state = FoodmartDataSource_public_store.store_state], LEFT_EXPRESSIONS=[SugarCRMDataSource_public_sales_location.state], RIGHT_EXPRESSIONS=[FoodmartDataSource_public_store.store_state], NON_EQUI_JOIN_CRITERIA=[]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store]) Project(groups=[anon_grp1]) Group(groups=[anon_grp1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__1.state = FoodmartDataSource_public_store__1.store_state], LEFT_EXPRESSIONS=[SugarCRMDataSource_public_sales_location__1.state], RIGHT_EXPRESSIONS=[FoodmartDataSource_public_store__1.store_state], NON_EQUI_JOIN_CRITERIA=[]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1]) Project(groups=[anon_grp2]) Group(groups=[anon_grp2, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__2.state = FoodmartDataSource_public_store__2.store_state], LEFT_EXPRESSIONS=[SugarCRMDataSource_public_sales_location__2.state], RIGHT_EXPRESSIONS=[FoodmartDataSource_public_store__2.store_state], NON_EQUI_JOIN_CRITERIA=[]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) Project(groups=[anon_grp3]) Group(groups=[anon_grp3]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__3.state = FoodmartDataSource_public_store__3.store_state], LEFT_EXPRESSIONS=[SugarCRMDataSource_public_sales_location__3.state], RIGHT_EXPRESSIONS=[FoodmartDataSource_public_store__3.store_state], NON_EQUI_JOIN_CRITERIA=[]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3]) ============================================================================ EXECUTING PushAggregates AFTER: TupleLimit(groups=[]) Sort(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) SetOperation(groups=[]) SetOperation(groups=[]) SetOperation(groups=[]) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS SugarCRMDataSource_public_sales_location_country, anon_grp0.gcol1 AS FoodmartDataSource_public_store_store_country, '1|1' AS JS_Discriminator_COL, anon_grp0.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount], OUTPUT_COLS=null}) Group(groups=[anon_grp4, anon_grp5, anon_grp0], props={GROUP_COLS=[anon_grp4.gcol1, anon_grp5.gcol1], SYMBOL_MAP={anon_grp0.gcol0=anon_grp4.gcol1, anon_grp0.gcol1=anon_grp5.gcol1, anon_grp0.agg0=COUNT(DISTINCT anon_grp4.gcol2)}, OUTPUT_COLS=null}) Join(groups=[anon_grp4, anon_grp5], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[anon_grp4.gcol0 = anon_grp5.gcol0], LEFT_EXPRESSIONS=[anon_grp4.gcol0], RIGHT_EXPRESSIONS=[anon_grp5.gcol0], NON_EQUI_JOIN_CRITERIA=[]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, anon_grp4], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null, CONFORMED_SOURCES=null}) Group(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, anon_grp4], props={GROUP_COLS=[SugarCRMDataSource_public_sales_location.state, SugarCRMDataSource_public_sales_location.country, SugarCRMDataSource_public_sales_fact.amount], SYMBOL_MAP={anon_grp4.gcol0=SugarCRMDataSource_public_sales_location.state, anon_grp4.gcol1=SugarCRMDataSource_public_sales_location.country, anon_grp4.gcol2=SugarCRMDataSource_public_sales_fact.amount}}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact.sales_location_id = SugarCRMDataSource_public_sales_location.id], OUTPUT_COLS=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, IS_COPIED=true, EST_CARDINALITY=-1.0}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact], props={OUTPUT_COLS=null, EST_COL_STATS={SugarCRMDataSource_public_sales_fact.id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact.sales_date_of_close_id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact.sales_date_of_start_id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact.sales_person_id=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location], props={OUTPUT_COLS=null, EST_COL_STATS={SugarCRMDataSource_public_sales_location.id=[-1.0, -1.0], SugarCRMDataSource_public_sales_location.zipcode=[-1.0, -1.0], SugarCRMDataSource_public_sales_location.city=[-1.0, -1.0], SugarCRMDataSource_public_sales_location.state=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, anon_grp5], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000, OUTPUT_COLS=null}) Group(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, anon_grp5], props={GROUP_COLS=[FoodmartDataSource_public_store.store_state, FoodmartDataSource_public_store.store_country], SYMBOL_MAP={anon_grp5.gcol0=FoodmartDataSource_public_store.store_state, anon_grp5.gcol1=FoodmartDataSource_public_store.store_country}}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store], props={OUTPUT_COLS=null, EST_COL_STATS={FoodmartDataSource_public_store.store_id=[-1.0, -1.0], FoodmartDataSource_public_store.store_type=[-1.0, -1.0], FoodmartDataSource_public_store.region_id=[-1.0, -1.0], FoodmartDataSource_public_store.store_name=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.gcol0 AS SugarCRMDataSource_public_sales_location_country, null AS FoodmartDataSource_public_store_store_country, '1|0' AS JS_Discriminator_COL, anon_grp1.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount], OUTPUT_COLS=null}) Group(groups=[anon_grp6, anon_grp1], props={GROUP_COLS=[anon_grp6.gcol1], SYMBOL_MAP={anon_grp1.gcol0=anon_grp6.gcol1, anon_grp1.agg0=COUNT(DISTINCT anon_grp6.gcol2)}, OUTPUT_COLS=null}) Join(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1, anon_grp6], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[anon_grp6.gcol0 = FoodmartDataSource_public_store__1.store_state], LEFT_EXPRESSIONS=[anon_grp6.gcol0], RIGHT_EXPRESSIONS=[FoodmartDataSource_public_store__1.store_state], NON_EQUI_JOIN_CRITERIA=[]}) Access(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1, SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, anon_grp6], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null, CONFORMED_SOURCES=null}) Group(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1, SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, anon_grp6], props={GROUP_COLS=[SugarCRMDataSource_public_sales_location__1.state, SugarCRMDataSource_public_sales_location__1.country, SugarCRMDataSource_public_sales_fact__1.amount], SYMBOL_MAP={anon_grp6.gcol0=SugarCRMDataSource_public_sales_location__1.state, anon_grp6.gcol1=SugarCRMDataSource_public_sales_location__1.country, anon_grp6.gcol2=SugarCRMDataSource_public_sales_fact__1.amount}}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact__1.sales_location_id = SugarCRMDataSource_public_sales_location__1.id], OUTPUT_COLS=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, IS_COPIED=true, EST_CARDINALITY=-1.0}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1], props={OUTPUT_COLS=null, EST_COL_STATS={SugarCRMDataSource_public_sales_fact__1.id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact__1.sales_date_of_close_id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact__1.sales_date_of_start_id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact__1.sales_person_id=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1], props={OUTPUT_COLS=null, EST_COL_STATS={SugarCRMDataSource_public_sales_location__1.id=[-1.0, -1.0], SugarCRMDataSource_public_sales_location__1.zipcode=[-1.0, -1.0], SugarCRMDataSource_public_sales_location__1.city=[-1.0, -1.0], SugarCRMDataSource_public_sales_location__1.state=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1]) Project(groups=[anon_grp2], props={PROJECT_COLS=[null AS SugarCRMDataSource_public_sales_location_country, anon_grp2.gcol0 AS FoodmartDataSource_public_store_store_country, '0|1' AS JS_Discriminator_COL, anon_grp2.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount], OUTPUT_COLS=null}) Group(groups=[anon_grp7, anon_grp2], props={GROUP_COLS=[anon_grp7.gcol1], SYMBOL_MAP={anon_grp2.gcol0=anon_grp7.gcol1, anon_grp2.agg0=COUNT(DISTINCT SugarCRMDataSource_public_sales_fact__2.amount)}, OUTPUT_COLS=null}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2, anon_grp7], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__2.state = anon_grp7.gcol0], LEFT_EXPRESSIONS=[SugarCRMDataSource_public_sales_location__2.state], RIGHT_EXPRESSIONS=[anon_grp7.gcol0], NON_EQUI_JOIN_CRITERIA=[]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2, anon_grp7], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000, OUTPUT_COLS=null}) Group(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2, anon_grp7], props={GROUP_COLS=[FoodmartDataSource_public_store__2.store_state, FoodmartDataSource_public_store__2.store_country], SYMBOL_MAP={anon_grp7.gcol0=FoodmartDataSource_public_store__2.store_state, anon_grp7.gcol1=FoodmartDataSource_public_store__2.store_country}}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2], props={OUTPUT_COLS=null, EST_COL_STATS={FoodmartDataSource_public_store__2.store_id=[-1.0, -1.0], FoodmartDataSource_public_store__2.store_type=[-1.0, -1.0], FoodmartDataSource_public_store__2.region_id=[-1.0, -1.0], FoodmartDataSource_public_store__2.store_name=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Project(groups=[anon_grp3], props={PROJECT_COLS=[null AS SugarCRMDataSource_public_sales_location_country, null AS FoodmartDataSource_public_store_store_country, '0|0' AS JS_Discriminator_COL, anon_grp3.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount], OUTPUT_COLS=null}) Group(groups=[anon_grp3], props={SYMBOL_MAP={anon_grp3.agg0=COUNT(DISTINCT SugarCRMDataSource_public_sales_fact__3.amount)}, OUTPUT_COLS=null}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3]) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3]) ============================================================================ EXECUTING ChooseDependent AFTER: TupleLimit(groups=[]) Sort(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) SetOperation(groups=[]) SetOperation(groups=[]) SetOperation(groups=[]) Project(groups=[anon_grp0]) Group(groups=[anon_grp4, anon_grp5, anon_grp0]) Join(groups=[anon_grp4, anon_grp5], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[anon_grp4.gcol0 = anon_grp5.gcol0], LEFT_EXPRESSIONS=[anon_grp4.gcol0], RIGHT_EXPRESSIONS=[anon_grp5.gcol0], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=null}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, anon_grp4], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=-1.0}) Group(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, anon_grp4], props={GROUP_COLS=[SugarCRMDataSource_public_sales_location.state, SugarCRMDataSource_public_sales_location.country, SugarCRMDataSource_public_sales_fact.amount], SYMBOL_MAP={anon_grp4.gcol0=SugarCRMDataSource_public_sales_location.state, anon_grp4.gcol1=SugarCRMDataSource_public_sales_location.country, anon_grp4.gcol2=SugarCRMDataSource_public_sales_fact.amount}, EST_CARDINALITY=-1.0}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact.sales_location_id = SugarCRMDataSource_public_sales_location.id], OUTPUT_COLS=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, IS_COPIED=true, EST_CARDINALITY=-1.0}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact], props={OUTPUT_COLS=null, EST_COL_STATS={SugarCRMDataSource_public_sales_fact.id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact.sales_date_of_close_id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact.sales_date_of_start_id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact.sales_person_id=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location], props={OUTPUT_COLS=null, EST_COL_STATS={SugarCRMDataSource_public_sales_location.id=[-1.0, -1.0], SugarCRMDataSource_public_sales_location.zipcode=[-1.0, -1.0], SugarCRMDataSource_public_sales_location.city=[-1.0, -1.0], SugarCRMDataSource_public_sales_location.state=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, anon_grp5], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000, OUTPUT_COLS=null, EST_CARDINALITY=-1.0}) Group(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, anon_grp5], props={GROUP_COLS=[FoodmartDataSource_public_store.store_state, FoodmartDataSource_public_store.store_country], SYMBOL_MAP={anon_grp5.gcol0=FoodmartDataSource_public_store.store_state, anon_grp5.gcol1=FoodmartDataSource_public_store.store_country}, EST_CARDINALITY=-1.0}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store], props={OUTPUT_COLS=null, EST_COL_STATS={FoodmartDataSource_public_store.store_id=[-1.0, -1.0], FoodmartDataSource_public_store.store_type=[-1.0, -1.0], FoodmartDataSource_public_store.region_id=[-1.0, -1.0], FoodmartDataSource_public_store.store_name=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Project(groups=[anon_grp1]) Group(groups=[anon_grp6, anon_grp1]) Join(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1, anon_grp6], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[anon_grp6.gcol0 = FoodmartDataSource_public_store__1.store_state], LEFT_EXPRESSIONS=[anon_grp6.gcol0], RIGHT_EXPRESSIONS=[FoodmartDataSource_public_store__1.store_state], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=null}) Access(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1, SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, anon_grp6], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=-1.0}) Group(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1, SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, anon_grp6], props={GROUP_COLS=[SugarCRMDataSource_public_sales_location__1.state, SugarCRMDataSource_public_sales_location__1.country, SugarCRMDataSource_public_sales_fact__1.amount], SYMBOL_MAP={anon_grp6.gcol0=SugarCRMDataSource_public_sales_location__1.state, anon_grp6.gcol1=SugarCRMDataSource_public_sales_location__1.country, anon_grp6.gcol2=SugarCRMDataSource_public_sales_fact__1.amount}, EST_CARDINALITY=-1.0}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact__1.sales_location_id = SugarCRMDataSource_public_sales_location__1.id], OUTPUT_COLS=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, IS_COPIED=true, EST_CARDINALITY=-1.0}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1], props={OUTPUT_COLS=null, EST_COL_STATS={SugarCRMDataSource_public_sales_fact__1.id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact__1.sales_date_of_close_id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact__1.sales_date_of_start_id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact__1.sales_person_id=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1], props={OUTPUT_COLS=null, EST_COL_STATS={SugarCRMDataSource_public_sales_location__1.id=[-1.0, -1.0], SugarCRMDataSource_public_sales_location__1.zipcode=[-1.0, -1.0], SugarCRMDataSource_public_sales_location__1.city=[-1.0, -1.0], SugarCRMDataSource_public_sales_location__1.state=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000, OUTPUT_COLS=null, EST_CARDINALITY=-1.0}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1], props={OUTPUT_COLS=null, EST_COL_STATS={FoodmartDataSource_public_store__1.store_id=[-1.0, -1.0], FoodmartDataSource_public_store__1.store_type=[-1.0, -1.0], FoodmartDataSource_public_store__1.region_id=[-1.0, -1.0], FoodmartDataSource_public_store__1.store_name=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Project(groups=[anon_grp2]) Group(groups=[anon_grp7, anon_grp2]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2, anon_grp7], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__2.state = anon_grp7.gcol0], LEFT_EXPRESSIONS=[SugarCRMDataSource_public_sales_location__2.state], RIGHT_EXPRESSIONS=[anon_grp7.gcol0], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=null}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=-1.0}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact__2.sales_location_id = SugarCRMDataSource_public_sales_location__2.id], OUTPUT_COLS=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, IS_COPIED=true, EST_CARDINALITY=-1.0}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2], props={OUTPUT_COLS=null, EST_COL_STATS={SugarCRMDataSource_public_sales_fact__2.id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact__2.sales_date_of_close_id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact__2.sales_date_of_start_id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact__2.sales_person_id=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2], props={OUTPUT_COLS=null, EST_COL_STATS={SugarCRMDataSource_public_sales_location__2.id=[-1.0, -1.0], SugarCRMDataSource_public_sales_location__2.zipcode=[-1.0, -1.0], SugarCRMDataSource_public_sales_location__2.city=[-1.0, -1.0], SugarCRMDataSource_public_sales_location__2.state=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2, anon_grp7], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000, OUTPUT_COLS=null, EST_CARDINALITY=-1.0}) Group(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2, anon_grp7], props={GROUP_COLS=[FoodmartDataSource_public_store__2.store_state, FoodmartDataSource_public_store__2.store_country], SYMBOL_MAP={anon_grp7.gcol0=FoodmartDataSource_public_store__2.store_state, anon_grp7.gcol1=FoodmartDataSource_public_store__2.store_country}, EST_CARDINALITY=-1.0}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2], props={OUTPUT_COLS=null, EST_COL_STATS={FoodmartDataSource_public_store__2.store_id=[-1.0, -1.0], FoodmartDataSource_public_store__2.store_type=[-1.0, -1.0], FoodmartDataSource_public_store__2.region_id=[-1.0, -1.0], FoodmartDataSource_public_store__2.store_name=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Project(groups=[anon_grp3]) Group(groups=[anon_grp3]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__3.state = FoodmartDataSource_public_store__3.store_state], LEFT_EXPRESSIONS=[SugarCRMDataSource_public_sales_location__3.state], RIGHT_EXPRESSIONS=[FoodmartDataSource_public_store__3.store_state], NON_EQUI_JOIN_CRITERIA=[]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=-1.0}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact__3.sales_location_id = SugarCRMDataSource_public_sales_location__3.id], OUTPUT_COLS=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, IS_COPIED=true, EST_CARDINALITY=-1.0}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3], props={OUTPUT_COLS=null, EST_COL_STATS={SugarCRMDataSource_public_sales_fact__3.id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact__3.sales_date_of_close_id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact__3.sales_date_of_start_id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact__3.sales_person_id=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3], props={OUTPUT_COLS=null, EST_COL_STATS={SugarCRMDataSource_public_sales_location__3.id=[-1.0, -1.0], SugarCRMDataSource_public_sales_location__3.zipcode=[-1.0, -1.0], SugarCRMDataSource_public_sales_location__3.city=[-1.0, -1.0], SugarCRMDataSource_public_sales_location__3.state=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000, OUTPUT_COLS=null, EST_CARDINALITY=-1.0}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3], props={OUTPUT_COLS=null, EST_COL_STATS={FoodmartDataSource_public_store__3.store_id=[-1.0, -1.0], FoodmartDataSource_public_store__3.store_type=[-1.0, -1.0], FoodmartDataSource_public_store__3.region_id=[-1.0, -1.0], FoodmartDataSource_public_store__3.store_name=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) ============================================================================ EXECUTING AssignOutputElements AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1000, OUTPUT_COLS=[anon_grp0.gcol0 AS SugarCRMDataSource_public_sales_location_country, anon_grp0.gcol1 AS FoodmartDataSource_public_store_store_country, '1|1' AS JS_Discriminator_COL, anon_grp0.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount]}) Sort(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location], props={SORT_ORDER=ORDER BY SugarCRMDataSource_public_sales_location_country, FoodmartDataSource_public_store_store_country, OUTPUT_COLS=[anon_grp0.gcol0 AS SugarCRMDataSource_public_sales_location_country, anon_grp0.gcol1 AS FoodmartDataSource_public_store_store_country, '1|1' AS JS_Discriminator_COL, anon_grp0.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount], UNRELATED_SORT=true}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=[anon_grp0.gcol0 AS SugarCRMDataSource_public_sales_location_country, anon_grp0.gcol1 AS FoodmartDataSource_public_store_store_country, '1|1' AS JS_Discriminator_COL, anon_grp0.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount, SugarCRMDataSource_public_sales_location.country AS SugarCRMDataSource_public_sales_location_country, FoodmartDataSource_public_store.store_country AS FoodmartDataSource_public_store_store_country]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=[anon_grp0.gcol0 AS SugarCRMDataSource_public_sales_location_country, anon_grp0.gcol1 AS FoodmartDataSource_public_store_store_country, '1|1' AS JS_Discriminator_COL, anon_grp0.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=[anon_grp0.gcol0 AS SugarCRMDataSource_public_sales_location_country, anon_grp0.gcol1 AS FoodmartDataSource_public_store_store_country, '1|1' AS JS_Discriminator_COL, anon_grp0.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount]}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS SugarCRMDataSource_public_sales_location_country, anon_grp0.gcol1 AS FoodmartDataSource_public_store_store_country, '1|1' AS JS_Discriminator_COL, anon_grp0.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount], OUTPUT_COLS=[anon_grp0.gcol0 AS SugarCRMDataSource_public_sales_location_country, anon_grp0.gcol1 AS FoodmartDataSource_public_store_store_country, '1|1' AS JS_Discriminator_COL, anon_grp0.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount]}) Group(groups=[anon_grp4, anon_grp5, anon_grp0], props={GROUP_COLS=[anon_grp4.gcol1, anon_grp5.gcol1], SYMBOL_MAP={anon_grp0.gcol0=anon_grp4.gcol1, anon_grp0.gcol1=anon_grp5.gcol1, anon_grp0.agg0=COUNT(DISTINCT anon_grp4.gcol2)}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.agg0]}) Join(groups=[anon_grp4, anon_grp5], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[anon_grp4.gcol0 = anon_grp5.gcol0], LEFT_EXPRESSIONS=[anon_grp4.gcol0], RIGHT_EXPRESSIONS=[anon_grp5.gcol0], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=null, OUTPUT_COLS=[anon_grp4.gcol1, anon_grp5.gcol1, anon_grp4.gcol2]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, anon_grp4], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=[anon_grp4.gcol0, anon_grp4.gcol1, anon_grp4.gcol2], CONFORMED_SOURCES=null, EST_CARDINALITY=-1.0}) Group(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, anon_grp4], props={GROUP_COLS=[SugarCRMDataSource_public_sales_location.state, SugarCRMDataSource_public_sales_location.country, SugarCRMDataSource_public_sales_fact.amount], SYMBOL_MAP={anon_grp4.gcol0=SugarCRMDataSource_public_sales_location.state, anon_grp4.gcol1=SugarCRMDataSource_public_sales_location.country, anon_grp4.gcol2=SugarCRMDataSource_public_sales_fact.amount}, EST_CARDINALITY=-1.0, OUTPUT_COLS=[anon_grp4.gcol0, anon_grp4.gcol1, anon_grp4.gcol2]}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact.sales_location_id = SugarCRMDataSource_public_sales_location.id], OUTPUT_COLS=[SugarCRMDataSource_public_sales_location.state, SugarCRMDataSource_public_sales_location.country, SugarCRMDataSource_public_sales_fact.amount], MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, IS_COPIED=true, EST_CARDINALITY=-1.0}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact], props={OUTPUT_COLS=[SugarCRMDataSource_public_sales_fact.sales_location_id, SugarCRMDataSource_public_sales_fact.amount], EST_COL_STATS={SugarCRMDataSource_public_sales_fact.id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact.sales_date_of_close_id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact.sales_date_of_start_id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact.sales_person_id=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location], props={OUTPUT_COLS=[SugarCRMDataSource_public_sales_location.id, SugarCRMDataSource_public_sales_location.state, SugarCRMDataSource_public_sales_location.country], EST_COL_STATS={SugarCRMDataSource_public_sales_location.id=[-1.0, -1.0], SugarCRMDataSource_public_sales_location.zipcode=[-1.0, -1.0], SugarCRMDataSource_public_sales_location.city=[-1.0, -1.0], SugarCRMDataSource_public_sales_location.state=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, anon_grp5], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000, OUTPUT_COLS=[anon_grp5.gcol0, anon_grp5.gcol1], EST_CARDINALITY=-1.0}) Group(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, anon_grp5], props={GROUP_COLS=[FoodmartDataSource_public_store.store_state, FoodmartDataSource_public_store.store_country], SYMBOL_MAP={anon_grp5.gcol0=FoodmartDataSource_public_store.store_state, anon_grp5.gcol1=FoodmartDataSource_public_store.store_country}, EST_CARDINALITY=-1.0, OUTPUT_COLS=[anon_grp5.gcol0, anon_grp5.gcol1]}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store], props={OUTPUT_COLS=[FoodmartDataSource_public_store.store_state, FoodmartDataSource_public_store.store_country], EST_COL_STATS={FoodmartDataSource_public_store.store_id=[-1.0, -1.0], FoodmartDataSource_public_store.store_type=[-1.0, -1.0], FoodmartDataSource_public_store.region_id=[-1.0, -1.0], FoodmartDataSource_public_store.store_name=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.gcol0 AS SugarCRMDataSource_public_sales_location_country, null AS FoodmartDataSource_public_store_store_country, '1|0' AS JS_Discriminator_COL, anon_grp1.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount], OUTPUT_COLS=[anon_grp1.gcol0 AS SugarCRMDataSource_public_sales_location_country, null AS FoodmartDataSource_public_store_store_country, '1|0' AS JS_Discriminator_COL, anon_grp1.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount]}) Group(groups=[anon_grp6, anon_grp1], props={GROUP_COLS=[anon_grp6.gcol1], SYMBOL_MAP={anon_grp1.gcol0=anon_grp6.gcol1, anon_grp1.agg0=COUNT(DISTINCT anon_grp6.gcol2)}, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.agg0]}) Join(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1, anon_grp6], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[anon_grp6.gcol0 = FoodmartDataSource_public_store__1.store_state], LEFT_EXPRESSIONS=[anon_grp6.gcol0], RIGHT_EXPRESSIONS=[FoodmartDataSource_public_store__1.store_state], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=null, OUTPUT_COLS=[anon_grp6.gcol1, anon_grp6.gcol2]}) Access(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1, SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, anon_grp6], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=[anon_grp6.gcol0, anon_grp6.gcol1, anon_grp6.gcol2], CONFORMED_SOURCES=null, EST_CARDINALITY=-1.0}) Group(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1, SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, anon_grp6], props={GROUP_COLS=[SugarCRMDataSource_public_sales_location__1.state, SugarCRMDataSource_public_sales_location__1.country, SugarCRMDataSource_public_sales_fact__1.amount], SYMBOL_MAP={anon_grp6.gcol0=SugarCRMDataSource_public_sales_location__1.state, anon_grp6.gcol1=SugarCRMDataSource_public_sales_location__1.country, anon_grp6.gcol2=SugarCRMDataSource_public_sales_fact__1.amount}, EST_CARDINALITY=-1.0, OUTPUT_COLS=[anon_grp6.gcol0, anon_grp6.gcol1, anon_grp6.gcol2]}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact__1.sales_location_id = SugarCRMDataSource_public_sales_location__1.id], OUTPUT_COLS=[SugarCRMDataSource_public_sales_location__1.state, SugarCRMDataSource_public_sales_location__1.country, SugarCRMDataSource_public_sales_fact__1.amount], MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, IS_COPIED=true, EST_CARDINALITY=-1.0}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1], props={OUTPUT_COLS=[SugarCRMDataSource_public_sales_fact__1.sales_location_id, SugarCRMDataSource_public_sales_fact__1.amount], EST_COL_STATS={SugarCRMDataSource_public_sales_fact__1.id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact__1.sales_date_of_close_id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact__1.sales_date_of_start_id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact__1.sales_person_id=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1], props={OUTPUT_COLS=[SugarCRMDataSource_public_sales_location__1.id, SugarCRMDataSource_public_sales_location__1.state, SugarCRMDataSource_public_sales_location__1.country], EST_COL_STATS={SugarCRMDataSource_public_sales_location__1.id=[-1.0, -1.0], SugarCRMDataSource_public_sales_location__1.zipcode=[-1.0, -1.0], SugarCRMDataSource_public_sales_location__1.city=[-1.0, -1.0], SugarCRMDataSource_public_sales_location__1.state=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000, OUTPUT_COLS=[FoodmartDataSource_public_store__1.store_state], EST_CARDINALITY=-1.0}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1], props={OUTPUT_COLS=[FoodmartDataSource_public_store__1.store_state], EST_COL_STATS={FoodmartDataSource_public_store__1.store_id=[-1.0, -1.0], FoodmartDataSource_public_store__1.store_type=[-1.0, -1.0], FoodmartDataSource_public_store__1.region_id=[-1.0, -1.0], FoodmartDataSource_public_store__1.store_name=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Project(groups=[anon_grp2], props={PROJECT_COLS=[null AS SugarCRMDataSource_public_sales_location_country, anon_grp2.gcol0 AS FoodmartDataSource_public_store_store_country, '0|1' AS JS_Discriminator_COL, anon_grp2.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount], OUTPUT_COLS=[null AS SugarCRMDataSource_public_sales_location_country, anon_grp2.gcol0 AS FoodmartDataSource_public_store_store_country, '0|1' AS JS_Discriminator_COL, anon_grp2.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount]}) Group(groups=[anon_grp7, anon_grp2], props={GROUP_COLS=[anon_grp7.gcol1], SYMBOL_MAP={anon_grp2.gcol0=anon_grp7.gcol1, anon_grp2.agg0=COUNT(DISTINCT SugarCRMDataSource_public_sales_fact__2.amount)}, OUTPUT_COLS=[anon_grp2.gcol0, anon_grp2.agg0]}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2, anon_grp7], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__2.state = anon_grp7.gcol0], LEFT_EXPRESSIONS=[SugarCRMDataSource_public_sales_location__2.state], RIGHT_EXPRESSIONS=[anon_grp7.gcol0], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=null, OUTPUT_COLS=[anon_grp7.gcol1, SugarCRMDataSource_public_sales_fact__2.amount]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=[SugarCRMDataSource_public_sales_location__2.state, SugarCRMDataSource_public_sales_fact__2.amount], CONFORMED_SOURCES=null, EST_CARDINALITY=-1.0}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact__2.sales_location_id = SugarCRMDataSource_public_sales_location__2.id], OUTPUT_COLS=[SugarCRMDataSource_public_sales_location__2.state, SugarCRMDataSource_public_sales_fact__2.amount], MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, IS_COPIED=true, EST_CARDINALITY=-1.0}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2], props={OUTPUT_COLS=[SugarCRMDataSource_public_sales_fact__2.sales_location_id, SugarCRMDataSource_public_sales_fact__2.amount], EST_COL_STATS={SugarCRMDataSource_public_sales_fact__2.id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact__2.sales_date_of_close_id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact__2.sales_date_of_start_id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact__2.sales_person_id=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2], props={OUTPUT_COLS=[SugarCRMDataSource_public_sales_location__2.id, SugarCRMDataSource_public_sales_location__2.state], EST_COL_STATS={SugarCRMDataSource_public_sales_location__2.id=[-1.0, -1.0], SugarCRMDataSource_public_sales_location__2.zipcode=[-1.0, -1.0], SugarCRMDataSource_public_sales_location__2.city=[-1.0, -1.0], SugarCRMDataSource_public_sales_location__2.state=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2, anon_grp7], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000, OUTPUT_COLS=[anon_grp7.gcol0, anon_grp7.gcol1], EST_CARDINALITY=-1.0}) Group(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2, anon_grp7], props={GROUP_COLS=[FoodmartDataSource_public_store__2.store_state, FoodmartDataSource_public_store__2.store_country], SYMBOL_MAP={anon_grp7.gcol0=FoodmartDataSource_public_store__2.store_state, anon_grp7.gcol1=FoodmartDataSource_public_store__2.store_country}, EST_CARDINALITY=-1.0, OUTPUT_COLS=[anon_grp7.gcol0, anon_grp7.gcol1]}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2], props={OUTPUT_COLS=[FoodmartDataSource_public_store__2.store_state, FoodmartDataSource_public_store__2.store_country], EST_COL_STATS={FoodmartDataSource_public_store__2.store_id=[-1.0, -1.0], FoodmartDataSource_public_store__2.store_type=[-1.0, -1.0], FoodmartDataSource_public_store__2.region_id=[-1.0, -1.0], FoodmartDataSource_public_store__2.store_name=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Project(groups=[anon_grp3], props={PROJECT_COLS=[null AS SugarCRMDataSource_public_sales_location_country, null AS FoodmartDataSource_public_store_store_country, '0|0' AS JS_Discriminator_COL, anon_grp3.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount], OUTPUT_COLS=[null AS SugarCRMDataSource_public_sales_location_country, null AS FoodmartDataSource_public_store_store_country, '0|0' AS JS_Discriminator_COL, anon_grp3.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount]}) Group(groups=[anon_grp3], props={SYMBOL_MAP={anon_grp3.agg0=COUNT(DISTINCT SugarCRMDataSource_public_sales_fact__3.amount)}, OUTPUT_COLS=[anon_grp3.agg0]}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_location__3.state = FoodmartDataSource_public_store__3.store_state], LEFT_EXPRESSIONS=[SugarCRMDataSource_public_sales_location__3.state], RIGHT_EXPRESSIONS=[FoodmartDataSource_public_store__3.store_state], NON_EQUI_JOIN_CRITERIA=[], OUTPUT_COLS=[SugarCRMDataSource_public_sales_fact__3.amount]}) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3], props={SOURCE_HINT=null, MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, OUTPUT_COLS=[SugarCRMDataSource_public_sales_location__3.state, SugarCRMDataSource_public_sales_fact__3.amount], CONFORMED_SOURCES=null, EST_CARDINALITY=-1.0}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[SugarCRMDataSource_public_sales_fact__3.sales_location_id = SugarCRMDataSource_public_sales_location__3.id], OUTPUT_COLS=[SugarCRMDataSource_public_sales_location__3.state, SugarCRMDataSource_public_sales_fact__3.amount], MODEL_ID=Schema name=SugarCRMDataSource_public, nameInSource=null, uuid=tid:79a393f6d89f-81fd2b7b-00000000, IS_COPIED=true, EST_CARDINALITY=-1.0}) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3], props={OUTPUT_COLS=[SugarCRMDataSource_public_sales_fact__3.sales_location_id, SugarCRMDataSource_public_sales_fact__3.amount], EST_COL_STATS={SugarCRMDataSource_public_sales_fact__3.id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact__3.sales_date_of_close_id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact__3.sales_date_of_start_id=[-1.0, -1.0], SugarCRMDataSource_public_sales_fact__3.sales_person_id=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3], props={OUTPUT_COLS=[SugarCRMDataSource_public_sales_location__3.id, SugarCRMDataSource_public_sales_location__3.state], EST_COL_STATS={SugarCRMDataSource_public_sales_location__3.id=[-1.0, -1.0], SugarCRMDataSource_public_sales_location__3.zipcode=[-1.0, -1.0], SugarCRMDataSource_public_sales_location__3.city=[-1.0, -1.0], SugarCRMDataSource_public_sales_location__3.state=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3], props={SOURCE_HINT=null, MODEL_ID=Schema name=FoodmartDataSource_public, nameInSource=null, uuid=tid:aa7e68178eb3-561de18f-00000000, OUTPUT_COLS=[FoodmartDataSource_public_store__3.store_state], EST_CARDINALITY=-1.0}) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3], props={OUTPUT_COLS=[FoodmartDataSource_public_store__3.store_state], EST_COL_STATS={FoodmartDataSource_public_store__3.store_id=[-1.0, -1.0], FoodmartDataSource_public_store__3.store_type=[-1.0, -1.0], FoodmartDataSource_public_store__3.region_id=[-1.0, -1.0], FoodmartDataSource_public_store__3.store_name=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0}) ============================================================================ EXECUTING PushLimit AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1000, OUTPUT_COLS=[anon_grp0.gcol0 AS SugarCRMDataSource_public_sales_location_country, anon_grp0.gcol1 AS FoodmartDataSource_public_store_store_country, '1|1' AS JS_Discriminator_COL, anon_grp0.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount]}) Sort(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location], props={SORT_ORDER=ORDER BY SugarCRMDataSource_public_sales_location_country, FoodmartDataSource_public_store_store_country, OUTPUT_COLS=[anon_grp0.gcol0 AS SugarCRMDataSource_public_sales_location_country, anon_grp0.gcol1 AS FoodmartDataSource_public_store_store_country, '1|1' AS JS_Discriminator_COL, anon_grp0.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount], UNRELATED_SORT=true}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=[anon_grp0.gcol0 AS SugarCRMDataSource_public_sales_location_country, anon_grp0.gcol1 AS FoodmartDataSource_public_store_store_country, '1|1' AS JS_Discriminator_COL, anon_grp0.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount, SugarCRMDataSource_public_sales_location.country AS SugarCRMDataSource_public_sales_location_country, FoodmartDataSource_public_store.store_country AS FoodmartDataSource_public_store_store_country]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=[anon_grp0.gcol0 AS SugarCRMDataSource_public_sales_location_country, anon_grp0.gcol1 AS FoodmartDataSource_public_store_store_country, '1|1' AS JS_Discriminator_COL, anon_grp0.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=[anon_grp0.gcol0 AS SugarCRMDataSource_public_sales_location_country, anon_grp0.gcol1 AS FoodmartDataSource_public_store_store_country, '1|1' AS JS_Discriminator_COL, anon_grp0.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount]}) Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS SugarCRMDataSource_public_sales_location_country, anon_grp0.gcol1 AS FoodmartDataSource_public_store_store_country, '1|1' AS JS_Discriminator_COL, anon_grp0.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount], OUTPUT_COLS=[anon_grp0.gcol0 AS SugarCRMDataSource_public_sales_location_country, anon_grp0.gcol1 AS FoodmartDataSource_public_store_store_country, '1|1' AS JS_Discriminator_COL, anon_grp0.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount]}) TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1000, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.agg0], IS_PUSHED=true}) Sort(groups=[], props={SORT_ORDER=ORDER BY anon_grp0.gcol0, anon_grp0.gcol1, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.agg0]}) Group(groups=[anon_grp4, anon_grp5, anon_grp0], props={GROUP_COLS=[anon_grp4.gcol1, anon_grp5.gcol1], SYMBOL_MAP={anon_grp0.gcol0=anon_grp4.gcol1, anon_grp0.gcol1=anon_grp5.gcol1, anon_grp0.agg0=COUNT(DISTINCT anon_grp4.gcol2)}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.agg0]}) Join(groups=[anon_grp4, anon_grp5]) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, anon_grp4]) Group(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location, anon_grp4]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, anon_grp5]) Group(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store, anon_grp5]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store]) TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1000, OUTPUT_COLS=[anon_grp1.gcol0 AS SugarCRMDataSource_public_sales_location_country, null AS FoodmartDataSource_public_store_store_country, '1|0' AS JS_Discriminator_COL, anon_grp1.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount], IS_PUSHED=true}) Sort(groups=[], props={SORT_ORDER=ORDER BY SugarCRMDataSource_public_sales_location_country, FoodmartDataSource_public_store_store_country, OUTPUT_COLS=[anon_grp1.gcol0 AS SugarCRMDataSource_public_sales_location_country, null AS FoodmartDataSource_public_store_store_country, '1|0' AS JS_Discriminator_COL, anon_grp1.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount]}) Project(groups=[anon_grp1], props={PROJECT_COLS=[anon_grp1.gcol0 AS SugarCRMDataSource_public_sales_location_country, null AS FoodmartDataSource_public_store_store_country, '1|0' AS JS_Discriminator_COL, anon_grp1.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount], OUTPUT_COLS=[anon_grp1.gcol0 AS SugarCRMDataSource_public_sales_location_country, null AS FoodmartDataSource_public_store_store_country, '1|0' AS JS_Discriminator_COL, anon_grp1.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount]}) Group(groups=[anon_grp6, anon_grp1], props={GROUP_COLS=[anon_grp6.gcol1], SYMBOL_MAP={anon_grp1.gcol0=anon_grp6.gcol1, anon_grp1.agg0=COUNT(DISTINCT anon_grp6.gcol2)}, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.agg0]}) Join(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1, anon_grp6]) Access(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1, SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, anon_grp6]) Group(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1, SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, anon_grp6]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__1]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__1]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__1]) TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1000, OUTPUT_COLS=[null AS SugarCRMDataSource_public_sales_location_country, anon_grp2.gcol0 AS FoodmartDataSource_public_store_store_country, '0|1' AS JS_Discriminator_COL, anon_grp2.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount], IS_PUSHED=true}) Sort(groups=[], props={SORT_ORDER=ORDER BY SugarCRMDataSource_public_sales_location_country, FoodmartDataSource_public_store_store_country, OUTPUT_COLS=[null AS SugarCRMDataSource_public_sales_location_country, anon_grp2.gcol0 AS FoodmartDataSource_public_store_store_country, '0|1' AS JS_Discriminator_COL, anon_grp2.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount]}) Project(groups=[anon_grp2], props={PROJECT_COLS=[null AS SugarCRMDataSource_public_sales_location_country, anon_grp2.gcol0 AS FoodmartDataSource_public_store_store_country, '0|1' AS JS_Discriminator_COL, anon_grp2.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount], OUTPUT_COLS=[null AS SugarCRMDataSource_public_sales_location_country, anon_grp2.gcol0 AS FoodmartDataSource_public_store_store_country, '0|1' AS JS_Discriminator_COL, anon_grp2.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount]}) Group(groups=[anon_grp7, anon_grp2], props={GROUP_COLS=[anon_grp7.gcol1], SYMBOL_MAP={anon_grp2.gcol0=anon_grp7.gcol1, anon_grp2.agg0=COUNT(DISTINCT SugarCRMDataSource_public_sales_fact__2.amount)}, OUTPUT_COLS=[anon_grp2.gcol0, anon_grp2.agg0]}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2, anon_grp7]) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__2]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__2]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2, anon_grp7]) Group(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2, anon_grp7]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__2]) TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=1000, OUTPUT_COLS=[null AS SugarCRMDataSource_public_sales_location_country, null AS FoodmartDataSource_public_store_store_country, '0|0' AS JS_Discriminator_COL, anon_grp3.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount], IS_PUSHED=true}) Sort(groups=[], props={SORT_ORDER=ORDER BY SugarCRMDataSource_public_sales_location_country, FoodmartDataSource_public_store_store_country, OUTPUT_COLS=[null AS SugarCRMDataSource_public_sales_location_country, null AS FoodmartDataSource_public_store_store_country, '0|0' AS JS_Discriminator_COL, anon_grp3.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount]}) Project(groups=[anon_grp3], props={PROJECT_COLS=[null AS SugarCRMDataSource_public_sales_location_country, null AS FoodmartDataSource_public_store_store_country, '0|0' AS JS_Discriminator_COL, anon_grp3.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount], OUTPUT_COLS=[null AS SugarCRMDataSource_public_sales_location_country, null AS FoodmartDataSource_public_store_store_country, '0|0' AS JS_Discriminator_COL, anon_grp3.agg0 AS CountDistinct_SugarCRMDataSource_public_sales_fact_amount]}) Group(groups=[anon_grp3], props={SYMBOL_MAP={anon_grp3.agg0=COUNT(DISTINCT SugarCRMDataSource_public_sales_fact__3.amount)}, OUTPUT_COLS=[anon_grp3.agg0]}) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3, FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3]) Access(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3]) Join(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3, SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3]) Source(groups=[SugarCRMDataSource_public.sales_fact AS SugarCRMDataSource_public_sales_fact__3]) Source(groups=[SugarCRMDataSource_public.sales_location AS SugarCRMDataSource_public_sales_location__3]) Access(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3]) Source(groups=[FoodmartDataSource_public.store AS FoodmartDataSource_public_store__3]) ============================================================================