============================================================================ USER COMMAND: SELECT v.infectionid, v.linkcultureid, v.responsibleculture, COUNT(*) FROM (SELECT l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts FROM ((((#tmp_admissions AS adm INNER JOIN cosara2.cos2_links AS l ON l.admissionid = convert(adm.patientid, string)) INNER JOIN cosara2.cos2_link_culture AS lc ON lc.linkid = l.id) LEFT OUTER JOIN cosara2.cos2_lab_culture AS cl ON cl.culturenumber = lc.culturenr AND cl.specimennumber = lc.culturespecimennr AND cl.sampleinsertts = lc.culturesampleinsertts) LEFT OUTER JOIN cosara2.cos2_lab_sample AS ls ON ls.inserttime = cl.sampleinsertts AND ls.specimennumber = cl.specimennumber) LEFT OUTER JOIN cosara2.cos2_antibiogramresistences AS abr ON abr.specimennumber = cl.specimennumber AND abr.culturenumber = cl.culturenumber AND abr.sampleinsertts = cl.sampleinsertts) AS v GROUP BY v.infectionid, v.linkcultureid, v.responsibleculture ---------------------------------------------------------------------------- OPTIMIZE: SELECT v.infectionid, v.linkcultureid, v.responsibleculture, COUNT(*) FROM (SELECT l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts FROM ((((#tmp_admissions AS adm INNER JOIN cosara2.cos2_links AS l ON l.admissionid = convert(adm.patientid, string)) INNER JOIN cosara2.cos2_link_culture AS lc ON lc.linkid = l.id) LEFT OUTER JOIN cosara2.cos2_lab_culture AS cl ON cl.culturenumber = lc.culturenr AND cl.specimennumber = lc.culturespecimennr AND cl.sampleinsertts = lc.culturesampleinsertts) LEFT OUTER JOIN cosara2.cos2_lab_sample AS ls ON ls.inserttime = cl.sampleinsertts AND ls.specimennumber = cl.specimennumber) LEFT OUTER JOIN cosara2.cos2_antibiogramresistences AS abr ON abr.specimennumber = cl.specimennumber AND abr.culturenumber = cl.culturenumber AND abr.sampleinsertts = cl.sampleinsertts) AS v GROUP BY v.infectionid, v.linkcultureid, v.responsibleculture ---------------------------------------------------------------------------- GENERATE CANONICAL: SELECT v.infectionid, v.linkcultureid, v.responsibleculture, COUNT(*) FROM (SELECT l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts FROM ((((#tmp_admissions AS adm INNER JOIN cosara2.cos2_links AS l ON l.admissionid = convert(adm.patientid, string)) INNER JOIN cosara2.cos2_link_culture AS lc ON lc.linkid = l.id) LEFT OUTER JOIN cosara2.cos2_lab_culture AS cl ON cl.culturenumber = lc.culturenr AND cl.specimennumber = lc.culturespecimennr AND cl.sampleinsertts = lc.culturesampleinsertts) LEFT OUTER JOIN cosara2.cos2_lab_sample AS ls ON ls.inserttime = cl.sampleinsertts AND ls.specimennumber = cl.specimennumber) LEFT OUTER JOIN cosara2.cos2_antibiogramresistences AS abr ON abr.specimennumber = cl.specimennumber AND abr.culturenumber = cl.culturenumber AND abr.sampleinsertts = cl.sampleinsertts) AS v GROUP BY v.infectionid, v.linkcultureid, v.responsibleculture CANONICAL PLAN: Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS infectionid, anon_grp0.gcol1 AS linkcultureid, anon_grp0.gcol2 AS responsibleculture, anon_grp0.agg0 AS expr4]}) Group(groups=[v, anon_grp0], props={GROUP_COLS=[v.infectionid, v.linkcultureid, v.responsibleculture], SYMBOL_MAP={anon_grp0.gcol0=v.infectionid, anon_grp0.gcol1=v.linkcultureid, anon_grp0.gcol2=v.responsibleculture, anon_grp0.agg0=COUNT(*)}}) Source(groups=[v], props={NESTED_COMMAND=SELECT l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts FROM ((((#tmp_admissions AS adm INNER JOIN cosara2.cos2_links AS l ON l.admissionid = convert(adm.patientid, string)) INNER JOIN cosara2.cos2_link_culture AS lc ON lc.linkid = l.id) LEFT OUTER JOIN cosara2.cos2_lab_culture AS cl ON cl.culturenumber = lc.culturenr AND cl.specimennumber = lc.culturespecimennr AND cl.sampleinsertts = lc.culturesampleinsertts) LEFT OUTER JOIN cosara2.cos2_lab_sample AS ls ON ls.inserttime = cl.sampleinsertts AND ls.specimennumber = cl.specimennumber) LEFT OUTER JOIN cosara2.cos2_antibiogramresistences AS abr ON abr.specimennumber = cl.specimennumber AND abr.culturenumber = cl.culturenumber AND abr.sampleinsertts = cl.sampleinsertts, SYMBOL_MAP={v.infectionid=l.infectionid, v.linkid=l.id, v.linkcultureid=lc.linkcultureid, v.responsibleculture=lc.responsibleculture, v.culturealternative=lc.culturealternative, v.sampleinsertts=cl.sampleinsertts, v.specimennumber=cl.specimennumber, v.culturenumber=cl.culturenumber, v.culturename=cl.culturename, v.quotation=cl.quotation, v.material=ls.material, v.sampletime=ls.sampletime, v.abgram_culturenumber=abr.culturenumber, v.antibiogrampart=abr.antibiogrampart, v.resisttype=abr.resisttype, v.antibiogramculturenr=lc.antibiogramculturenr, v.antibiogramspecimennr=lc.antibiogramspecimennr, v.antibiogramsampleinsertts=lc.antibiogramsampleinsertts}}) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l], props={PROJECT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)]}) Source(groups=[#tmp_admissions AS adm]) Source(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_link_culture AS lc]) Source(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING PlaceAccess AFTER: Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS infectionid, anon_grp0.gcol1 AS linkcultureid, anon_grp0.gcol2 AS responsibleculture, anon_grp0.agg0 AS expr4]}) Group(groups=[v, anon_grp0], props={GROUP_COLS=[v.infectionid, v.linkcultureid, v.responsibleculture], SYMBOL_MAP={anon_grp0.gcol0=v.infectionid, anon_grp0.gcol1=v.linkcultureid, anon_grp0.gcol2=v.responsibleculture, anon_grp0.agg0=COUNT(*)}}) Source(groups=[v], props={NESTED_COMMAND=SELECT l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts FROM ((((#tmp_admissions AS adm INNER JOIN cosara2.cos2_links AS l ON l.admissionid = convert(adm.patientid, string)) INNER JOIN cosara2.cos2_link_culture AS lc ON lc.linkid = l.id) LEFT OUTER JOIN cosara2.cos2_lab_culture AS cl ON cl.culturenumber = lc.culturenr AND cl.specimennumber = lc.culturespecimennr AND cl.sampleinsertts = lc.culturesampleinsertts) LEFT OUTER JOIN cosara2.cos2_lab_sample AS ls ON ls.inserttime = cl.sampleinsertts AND ls.specimennumber = cl.specimennumber) LEFT OUTER JOIN cosara2.cos2_antibiogramresistences AS abr ON abr.specimennumber = cl.specimennumber AND abr.culturenumber = cl.culturenumber AND abr.sampleinsertts = cl.sampleinsertts, SYMBOL_MAP={v.infectionid=l.infectionid, v.linkid=l.id, v.linkcultureid=lc.linkcultureid, v.responsibleculture=lc.responsibleculture, v.culturealternative=lc.culturealternative, v.sampleinsertts=cl.sampleinsertts, v.specimennumber=cl.specimennumber, v.culturenumber=cl.culturenumber, v.culturename=cl.culturename, v.quotation=cl.quotation, v.material=ls.material, v.sampletime=ls.sampletime, v.abgram_culturenumber=abr.culturenumber, v.antibiogrampart=abr.antibiogrampart, v.resisttype=abr.resisttype, v.antibiogramculturenr=lc.antibiogramculturenr, v.antibiogramspecimennr=lc.antibiogramspecimennr, v.antibiogramsampleinsertts=lc.antibiogramsampleinsertts}}) Project(groups=[cosara2.cos2_antibiogramresistences AS abr, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_sample AS ls, cosara2.cos2_lab_culture AS cl, cosara2.cos2_links AS l], props={PROJECT_COLS=[l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)]}) Access(groups=[#tmp_admissions AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__}) Source(groups=[#tmp_admissions AS adm]) Access(groups=[cosara2.cos2_links AS l], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896}) Source(groups=[cosara2.cos2_links AS l]) Access(groups=[cosara2.cos2_link_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896}) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896}) Source(groups=[cosara2.cos2_lab_culture AS cl]) Access(groups=[cosara2.cos2_lab_sample AS ls], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896}) Source(groups=[cosara2.cos2_lab_sample AS ls]) Access(groups=[cosara2.cos2_antibiogramresistences AS abr], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896}) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING AssignOutputElements AFTER: Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS infectionid, anon_grp0.gcol1 AS linkcultureid, anon_grp0.gcol2 AS responsibleculture, anon_grp0.agg0 AS expr4], OUTPUT_COLS=[anon_grp0.gcol0 AS infectionid, anon_grp0.gcol1 AS linkcultureid, anon_grp0.gcol2 AS responsibleculture, anon_grp0.agg0 AS expr4]}) Group(groups=[v, anon_grp0], props={GROUP_COLS=[v.infectionid, v.linkcultureid, v.responsibleculture], SYMBOL_MAP={anon_grp0.gcol0=v.infectionid, anon_grp0.gcol1=v.linkcultureid, anon_grp0.gcol2=v.responsibleculture, anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.gcol2, anon_grp0.agg0]}) Source(groups=[v], props={NESTED_COMMAND=SELECT l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts FROM ((((#tmp_admissions AS adm INNER JOIN cosara2.cos2_links AS l ON l.admissionid = convert(adm.patientid, string)) INNER JOIN cosara2.cos2_link_culture AS lc ON lc.linkid = l.id) LEFT OUTER JOIN cosara2.cos2_lab_culture AS cl ON cl.culturenumber = lc.culturenr AND cl.specimennumber = lc.culturespecimennr AND cl.sampleinsertts = lc.culturesampleinsertts) LEFT OUTER JOIN cosara2.cos2_lab_sample AS ls ON ls.inserttime = cl.sampleinsertts AND ls.specimennumber = cl.specimennumber) LEFT OUTER JOIN cosara2.cos2_antibiogramresistences AS abr ON abr.specimennumber = cl.specimennumber AND abr.culturenumber = cl.culturenumber AND abr.sampleinsertts = cl.sampleinsertts, SYMBOL_MAP={v.infectionid=l.infectionid, v.linkcultureid=lc.linkcultureid, v.responsibleculture=lc.responsibleculture}, OUTPUT_COLS=[v.infectionid, v.linkcultureid, v.responsibleculture]}) Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l], props={PROJECT_COLS=[l.infectionid, lc.linkcultureid, lc.responsibleculture], OUTPUT_COLS=[l.infectionid, lc.linkcultureid, lc.responsibleculture]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], OUTPUT_COLS=[l.infectionid, lc.linkcultureid, lc.responsibleculture]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], OUTPUT_COLS=[cl.specimennumber, cl.culturenumber, cl.sampleinsertts, l.infectionid, lc.linkcultureid, lc.responsibleculture]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=[cl.sampleinsertts, cl.specimennumber, cl.culturenumber, l.infectionid, lc.linkcultureid, lc.responsibleculture]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], OUTPUT_COLS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, lc.linkcultureid, lc.responsibleculture]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], OUTPUT_COLS=[l.id, l.infectionid]}) Access(groups=[#tmp_admissions AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=[adm.patientid]}) Source(groups=[#tmp_admissions AS adm], props={OUTPUT_COLS=[adm.patientid]}) Access(groups=[cosara2.cos2_links AS l], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[l.admissionid, l.id, l.infectionid]}) Source(groups=[cosara2.cos2_links AS l], props={OUTPUT_COLS=[l.admissionid, l.id, l.infectionid]}) Access(groups=[cosara2.cos2_link_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[lc.linkid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, lc.linkcultureid, lc.responsibleculture]}) Source(groups=[cosara2.cos2_link_culture AS lc], props={OUTPUT_COLS=[lc.linkid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, lc.linkcultureid, lc.responsibleculture]}) Access(groups=[cosara2.cos2_lab_culture AS cl], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts]}) Source(groups=[cosara2.cos2_lab_culture AS cl], props={OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts]}) Access(groups=[cosara2.cos2_lab_sample AS ls], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[ls.inserttime, ls.specimennumber]}) Source(groups=[cosara2.cos2_lab_sample AS ls], props={OUTPUT_COLS=[ls.inserttime, ls.specimennumber]}) Access(groups=[cosara2.cos2_antibiogramresistences AS abr], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[abr.specimennumber, abr.culturenumber, abr.sampleinsertts]}) Source(groups=[cosara2.cos2_antibiogramresistences AS abr], props={OUTPUT_COLS=[abr.specimennumber, abr.culturenumber, abr.sampleinsertts]}) ============================================================================ EXECUTING RemoveOptionalJoins AFTER: Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS infectionid, anon_grp0.gcol1 AS linkcultureid, anon_grp0.gcol2 AS responsibleculture, anon_grp0.agg0 AS expr4], OUTPUT_COLS=[anon_grp0.gcol0 AS infectionid, anon_grp0.gcol1 AS linkcultureid, anon_grp0.gcol2 AS responsibleculture, anon_grp0.agg0 AS expr4]}) Group(groups=[v, anon_grp0], props={GROUP_COLS=[v.infectionid, v.linkcultureid, v.responsibleculture], SYMBOL_MAP={anon_grp0.gcol0=v.infectionid, anon_grp0.gcol1=v.linkcultureid, anon_grp0.gcol2=v.responsibleculture, anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.gcol2, anon_grp0.agg0]}) Source(groups=[v], props={NESTED_COMMAND=SELECT l.infectionid, l.id AS linkid, lc.linkcultureid, lc.responsibleculture, lc.culturealternative, cl.sampleinsertts, cl.specimennumber, cl.culturenumber, cl.culturename, cl.quotation, ls.material, ls.sampletime, abr.culturenumber AS abgram_culturenumber, abr.antibiogrampart, abr.resisttype, lc.antibiogramculturenr, lc.antibiogramspecimennr, lc.antibiogramsampleinsertts FROM ((((#tmp_admissions AS adm INNER JOIN cosara2.cos2_links AS l ON l.admissionid = convert(adm.patientid, string)) INNER JOIN cosara2.cos2_link_culture AS lc ON lc.linkid = l.id) LEFT OUTER JOIN cosara2.cos2_lab_culture AS cl ON cl.culturenumber = lc.culturenr AND cl.specimennumber = lc.culturespecimennr AND cl.sampleinsertts = lc.culturesampleinsertts) LEFT OUTER JOIN cosara2.cos2_lab_sample AS ls ON ls.inserttime = cl.sampleinsertts AND ls.specimennumber = cl.specimennumber) LEFT OUTER JOIN cosara2.cos2_antibiogramresistences AS abr ON abr.specimennumber = cl.specimennumber AND abr.culturenumber = cl.culturenumber AND abr.sampleinsertts = cl.sampleinsertts, SYMBOL_MAP={v.infectionid=l.infectionid, v.linkcultureid=lc.linkcultureid, v.responsibleculture=lc.responsibleculture}, OUTPUT_COLS=[v.infectionid, v.linkcultureid, v.responsibleculture]}) Project(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l], props={PROJECT_COLS=[l.infectionid, lc.linkcultureid, lc.responsibleculture], OUTPUT_COLS=[l.infectionid, lc.linkcultureid, lc.responsibleculture]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], OUTPUT_COLS=[l.infectionid, lc.linkcultureid, lc.responsibleculture]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], OUTPUT_COLS=[cl.specimennumber, cl.culturenumber, cl.sampleinsertts, l.infectionid, lc.linkcultureid, lc.responsibleculture]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=[cl.sampleinsertts, cl.specimennumber, cl.culturenumber, l.infectionid, lc.linkcultureid, lc.responsibleculture]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], OUTPUT_COLS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, lc.linkcultureid, lc.responsibleculture]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], OUTPUT_COLS=[l.id, l.infectionid]}) Access(groups=[#tmp_admissions AS adm]) Source(groups=[#tmp_admissions AS adm]) Access(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Access(groups=[cosara2.cos2_link_culture AS lc]) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_culture AS cl]) Access(groups=[cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_lab_sample AS ls]) Access(groups=[cosara2.cos2_antibiogramresistences AS abr]) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING MergeVirtual AFTER: Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS infectionid, anon_grp0.gcol1 AS linkcultureid, anon_grp0.gcol2 AS responsibleculture, anon_grp0.agg0 AS expr4], OUTPUT_COLS=[anon_grp0.gcol0 AS infectionid, anon_grp0.gcol1 AS linkcultureid, anon_grp0.gcol2 AS responsibleculture, anon_grp0.agg0 AS expr4]}) Group(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, anon_grp0], props={GROUP_COLS=[l.infectionid, lc.linkcultureid, lc.responsibleculture], SYMBOL_MAP={anon_grp0.gcol0=l.infectionid, anon_grp0.gcol1=lc.linkcultureid, anon_grp0.gcol2=lc.responsibleculture, anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.gcol2, anon_grp0.agg0]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], OUTPUT_COLS=[l.infectionid, lc.linkcultureid, lc.responsibleculture]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls]) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl]) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc]) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l]) Access(groups=[#tmp_admissions AS adm]) Source(groups=[#tmp_admissions AS adm]) Access(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Access(groups=[cosara2.cos2_link_culture AS lc]) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_culture AS cl]) Access(groups=[cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_lab_sample AS ls]) Access(groups=[cosara2.cos2_antibiogramresistences AS abr]) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING PushNonJoinCriteria AFTER: Project(groups=[anon_grp0]) Group(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, anon_grp0]) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], OUTPUT_COLS=[l.infectionid, lc.linkcultureid, lc.responsibleculture]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], OUTPUT_COLS=[cl.specimennumber, cl.culturenumber, cl.sampleinsertts, l.infectionid, lc.linkcultureid, lc.responsibleculture]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=[cl.sampleinsertts, cl.specimennumber, cl.culturenumber, l.infectionid, lc.linkcultureid, lc.responsibleculture]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], OUTPUT_COLS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, lc.linkcultureid, lc.responsibleculture]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], OUTPUT_COLS=[l.id, l.infectionid]}) Access(groups=[#tmp_admissions AS adm]) Source(groups=[#tmp_admissions AS adm]) Access(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Access(groups=[cosara2.cos2_link_culture AS lc]) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_culture AS cl]) Access(groups=[cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_lab_sample AS ls]) Access(groups=[cosara2.cos2_antibiogramresistences AS abr]) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING CleanCriteria AFTER: Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS infectionid, anon_grp0.gcol1 AS linkcultureid, anon_grp0.gcol2 AS responsibleculture, anon_grp0.agg0 AS expr4], OUTPUT_COLS=null}) Group(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, anon_grp0], props={GROUP_COLS=[l.infectionid, lc.linkcultureid, lc.responsibleculture], SYMBOL_MAP={anon_grp0.gcol0=l.infectionid, anon_grp0.gcol1=lc.linkcultureid, anon_grp0.gcol2=lc.responsibleculture, anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=null}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], OUTPUT_COLS=null}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], OUTPUT_COLS=null}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=null}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], OUTPUT_COLS=null}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], OUTPUT_COLS=null}) Access(groups=[#tmp_admissions AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null}) Source(groups=[#tmp_admissions AS adm], props={OUTPUT_COLS=null}) Access(groups=[cosara2.cos2_links AS l], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_links AS l], props={OUTPUT_COLS=null}) Access(groups=[cosara2.cos2_link_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_link_culture AS lc], props={OUTPUT_COLS=null}) Access(groups=[cosara2.cos2_lab_culture AS cl], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_lab_culture AS cl], props={OUTPUT_COLS=null}) Access(groups=[cosara2.cos2_lab_sample AS ls], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_lab_sample AS ls], props={OUTPUT_COLS=null}) Access(groups=[cosara2.cos2_antibiogramresistences AS abr], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_antibiogramresistences AS abr], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING RaiseAccess AFTER: Project(groups=[anon_grp0]) Group(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, anon_grp0]) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], OUTPUT_COLS=null}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], OUTPUT_COLS=null}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=null}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], OUTPUT_COLS=null}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], OUTPUT_COLS=null}) Access(groups=[#tmp_admissions AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null}) Source(groups=[#tmp_admissions AS adm]) Access(groups=[cosara2.cos2_links AS l], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_links AS l]) Access(groups=[cosara2.cos2_link_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_lab_culture AS cl]) Access(groups=[cosara2.cos2_lab_sample AS ls], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_lab_sample AS ls]) Access(groups=[cosara2.cos2_antibiogramresistences AS abr], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING CopyCriteria AFTER: Project(groups=[anon_grp0]) Group(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, anon_grp0]) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[#tmp_admissions AS adm]) Source(groups=[#tmp_admissions AS adm]) Access(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Access(groups=[cosara2.cos2_link_culture AS lc]) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_culture AS cl]) Access(groups=[cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_lab_sample AS ls]) Access(groups=[cosara2.cos2_antibiogramresistences AS abr]) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING CleanCriteria AFTER: Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS infectionid, anon_grp0.gcol1 AS linkcultureid, anon_grp0.gcol2 AS responsibleculture, anon_grp0.agg0 AS expr4], OUTPUT_COLS=null}) Group(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, anon_grp0], props={GROUP_COLS=[l.infectionid, lc.linkcultureid, lc.responsibleculture], SYMBOL_MAP={anon_grp0.gcol0=l.infectionid, anon_grp0.gcol1=lc.linkcultureid, anon_grp0.gcol2=lc.responsibleculture, anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=null}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], OUTPUT_COLS=null, IS_COPIED=true}) Access(groups=[#tmp_admissions AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null}) Source(groups=[#tmp_admissions AS adm], props={OUTPUT_COLS=null}) Access(groups=[cosara2.cos2_links AS l], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_links AS l], props={OUTPUT_COLS=null}) Access(groups=[cosara2.cos2_link_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_link_culture AS lc], props={OUTPUT_COLS=null}) Access(groups=[cosara2.cos2_lab_culture AS cl], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_lab_culture AS cl], props={OUTPUT_COLS=null}) Access(groups=[cosara2.cos2_lab_sample AS ls], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_lab_sample AS ls], props={OUTPUT_COLS=null}) Access(groups=[cosara2.cos2_antibiogramresistences AS abr], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_antibiogramresistences AS abr], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING PlanJoins AFTER: Project(groups=[anon_grp0]) Group(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, anon_grp0]) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=null, IS_COPIED=true}) Select(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l], props={SELECT_CRITERIA=l.admissionid = convert(adm.patientid, string), EST_SELECTIVITY=0.037}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP}) Access(groups=[#tmp_admissions AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null, EST_CARDINALITY=8047.0, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}}) Source(groups=[#tmp_admissions AS adm], props={OUTPUT_COLS=null, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}, EST_CARDINALITY=8047.0}) Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=10953.902, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}}) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=10953.902, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}}) Source(groups=[cosara2.cos2_links AS l], props={OUTPUT_COLS=null, EST_COL_STATS={l.id=[-1.0, -1.0], l.admissionid=[-1.0, -1.0], l.edittime=[-1.0, -1.0], l.infectionid=[-1.0, -1.0], ...}, EST_CARDINALITY=12000.0}) Source(groups=[cosara2.cos2_link_culture AS lc], props={OUTPUT_COLS=null, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, EST_CARDINALITY=10000.0}) Access(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_culture AS cl]) Access(groups=[cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_lab_sample AS ls]) Access(groups=[cosara2.cos2_antibiogramresistences AS abr]) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING PushSelectCriteria AFTER: Project(groups=[anon_grp0]) Group(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, anon_grp0]) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls]) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)]}) Access(groups=[#tmp_admissions AS adm]) Source(groups=[#tmp_admissions AS adm]) Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc]) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_culture AS cl]) Access(groups=[cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_lab_sample AS ls]) Access(groups=[cosara2.cos2_antibiogramresistences AS abr]) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING RaiseAccess AFTER: Project(groups=[anon_grp0]) Group(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, anon_grp0]) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], OUTPUT_COLS=null, IS_COPIED=true}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)]}) Access(groups=[#tmp_admissions AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null, EST_CARDINALITY=8047.0, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}}) Source(groups=[#tmp_admissions AS adm]) Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=10953.902, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}}) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_lab_culture AS cl]) Access(groups=[cosara2.cos2_lab_sample AS ls], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_lab_sample AS ls]) Access(groups=[cosara2.cos2_antibiogramresistences AS abr], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING PlanOuterJoins AFTER: Project(groups=[anon_grp0]) Group(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, anon_grp0], props={GROUP_COLS=[l.infectionid, lc.linkcultureid, lc.responsibleculture], SYMBOL_MAP={anon_grp0.gcol0=l.infectionid, anon_grp0.gcol1=lc.linkcultureid, anon_grp0.gcol2=lc.responsibleculture, anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=null}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)]}) Access(groups=[#tmp_admissions AS adm]) Source(groups=[#tmp_admissions AS adm]) Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc]) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null, CONFORMED_SOURCES=null}) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896}) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896}) Source(groups=[cosara2.cos2_lab_culture AS cl], props={OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_lab_sample AS ls], props={OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_antibiogramresistences AS abr], props={OUTPUT_COLS=null}) ============================================================================ EXECUTING ChooseJoinStrategy AFTER: Project(groups=[anon_grp0]) Group(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, anon_grp0]) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], LEFT_EXPRESSIONS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], RIGHT_EXPRESSIONS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts], NON_EQUI_JOIN_CRITERIA=[]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], LEFT_EXPRESSIONS=[convert(adm.patientid, string)], RIGHT_EXPRESSIONS=[l.admissionid], NON_EQUI_JOIN_CRITERIA=[]}) Access(groups=[#tmp_admissions AS adm]) Source(groups=[#tmp_admissions AS adm]) Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc]) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING ChooseDependent AFTER: Project(groups=[anon_grp0]) Group(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, anon_grp0]) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[cl.culturenumber = lc.culturenr, cl.specimennumber = lc.culturespecimennr, cl.sampleinsertts = lc.culturesampleinsertts], LEFT_EXPRESSIONS=[lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts], RIGHT_EXPRESSIONS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts], NON_EQUI_JOIN_CRITERIA=[]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[l.admissionid = convert(adm.patientid, string)], LEFT_EXPRESSIONS=[convert(adm.patientid, string)], RIGHT_EXPRESSIONS=[l.admissionid], NON_EQUI_JOIN_CRITERIA=[]}) Access(groups=[#tmp_admissions AS adm]) Source(groups=[#tmp_admissions AS adm]) Access(groups=[cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc]) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_link_culture AS lc]) Access(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING PushAggregates AFTER: Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS infectionid, anon_grp0.gcol1 AS linkcultureid, anon_grp0.gcol2 AS responsibleculture, anon_grp0.agg0 AS expr4], OUTPUT_COLS=null}) Group(groups=[anon_grp1, anon_grp0], props={GROUP_COLS=[anon_grp1.gcol4, anon_grp1.gcol5, anon_grp1.gcol6], SYMBOL_MAP={anon_grp0.gcol0=anon_grp1.gcol4, anon_grp0.gcol1=anon_grp1.gcol5, anon_grp0.gcol2=anon_grp1.gcol6, anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=null}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr, anon_grp1], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[cl.culturenumber = anon_grp1.gcol1, cl.specimennumber = anon_grp1.gcol2, cl.sampleinsertts = anon_grp1.gcol3], LEFT_EXPRESSIONS=[anon_grp1.gcol1, anon_grp1.gcol2, anon_grp1.gcol3], RIGHT_EXPRESSIONS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts], NON_EQUI_JOIN_CRITERIA=[]}) Join(groups=[#tmp_admissions AS adm, anon_grp1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[anon_grp1.gcol0 = convert(adm.patientid, string)], LEFT_EXPRESSIONS=[convert(adm.patientid, string)], RIGHT_EXPRESSIONS=[anon_grp1.gcol0], NON_EQUI_JOIN_CRITERIA=[]}) Access(groups=[#tmp_admissions AS adm]) Source(groups=[#tmp_admissions AS adm]) Access(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l, anon_grp1], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}}) Group(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l, anon_grp1], props={GROUP_COLS=[l.admissionid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, lc.linkcultureid, lc.responsibleculture], SYMBOL_MAP={anon_grp1.gcol0=l.admissionid, anon_grp1.gcol1=lc.culturenr, anon_grp1.gcol2=lc.culturespecimennr, anon_grp1.gcol3=lc.culturesampleinsertts, anon_grp1.gcol4=l.infectionid, anon_grp1.gcol5=lc.linkcultureid, anon_grp1.gcol6=lc.responsibleculture}}) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=10953.902, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}}) Source(groups=[cosara2.cos2_links AS l], props={OUTPUT_COLS=null, EST_COL_STATS={l.id=[-1.0, -1.0], l.admissionid=[-1.0, -1.0], l.edittime=[-1.0, -1.0], l.infectionid=[-1.0, -1.0], ...}, EST_CARDINALITY=12000.0}) Source(groups=[cosara2.cos2_link_culture AS lc], props={OUTPUT_COLS=null, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, EST_CARDINALITY=10000.0}) Access(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING ChooseDependent AFTER: Project(groups=[anon_grp0]) Group(groups=[anon_grp1, anon_grp0]) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr, anon_grp1], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[cl.culturenumber = anon_grp1.gcol1, cl.specimennumber = anon_grp1.gcol2, cl.sampleinsertts = anon_grp1.gcol3], LEFT_EXPRESSIONS=[anon_grp1.gcol1, anon_grp1.gcol2, anon_grp1.gcol3], RIGHT_EXPRESSIONS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=null, DEPENDENT_VALUE_SOURCE=$dsc/id10697}) Join(groups=[#tmp_admissions AS adm, anon_grp1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[anon_grp1.gcol0 = convert(adm.patientid, string)], LEFT_EXPRESSIONS=[anon_grp1.gcol0], RIGHT_EXPRESSIONS=[convert(adm.patientid, string)], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=6638.504, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}, DEPENDENT_VALUE_SOURCE=$dsc/id10698}) Access(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l, anon_grp1], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_COL_STATS={anon_grp1.gcol0=[1825.6504, -1.0], anon_grp1.gcol1=[1825.6504, -1.0], anon_grp1.gcol2=[1825.6504, -1.0], anon_grp1.gcol3=[1825.6504, -1.0], ...}, EST_CARDINALITY=5476.951}) Group(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l, anon_grp1], props={GROUP_COLS=[l.admissionid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, lc.linkcultureid, lc.responsibleculture], SYMBOL_MAP={anon_grp1.gcol0=l.admissionid, anon_grp1.gcol1=lc.culturenr, anon_grp1.gcol2=lc.culturespecimennr, anon_grp1.gcol3=lc.culturesampleinsertts, anon_grp1.gcol4=l.infectionid, anon_grp1.gcol5=lc.linkcultureid, anon_grp1.gcol6=lc.responsibleculture}, EST_CARDINALITY=5476.951, EST_COL_STATS={anon_grp1.gcol0=[1825.6504, -1.0], anon_grp1.gcol1=[1825.6504, -1.0], anon_grp1.gcol2=[1825.6504, -1.0], anon_grp1.gcol3=[1825.6504, -1.0], ...}}) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=10953.902, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}}) Source(groups=[cosara2.cos2_links AS l], props={OUTPUT_COLS=null, EST_COL_STATS={l.id=[-1.0, -1.0], l.admissionid=[-1.0, -1.0], l.edittime=[-1.0, -1.0], l.infectionid=[-1.0, -1.0], ...}, EST_CARDINALITY=12000.0}) Source(groups=[cosara2.cos2_link_culture AS lc], props={OUTPUT_COLS=null, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, EST_CARDINALITY=10000.0}) Select(groups=[#tmp_admissions AS adm], props={SELECT_CRITERIA=convert(adm.patientid, string) IN (), IS_DEPENDENT_SET=true}) Access(groups=[#tmp_admissions AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null, EST_CARDINALITY=8047.0, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}}) Source(groups=[#tmp_admissions AS adm], props={OUTPUT_COLS=null, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}, EST_CARDINALITY=8047.0}) Select(groups=[cosara2.cos2_lab_culture AS cl], props={SELECT_CRITERIA=(cl.culturenumber, cl.specimennumber, cl.sampleinsertts) IN (), IS_DEPENDENT_SET=true}) Access(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=301224.2, EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}}) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=301224.2, EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}}) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=259235.25, EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}}) Source(groups=[cosara2.cos2_lab_culture AS cl], props={OUTPUT_COLS=null, EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}, EST_CARDINALITY=80000.0}) Source(groups=[cosara2.cos2_lab_sample AS ls], props={OUTPUT_COLS=null, EST_COL_STATS={ls.inserttime=[-1.0, -1.0], ls.labordernumber=[-1.0, -1.0], ls.material=[-1.0, -1.0], ls.mnemonic=[-1.0, -1.0], ...}, EST_CARDINALITY=210000.0}) Source(groups=[cosara2.cos2_antibiogramresistences AS abr], props={OUTPUT_COLS=null, EST_COL_STATS={abr.specimennumber=[-1.0, -1.0], abr.culturenumber=[-1.0, -1.0], abr.antibiogrampart=[-1.0, -1.0], abr.resisttype=[-1.0, -1.0], ...}, EST_CARDINALITY=350000.0}) ============================================================================ EXECUTING PushSelectCriteria AFTER: Project(groups=[anon_grp0]) Group(groups=[anon_grp1, anon_grp0]) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr, anon_grp1], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[cl.culturenumber = anon_grp1.gcol1, cl.specimennumber = anon_grp1.gcol2, cl.sampleinsertts = anon_grp1.gcol3], LEFT_EXPRESSIONS=[anon_grp1.gcol1, anon_grp1.gcol2, anon_grp1.gcol3], RIGHT_EXPRESSIONS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=null, DEPENDENT_VALUE_SOURCE=$dsc/id10697}) Join(groups=[#tmp_admissions AS adm, anon_grp1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[anon_grp1.gcol0 = convert(adm.patientid, string)], LEFT_EXPRESSIONS=[anon_grp1.gcol0], RIGHT_EXPRESSIONS=[convert(adm.patientid, string)], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=6638.504, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}, DEPENDENT_VALUE_SOURCE=$dsc/id10698}) Access(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l, anon_grp1]) Group(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l, anon_grp1]) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_link_culture AS lc]) Select(groups=[#tmp_admissions AS adm], props={SELECT_CRITERIA=convert(adm.patientid, string) IN (), IS_DEPENDENT_SET=true}) Access(groups=[#tmp_admissions AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null, EST_CARDINALITY=8047.0, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}}) Source(groups=[#tmp_admissions AS adm]) Access(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=301224.2, EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true}) Select(groups=[cosara2.cos2_lab_culture AS cl], props={SELECT_CRITERIA=(cl.culturenumber IN ()) AND (cl.specimennumber IN ()) AND (cl.sampleinsertts IN ()), IS_DEPENDENT_SET=true, IS_PUSHED=true}) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=301224.2, EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}}) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=259235.25, EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}}) Source(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING CleanCriteria AFTER: Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS infectionid, anon_grp0.gcol1 AS linkcultureid, anon_grp0.gcol2 AS responsibleculture, anon_grp0.agg0 AS expr4], OUTPUT_COLS=null}) Group(groups=[anon_grp1, anon_grp0], props={GROUP_COLS=[anon_grp1.gcol4, anon_grp1.gcol5, anon_grp1.gcol6], SYMBOL_MAP={anon_grp0.gcol0=anon_grp1.gcol4, anon_grp0.gcol1=anon_grp1.gcol5, anon_grp0.gcol2=anon_grp1.gcol6, anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=null}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr, anon_grp1], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[cl.culturenumber = anon_grp1.gcol1, cl.specimennumber = anon_grp1.gcol2, cl.sampleinsertts = anon_grp1.gcol3], LEFT_EXPRESSIONS=[anon_grp1.gcol1, anon_grp1.gcol2, anon_grp1.gcol3], RIGHT_EXPRESSIONS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=null, DEPENDENT_VALUE_SOURCE=$dsc/id10697, OUTPUT_COLS=null}) Join(groups=[#tmp_admissions AS adm, anon_grp1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[anon_grp1.gcol0 = convert(adm.patientid, string)], LEFT_EXPRESSIONS=[anon_grp1.gcol0], RIGHT_EXPRESSIONS=[convert(adm.patientid, string)], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=6638.504, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}, DEPENDENT_VALUE_SOURCE=$dsc/id10698, OUTPUT_COLS=null}) Access(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l, anon_grp1], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_COL_STATS={anon_grp1.gcol0=[1825.6504, -1.0], anon_grp1.gcol1=[1825.6504, -1.0], anon_grp1.gcol2=[1825.6504, -1.0], anon_grp1.gcol3=[1825.6504, -1.0], ...}, EST_CARDINALITY=5476.951}) Group(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l, anon_grp1], props={GROUP_COLS=[l.admissionid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, lc.linkcultureid, lc.responsibleculture], SYMBOL_MAP={anon_grp1.gcol0=l.admissionid, anon_grp1.gcol1=lc.culturenr, anon_grp1.gcol2=lc.culturespecimennr, anon_grp1.gcol3=lc.culturesampleinsertts, anon_grp1.gcol4=l.infectionid, anon_grp1.gcol5=lc.linkcultureid, anon_grp1.gcol6=lc.responsibleculture}, EST_CARDINALITY=5476.951, EST_COL_STATS={anon_grp1.gcol0=[1825.6504, -1.0], anon_grp1.gcol1=[1825.6504, -1.0], anon_grp1.gcol2=[1825.6504, -1.0], anon_grp1.gcol3=[1825.6504, -1.0], ...}, OUTPUT_COLS=null}) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=10953.902, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_links AS l], props={OUTPUT_COLS=null, EST_COL_STATS={l.id=[-1.0, -1.0], l.admissionid=[-1.0, -1.0], l.edittime=[-1.0, -1.0], l.infectionid=[-1.0, -1.0], ...}, EST_CARDINALITY=12000.0}) Source(groups=[cosara2.cos2_link_culture AS lc], props={OUTPUT_COLS=null, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, EST_CARDINALITY=10000.0}) Select(groups=[#tmp_admissions AS adm], props={SELECT_CRITERIA=convert(adm.patientid, string) IN (), IS_DEPENDENT_SET=true, OUTPUT_COLS=null}) Access(groups=[#tmp_admissions AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=null, EST_CARDINALITY=8047.0, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}}) Source(groups=[#tmp_admissions AS adm], props={OUTPUT_COLS=null, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}, EST_CARDINALITY=8047.0}) Access(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=null, CONFORMED_SOURCES=null, EST_CARDINALITY=301224.2, EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true}) Select(groups=[cosara2.cos2_lab_culture AS cl], props={SELECT_CRITERIA=(cl.culturenumber IN ()) AND (cl.specimennumber IN ()) AND (cl.sampleinsertts IN ()), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=null}) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=301224.2, EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}, OUTPUT_COLS=null}) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=259235.25, EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}, OUTPUT_COLS=null}) Source(groups=[cosara2.cos2_lab_culture AS cl], props={OUTPUT_COLS=null, EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}, EST_CARDINALITY=80000.0}) Source(groups=[cosara2.cos2_lab_sample AS ls], props={OUTPUT_COLS=null, EST_COL_STATS={ls.inserttime=[-1.0, -1.0], ls.labordernumber=[-1.0, -1.0], ls.material=[-1.0, -1.0], ls.mnemonic=[-1.0, -1.0], ...}, EST_CARDINALITY=210000.0}) Source(groups=[cosara2.cos2_antibiogramresistences AS abr], props={OUTPUT_COLS=null, EST_COL_STATS={abr.specimennumber=[-1.0, -1.0], abr.culturenumber=[-1.0, -1.0], abr.antibiogrampart=[-1.0, -1.0], abr.resisttype=[-1.0, -1.0], ...}, EST_CARDINALITY=350000.0}) ============================================================================ EXECUTING AssignOutputElements AFTER: Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS infectionid, anon_grp0.gcol1 AS linkcultureid, anon_grp0.gcol2 AS responsibleculture, anon_grp0.agg0 AS expr4], OUTPUT_COLS=[anon_grp0.gcol0 AS infectionid, anon_grp0.gcol1 AS linkcultureid, anon_grp0.gcol2 AS responsibleculture, anon_grp0.agg0 AS expr4]}) Group(groups=[anon_grp1, anon_grp0], props={GROUP_COLS=[anon_grp1.gcol4, anon_grp1.gcol5, anon_grp1.gcol6], SYMBOL_MAP={anon_grp0.gcol0=anon_grp1.gcol4, anon_grp0.gcol1=anon_grp1.gcol5, anon_grp0.gcol2=anon_grp1.gcol6, anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.gcol2, anon_grp0.agg0]}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr, anon_grp1], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[cl.culturenumber = anon_grp1.gcol1, cl.specimennumber = anon_grp1.gcol2, cl.sampleinsertts = anon_grp1.gcol3], LEFT_EXPRESSIONS=[anon_grp1.gcol1, anon_grp1.gcol2, anon_grp1.gcol3], RIGHT_EXPRESSIONS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=null, DEPENDENT_VALUE_SOURCE=$dsc/id10697, OUTPUT_COLS=[anon_grp1.gcol4, anon_grp1.gcol5, anon_grp1.gcol6]}) Join(groups=[#tmp_admissions AS adm, anon_grp1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[anon_grp1.gcol0 = convert(adm.patientid, string)], LEFT_EXPRESSIONS=[anon_grp1.gcol0], RIGHT_EXPRESSIONS=[convert(adm.patientid, string)], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=6638.504, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}, DEPENDENT_VALUE_SOURCE=$dsc/id10698, OUTPUT_COLS=[anon_grp1.gcol1, anon_grp1.gcol2, anon_grp1.gcol3, anon_grp1.gcol4, anon_grp1.gcol5, anon_grp1.gcol6]}) Access(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l, anon_grp1], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.gcol2, anon_grp1.gcol3, anon_grp1.gcol4, anon_grp1.gcol5, anon_grp1.gcol6], CONFORMED_SOURCES=null, EST_COL_STATS={anon_grp1.gcol0=[1825.6504, -1.0], anon_grp1.gcol1=[1825.6504, -1.0], anon_grp1.gcol2=[1825.6504, -1.0], anon_grp1.gcol3=[1825.6504, -1.0], ...}, EST_CARDINALITY=5476.951}) Group(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l, anon_grp1], props={GROUP_COLS=[l.admissionid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, lc.linkcultureid, lc.responsibleculture], SYMBOL_MAP={anon_grp1.gcol0=l.admissionid, anon_grp1.gcol1=lc.culturenr, anon_grp1.gcol2=lc.culturespecimennr, anon_grp1.gcol3=lc.culturesampleinsertts, anon_grp1.gcol4=l.infectionid, anon_grp1.gcol5=lc.linkcultureid, anon_grp1.gcol6=lc.responsibleculture}, EST_CARDINALITY=5476.951, EST_COL_STATS={anon_grp1.gcol0=[1825.6504, -1.0], anon_grp1.gcol1=[1825.6504, -1.0], anon_grp1.gcol2=[1825.6504, -1.0], anon_grp1.gcol3=[1825.6504, -1.0], ...}, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.gcol2, anon_grp1.gcol3, anon_grp1.gcol4, anon_grp1.gcol5, anon_grp1.gcol6]}) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=10953.902, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, OUTPUT_COLS=[l.admissionid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, lc.linkcultureid, lc.responsibleculture]}) Source(groups=[cosara2.cos2_links AS l], props={OUTPUT_COLS=[l.id, l.admissionid, l.infectionid], EST_COL_STATS={l.id=[-1.0, -1.0], l.admissionid=[-1.0, -1.0], l.edittime=[-1.0, -1.0], l.infectionid=[-1.0, -1.0], ...}, EST_CARDINALITY=12000.0}) Source(groups=[cosara2.cos2_link_culture AS lc], props={OUTPUT_COLS=[lc.linkid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, lc.linkcultureid, lc.responsibleculture], EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, EST_CARDINALITY=10000.0}) Select(groups=[#tmp_admissions AS adm], props={SELECT_CRITERIA=convert(adm.patientid, string) IN (), IS_DEPENDENT_SET=true, OUTPUT_COLS=[adm.patientid]}) Access(groups=[#tmp_admissions AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=[adm.patientid], EST_CARDINALITY=8047.0, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}}) Source(groups=[#tmp_admissions AS adm], props={OUTPUT_COLS=[adm.patientid], EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}, EST_CARDINALITY=8047.0}) Access(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts], CONFORMED_SOURCES=null, EST_CARDINALITY=301224.2, EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}, IS_DEPENDENT_SET=true}) Select(groups=[cosara2.cos2_lab_culture AS cl], props={SELECT_CRITERIA=(cl.culturenumber IN ()) AND (cl.specimennumber IN ()) AND (cl.sampleinsertts IN ()), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts]}) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=301224.2, EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}, OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts]}) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=259235.25, EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}, OUTPUT_COLS=[cl.specimennumber, cl.culturenumber, cl.sampleinsertts]}) Source(groups=[cosara2.cos2_lab_culture AS cl], props={OUTPUT_COLS=[cl.sampleinsertts, cl.specimennumber, cl.culturenumber], EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}, EST_CARDINALITY=80000.0}) Source(groups=[cosara2.cos2_lab_sample AS ls], props={OUTPUT_COLS=[ls.inserttime, ls.specimennumber], EST_COL_STATS={ls.inserttime=[-1.0, -1.0], ls.labordernumber=[-1.0, -1.0], ls.material=[-1.0, -1.0], ls.mnemonic=[-1.0, -1.0], ...}, EST_CARDINALITY=210000.0}) Source(groups=[cosara2.cos2_antibiogramresistences AS abr], props={OUTPUT_COLS=[abr.specimennumber, abr.culturenumber, abr.sampleinsertts], EST_COL_STATS={abr.specimennumber=[-1.0, -1.0], abr.culturenumber=[-1.0, -1.0], abr.antibiogrampart=[-1.0, -1.0], abr.resisttype=[-1.0, -1.0], ...}, EST_CARDINALITY=350000.0}) ============================================================================ EXECUTING CalculateCost AFTER: Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS infectionid, anon_grp0.gcol1 AS linkcultureid, anon_grp0.gcol2 AS responsibleculture, anon_grp0.agg0 AS expr4], OUTPUT_COLS=[anon_grp0.gcol0 AS infectionid, anon_grp0.gcol1 AS linkcultureid, anon_grp0.gcol2 AS responsibleculture, anon_grp0.agg0 AS expr4], EST_CARDINALITY=1053.7462, EST_COL_STATS={anon_grp0.gcol0 AS infectionid=[351.24875, -1.0], anon_grp0.gcol1 AS linkcultureid=[351.24875, -1.0], anon_grp0.gcol2 AS responsibleculture=[351.24875, -1.0], anon_grp0.agg0 AS expr4=[351.24875, -1.0]}}) Group(groups=[anon_grp1, anon_grp0], props={GROUP_COLS=[anon_grp1.gcol4, anon_grp1.gcol5, anon_grp1.gcol6], SYMBOL_MAP={anon_grp0.gcol0=anon_grp1.gcol4, anon_grp0.gcol1=anon_grp1.gcol5, anon_grp0.gcol2=anon_grp1.gcol6, anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.gcol2, anon_grp0.agg0], EST_CARDINALITY=1053.7462, EST_COL_STATS={anon_grp0.gcol0=[351.24875, -1.0], anon_grp0.gcol1=[351.24875, -1.0], anon_grp0.gcol2=[351.24875, -1.0], anon_grp0.agg0=[351.24875, -1.0]}}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr, anon_grp1], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[cl.culturenumber = anon_grp1.gcol1, cl.specimennumber = anon_grp1.gcol2, cl.sampleinsertts = anon_grp1.gcol3], LEFT_EXPRESSIONS=[anon_grp1.gcol1, anon_grp1.gcol2, anon_grp1.gcol3], RIGHT_EXPRESSIONS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=30864.824, DEPENDENT_VALUE_SOURCE=$dsc/id10697, OUTPUT_COLS=[anon_grp1.gcol4, anon_grp1.gcol5, anon_grp1.gcol6], EST_COL_STATS={anon_grp1.gcol4=[1053.7462, -1.0], anon_grp1.gcol5=[1053.7462, -1.0], anon_grp1.gcol6=[1053.7462, -1.0]}}) Join(groups=[#tmp_admissions AS adm, anon_grp1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=MERGE, JOIN_CRITERIA=[anon_grp1.gcol0 = convert(adm.patientid, string)], LEFT_EXPRESSIONS=[anon_grp1.gcol0], RIGHT_EXPRESSIONS=[convert(adm.patientid, string)], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=3161.2388, EST_COL_STATS={anon_grp1.gcol1=[1053.7462, -1.0], anon_grp1.gcol2=[1053.7462, -1.0], anon_grp1.gcol3=[1053.7462, -1.0], anon_grp1.gcol4=[1053.7462, -1.0], ...}, DEPENDENT_VALUE_SOURCE=$dsc/id10698, OUTPUT_COLS=[anon_grp1.gcol1, anon_grp1.gcol2, anon_grp1.gcol3, anon_grp1.gcol4, anon_grp1.gcol5, anon_grp1.gcol6]}) Access(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l, anon_grp1], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.gcol2, anon_grp1.gcol3, anon_grp1.gcol4, anon_grp1.gcol5, anon_grp1.gcol6], CONFORMED_SOURCES=null, EST_COL_STATS={anon_grp1.gcol0=[1825.6504, -1.0], anon_grp1.gcol1=[1825.6504, -1.0], anon_grp1.gcol2=[1825.6504, -1.0], anon_grp1.gcol3=[1825.6504, -1.0], ...}, EST_CARDINALITY=5476.951}) Group(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l, anon_grp1], props={GROUP_COLS=[l.admissionid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, lc.linkcultureid, lc.responsibleculture], SYMBOL_MAP={anon_grp1.gcol0=l.admissionid, anon_grp1.gcol1=lc.culturenr, anon_grp1.gcol2=lc.culturespecimennr, anon_grp1.gcol3=lc.culturesampleinsertts, anon_grp1.gcol4=l.infectionid, anon_grp1.gcol5=lc.linkcultureid, anon_grp1.gcol6=lc.responsibleculture}, EST_CARDINALITY=5476.951, EST_COL_STATS={anon_grp1.gcol0=[1825.6504, -1.0], anon_grp1.gcol1=[1825.6504, -1.0], anon_grp1.gcol2=[1825.6504, -1.0], anon_grp1.gcol3=[1825.6504, -1.0], ...}, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.gcol2, anon_grp1.gcol3, anon_grp1.gcol4, anon_grp1.gcol5, anon_grp1.gcol6]}) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=10953.902, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, OUTPUT_COLS=[l.admissionid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, lc.linkcultureid, lc.responsibleculture]}) Source(groups=[cosara2.cos2_links AS l], props={OUTPUT_COLS=[l.id, l.admissionid, l.infectionid], EST_COL_STATS={l.id=[-1.0, -1.0], l.admissionid=[-1.0, -1.0], l.edittime=[-1.0, -1.0], l.infectionid=[-1.0, -1.0], ...}, EST_CARDINALITY=12000.0}) Source(groups=[cosara2.cos2_link_culture AS lc], props={OUTPUT_COLS=[lc.linkid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, lc.linkcultureid, lc.responsibleculture], EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, EST_CARDINALITY=10000.0}) Select(groups=[#tmp_admissions AS adm], props={SELECT_CRITERIA=convert(adm.patientid, string) IN (), IS_DEPENDENT_SET=true, OUTPUT_COLS=[adm.patientid], EST_CARDINALITY=1825.6504, EST_COL_STATS={adm.patientid=[-1.0, -1.0]}}) Access(groups=[#tmp_admissions AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=[adm.patientid], EST_CARDINALITY=8047.0, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}}) Source(groups=[#tmp_admissions AS adm], props={OUTPUT_COLS=[adm.patientid], EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}, EST_CARDINALITY=8047.0}) Access(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts], CONFORMED_SOURCES=null, EST_CARDINALITY=301224.2, EST_COL_STATS={cl.culturenumber=[-1.0, -1.0], cl.specimennumber=[-1.0, -1.0], cl.sampleinsertts=[-1.0, -1.0]}, IS_DEPENDENT_SET=true}) Select(groups=[cosara2.cos2_lab_culture AS cl], props={SELECT_CRITERIA=(cl.culturenumber IN ()) AND (cl.specimennumber IN ()) AND (cl.sampleinsertts IN ()), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts], EST_CARDINALITY=301224.2, EST_COL_STATS={cl.culturenumber=[-1.0, -1.0], cl.specimennumber=[-1.0, -1.0], cl.sampleinsertts=[-1.0, -1.0]}}) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=301224.2, EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}, OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts]}) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=259235.25, EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}, OUTPUT_COLS=[cl.specimennumber, cl.culturenumber, cl.sampleinsertts]}) Source(groups=[cosara2.cos2_lab_culture AS cl], props={OUTPUT_COLS=[cl.sampleinsertts, cl.specimennumber, cl.culturenumber], EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}, EST_CARDINALITY=80000.0}) Source(groups=[cosara2.cos2_lab_sample AS ls], props={OUTPUT_COLS=[ls.inserttime, ls.specimennumber], EST_COL_STATS={ls.inserttime=[-1.0, -1.0], ls.labordernumber=[-1.0, -1.0], ls.material=[-1.0, -1.0], ls.mnemonic=[-1.0, -1.0], ...}, EST_CARDINALITY=210000.0}) Source(groups=[cosara2.cos2_antibiogramresistences AS abr], props={OUTPUT_COLS=[abr.specimennumber, abr.culturenumber, abr.sampleinsertts], EST_COL_STATS={abr.specimennumber=[-1.0, -1.0], abr.culturenumber=[-1.0, -1.0], abr.antibiogrampart=[-1.0, -1.0], abr.resisttype=[-1.0, -1.0], ...}, EST_CARDINALITY=350000.0}) ============================================================================ EXECUTING ImplementJoinStrategy AFTER: Project(groups=[anon_grp0]) Group(groups=[anon_grp1, anon_grp0]) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr, anon_grp1], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=ENHANCED_SORT, JOIN_CRITERIA=[cl.culturenumber = anon_grp1.gcol1, cl.specimennumber = anon_grp1.gcol2, cl.sampleinsertts = anon_grp1.gcol3], LEFT_EXPRESSIONS=[anon_grp1.gcol1, anon_grp1.gcol2, anon_grp1.gcol3], RIGHT_EXPRESSIONS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=30864.824, DEPENDENT_VALUE_SOURCE=$dsc/id10697, OUTPUT_COLS=[anon_grp1.gcol4, anon_grp1.gcol5, anon_grp1.gcol6], EST_COL_STATS={anon_grp1.gcol4=[1053.7462, -1.0], anon_grp1.gcol5=[1053.7462, -1.0], anon_grp1.gcol6=[1053.7462, -1.0]}, SORT_LEFT=SORT}) Join(groups=[#tmp_admissions AS adm, anon_grp1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=ENHANCED_SORT, JOIN_CRITERIA=[anon_grp1.gcol0 = convert(adm.patientid, string)], LEFT_EXPRESSIONS=[anon_grp1.gcol0], RIGHT_EXPRESSIONS=[convert(adm.patientid, string)], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=3161.2388, EST_COL_STATS={anon_grp1.gcol1=[1053.7462, -1.0], anon_grp1.gcol2=[1053.7462, -1.0], anon_grp1.gcol3=[1053.7462, -1.0], anon_grp1.gcol4=[1053.7462, -1.0], ...}, DEPENDENT_VALUE_SOURCE=$dsc/id10698, OUTPUT_COLS=[anon_grp1.gcol1, anon_grp1.gcol2, anon_grp1.gcol3, anon_grp1.gcol4, anon_grp1.gcol5, anon_grp1.gcol6], SORT_RIGHT=SORT}) Access(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l, anon_grp1], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.gcol2, anon_grp1.gcol3, anon_grp1.gcol4, anon_grp1.gcol5, anon_grp1.gcol6], CONFORMED_SOURCES=null, EST_COL_STATS={anon_grp1.gcol0=[1825.6504, -1.0], anon_grp1.gcol1=[1825.6504, -1.0], anon_grp1.gcol2=[1825.6504, -1.0], anon_grp1.gcol3=[1825.6504, -1.0], ...}, EST_CARDINALITY=5476.951}) Sort(groups=[], props={SORT_ORDER=ORDER BY anon_grp1.gcol0, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.gcol2, anon_grp1.gcol3, anon_grp1.gcol4, anon_grp1.gcol5, anon_grp1.gcol6]}) Group(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l, anon_grp1], props={GROUP_COLS=[l.admissionid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, lc.linkcultureid, lc.responsibleculture], SYMBOL_MAP={anon_grp1.gcol0=l.admissionid, anon_grp1.gcol1=lc.culturenr, anon_grp1.gcol2=lc.culturespecimennr, anon_grp1.gcol3=lc.culturesampleinsertts, anon_grp1.gcol4=l.infectionid, anon_grp1.gcol5=lc.linkcultureid, anon_grp1.gcol6=lc.responsibleculture}, EST_CARDINALITY=5476.951, EST_COL_STATS={anon_grp1.gcol0=[1825.6504, -1.0], anon_grp1.gcol1=[1825.6504, -1.0], anon_grp1.gcol2=[1825.6504, -1.0], anon_grp1.gcol3=[1825.6504, -1.0], ...}, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.gcol2, anon_grp1.gcol3, anon_grp1.gcol4, anon_grp1.gcol5, anon_grp1.gcol6]}) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[lc.linkid = l.id], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=10953.902, EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, OUTPUT_COLS=[l.admissionid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, lc.linkcultureid, lc.responsibleculture]}) Source(groups=[cosara2.cos2_links AS l], props={OUTPUT_COLS=[l.id, l.admissionid, l.infectionid], EST_COL_STATS={l.id=[-1.0, -1.0], l.admissionid=[-1.0, -1.0], l.edittime=[-1.0, -1.0], l.infectionid=[-1.0, -1.0], ...}, EST_CARDINALITY=12000.0}) Source(groups=[cosara2.cos2_link_culture AS lc], props={OUTPUT_COLS=[lc.linkid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, lc.linkcultureid, lc.responsibleculture], EST_COL_STATS={lc.culturenr=[-1.0, -1.0], lc.culturespecimennr=[-1.0, -1.0], lc.linkid=[-1.0, -1.0], lc.responsibleculture=[-1.0, -1.0], ...}, EST_CARDINALITY=10000.0}) Select(groups=[#tmp_admissions AS adm], props={SELECT_CRITERIA=convert(adm.patientid, string) IN (), IS_DEPENDENT_SET=true, OUTPUT_COLS=[adm.patientid, convert(adm.patientid, string)], EST_CARDINALITY=1825.6504, EST_COL_STATS={adm.patientid=[-1.0, -1.0]}}) Project(groups=[], props={PROJECT_COLS=[adm.patientid, convert(adm.patientid, string)], OUTPUT_COLS=[adm.patientid, convert(adm.patientid, string)]}) Access(groups=[#tmp_admissions AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=[adm.patientid], EST_CARDINALITY=8047.0, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}}) Source(groups=[#tmp_admissions AS adm], props={OUTPUT_COLS=[adm.patientid], EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}, EST_CARDINALITY=8047.0}) Access(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts], CONFORMED_SOURCES=null, EST_CARDINALITY=301224.2, EST_COL_STATS={cl.culturenumber=[-1.0, -1.0], cl.specimennumber=[-1.0, -1.0], cl.sampleinsertts=[-1.0, -1.0]}, IS_DEPENDENT_SET=true}) Sort(groups=[], props={SORT_ORDER=ORDER BY cl.culturenumber, cl.specimennumber, cl.sampleinsertts, OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts]}) Select(groups=[cosara2.cos2_lab_culture AS cl], props={SELECT_CRITERIA=(cl.culturenumber IN ()) AND (cl.specimennumber IN ()) AND (cl.sampleinsertts IN ()), IS_DEPENDENT_SET=true, IS_PUSHED=true, OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts], EST_CARDINALITY=301224.2, EST_COL_STATS={cl.culturenumber=[-1.0, -1.0], cl.specimennumber=[-1.0, -1.0], cl.sampleinsertts=[-1.0, -1.0]}}) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[abr.specimennumber = cl.specimennumber, abr.culturenumber = cl.culturenumber, abr.sampleinsertts = cl.sampleinsertts], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=301224.2, EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}, OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts]}) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[ls.inserttime = cl.sampleinsertts, ls.specimennumber = cl.specimennumber], MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, EST_CARDINALITY=259235.25, EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}, OUTPUT_COLS=[cl.specimennumber, cl.culturenumber, cl.sampleinsertts]}) Source(groups=[cosara2.cos2_lab_culture AS cl], props={OUTPUT_COLS=[cl.sampleinsertts, cl.specimennumber, cl.culturenumber], EST_COL_STATS={cl.specimennumber=[-1.0, -1.0], cl.culturenumber=[-1.0, -1.0], cl.culturename=[-1.0, -1.0], cl.culturefamily=[-1.0, -1.0], ...}, EST_CARDINALITY=80000.0}) Source(groups=[cosara2.cos2_lab_sample AS ls], props={OUTPUT_COLS=[ls.inserttime, ls.specimennumber], EST_COL_STATS={ls.inserttime=[-1.0, -1.0], ls.labordernumber=[-1.0, -1.0], ls.material=[-1.0, -1.0], ls.mnemonic=[-1.0, -1.0], ...}, EST_CARDINALITY=210000.0}) Source(groups=[cosara2.cos2_antibiogramresistences AS abr], props={OUTPUT_COLS=[abr.specimennumber, abr.culturenumber, abr.sampleinsertts], EST_COL_STATS={abr.specimennumber=[-1.0, -1.0], abr.culturenumber=[-1.0, -1.0], abr.antibiogrampart=[-1.0, -1.0], abr.resisttype=[-1.0, -1.0], ...}, EST_CARDINALITY=350000.0}) ============================================================================ EXECUTING MergeCriteria AFTER: Project(groups=[anon_grp0]) Group(groups=[anon_grp1, anon_grp0]) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr, anon_grp1]) Join(groups=[#tmp_admissions AS adm, anon_grp1]) Access(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l, anon_grp1]) Sort(groups=[]) Group(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l, anon_grp1]) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_link_culture AS lc]) Select(groups=[#tmp_admissions AS adm], props={SELECT_CRITERIA=convert(adm.patientid, string) IN (), IS_DEPENDENT_SET=true, OUTPUT_COLS=[adm.patientid, convert(adm.patientid, string)], EST_CARDINALITY=null, EST_COL_STATS={adm.patientid=[-1.0, -1.0]}}) Project(groups=[], props={PROJECT_COLS=[adm.patientid, convert(adm.patientid, string)], OUTPUT_COLS=[adm.patientid, convert(adm.patientid, string)], EST_CARDINALITY=8047.0, EST_COL_STATS={adm.patientid=[-1.0, -1.0], convert(adm.patientid, string)=[-1.0, -1.0]}}) Access(groups=[#tmp_admissions AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=[adm.patientid], EST_CARDINALITY=8047.0, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}}) Source(groups=[#tmp_admissions AS adm], props={OUTPUT_COLS=[adm.patientid], EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}, EST_CARDINALITY=8047.0}) Access(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Sort(groups=[]) Select(groups=[cosara2.cos2_lab_culture AS cl]) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING PlanSorts AFTER: Project(groups=[anon_grp0]) Group(groups=[anon_grp1, anon_grp0], props={GROUP_COLS=[anon_grp1.gcol4, anon_grp1.gcol5, anon_grp1.gcol6], SYMBOL_MAP={anon_grp0.gcol0=anon_grp1.gcol4, anon_grp0.gcol1=anon_grp1.gcol5, anon_grp0.gcol2=anon_grp1.gcol6, anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.gcol2, anon_grp0.agg0], EST_CARDINALITY=1053.7462, EST_COL_STATS={anon_grp0.gcol0=[351.24875, -1.0], anon_grp0.gcol1=[351.24875, -1.0], anon_grp0.gcol2=[351.24875, -1.0], anon_grp0.agg0=[351.24875, -1.0]}}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr, anon_grp1], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=ENHANCED_SORT, JOIN_CRITERIA=[cl.culturenumber = anon_grp1.gcol1, cl.specimennumber = anon_grp1.gcol2, cl.sampleinsertts = anon_grp1.gcol3], LEFT_EXPRESSIONS=[anon_grp1.gcol1, anon_grp1.gcol2, anon_grp1.gcol3], RIGHT_EXPRESSIONS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=30864.824, DEPENDENT_VALUE_SOURCE=$dsc/id10697, OUTPUT_COLS=[anon_grp1.gcol4, anon_grp1.gcol5, anon_grp1.gcol6], EST_COL_STATS={anon_grp1.gcol4=[1053.7462, -1.0], anon_grp1.gcol5=[1053.7462, -1.0], anon_grp1.gcol6=[1053.7462, -1.0]}, SORT_LEFT=SORT}) Join(groups=[#tmp_admissions AS adm, anon_grp1], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=ENHANCED_SORT, JOIN_CRITERIA=[anon_grp1.gcol0 = convert(adm.patientid, string)], LEFT_EXPRESSIONS=[anon_grp1.gcol0], RIGHT_EXPRESSIONS=[convert(adm.patientid, string)], NON_EQUI_JOIN_CRITERIA=[], EST_CARDINALITY=3161.2388, EST_COL_STATS={anon_grp1.gcol1=[1053.7462, -1.0], anon_grp1.gcol2=[1053.7462, -1.0], anon_grp1.gcol3=[1053.7462, -1.0], anon_grp1.gcol4=[1053.7462, -1.0], ...}, DEPENDENT_VALUE_SOURCE=$dsc/id10698, OUTPUT_COLS=[anon_grp1.gcol1, anon_grp1.gcol2, anon_grp1.gcol3, anon_grp1.gcol4, anon_grp1.gcol5, anon_grp1.gcol6], SORT_RIGHT=SORT}) Access(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l, anon_grp1]) Sort(groups=[]) Group(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l, anon_grp1]) Join(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_links AS l]) Source(groups=[cosara2.cos2_link_culture AS lc]) Select(groups=[#tmp_admissions AS adm]) Project(groups=[]) Access(groups=[#tmp_admissions AS adm]) Source(groups=[#tmp_admissions AS adm]) Access(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Sort(groups=[]) Select(groups=[cosara2.cos2_lab_culture AS cl]) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr]) Join(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_lab_culture AS cl]) Source(groups=[cosara2.cos2_lab_sample AS ls]) Source(groups=[cosara2.cos2_antibiogramresistences AS abr]) ============================================================================ EXECUTING CollapseSource AFTER: Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.gcol0 AS infectionid, anon_grp0.gcol1 AS linkcultureid, anon_grp0.gcol2 AS responsibleculture, anon_grp0.agg0 AS expr4], OUTPUT_COLS=[anon_grp0.gcol0 AS infectionid, anon_grp0.gcol1 AS linkcultureid, anon_grp0.gcol2 AS responsibleculture, anon_grp0.agg0 AS expr4], EST_CARDINALITY=1053.7462, EST_COL_STATS={anon_grp0.gcol0 AS infectionid=[351.24875, -1.0], anon_grp0.gcol1 AS linkcultureid=[351.24875, -1.0], anon_grp0.gcol2 AS responsibleculture=[351.24875, -1.0], anon_grp0.agg0 AS expr4=[351.24875, -1.0]}}) Group(groups=[anon_grp1, anon_grp0], props={GROUP_COLS=[anon_grp1.gcol4, anon_grp1.gcol5, anon_grp1.gcol6], SYMBOL_MAP={anon_grp0.gcol0=anon_grp1.gcol4, anon_grp0.gcol1=anon_grp1.gcol5, anon_grp0.gcol2=anon_grp1.gcol6, anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.gcol2, anon_grp0.agg0], EST_CARDINALITY=1053.7462, EST_COL_STATS={anon_grp0.gcol0=[351.24875, -1.0], anon_grp0.gcol1=[351.24875, -1.0], anon_grp0.gcol2=[351.24875, -1.0], anon_grp0.agg0=[351.24875, -1.0]}}) Join(groups=[#tmp_admissions AS adm, cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr, anon_grp1]) Join(groups=[#tmp_admissions AS adm, anon_grp1]) Access(groups=[cosara2.cos2_link_culture AS lc, cosara2.cos2_links AS l, anon_grp1], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.gcol2, anon_grp1.gcol3, anon_grp1.gcol4, anon_grp1.gcol5, anon_grp1.gcol6], CONFORMED_SOURCES=null, EST_COL_STATS={anon_grp1.gcol0=[1825.6504, -1.0], anon_grp1.gcol1=[1825.6504, -1.0], anon_grp1.gcol2=[1825.6504, -1.0], anon_grp1.gcol3=[1825.6504, -1.0], ...}, EST_CARDINALITY=5476.951, ATOMIC_REQUEST=SELECT l.admissionid AS gcol0, lc.culturenr AS gcol1, lc.culturespecimennr AS gcol2, lc.culturesampleinsertts AS gcol3, l.infectionid AS gcol4, lc.linkcultureid AS gcol5, lc.responsibleculture AS gcol6 FROM cosara2.cos2_links AS l, cosara2.cos2_link_culture AS lc WHERE lc.linkid = l.id GROUP BY l.admissionid, lc.culturenr, lc.culturespecimennr, lc.culturesampleinsertts, l.infectionid, lc.linkcultureid, lc.responsibleculture ORDER BY gcol0}) Select(groups=[#tmp_admissions AS adm]) Project(groups=[], props={PROJECT_COLS=[adm.patientid, convert(adm.patientid, string)], OUTPUT_COLS=[adm.patientid, convert(adm.patientid, string)], EST_CARDINALITY=8047.0, EST_COL_STATS={adm.patientid=[-1.0, -1.0], convert(adm.patientid, string)=[-1.0, -1.0]}}) Access(groups=[#tmp_admissions AS adm], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=[adm.patientid], EST_CARDINALITY=8047.0, EST_COL_STATS={adm.patientid=[-1.0, -1.0], adm.adrema=[-1.0, -1.0], adm.episode=[-1.0, -1.0], adm.iz_admtime=[-1.0, -1.0], ...}, ATOMIC_REQUEST=SELECT adm.patientid FROM #tmp_admissions AS adm}) Access(groups=[cosara2.cos2_lab_culture AS cl, cosara2.cos2_lab_sample AS ls, cosara2.cos2_antibiogramresistences AS abr], props={SOURCE_HINT=null, MODEL_ID=Schema name=cosara2, nameInSource=null, uuid=mmuuid:6a1b4f23-74e1-4293-9cc4-17612bf7e896, OUTPUT_COLS=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts], CONFORMED_SOURCES=null, EST_CARDINALITY=301224.2, EST_COL_STATS={cl.culturenumber=[-1.0, -1.0], cl.specimennumber=[-1.0, -1.0], cl.sampleinsertts=[-1.0, -1.0]}, IS_DEPENDENT_SET=true, ATOMIC_REQUEST=SELECT cl.culturenumber, cl.specimennumber, cl.sampleinsertts FROM (cosara2.cos2_lab_culture AS cl LEFT OUTER JOIN cosara2.cos2_lab_sample AS ls ON ls.inserttime = cl.sampleinsertts AND ls.specimennumber = cl.specimennumber) LEFT OUTER JOIN cosara2.cos2_antibiogramresistences AS abr ON abr.specimennumber = cl.specimennumber AND abr.culturenumber = cl.culturenumber AND abr.sampleinsertts = cl.sampleinsertts WHERE (cl.culturenumber IN ()) AND (cl.specimennumber IN ()) AND (cl.sampleinsertts IN ()) ORDER BY cl.culturenumber, cl.specimennumber, cl.sampleinsertts}) ============================================================================ CONVERTING PLAN TREE TO PROCESS TREE PROCESS PLAN = ProjectNode(2) output=[anon_grp0.gcol0 AS infectionid, anon_grp0.gcol1 AS linkcultureid, anon_grp0.gcol2 AS responsibleculture, anon_grp0.agg0 AS expr4] [anon_grp0.gcol0 AS infectionid, anon_grp0.gcol1 AS linkcultureid, anon_grp0.gcol2 AS responsibleculture, anon_grp0.agg0 AS expr4] GroupingNode(3) output=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.gcol2, anon_grp0.agg0] [anon_grp1.gcol4, anon_grp1.gcol5, anon_grp1.gcol6]{anon_grp0.gcol0=anon_grp1.gcol4, anon_grp0.gcol1=anon_grp1.gcol5, anon_grp0.gcol2=anon_grp1.gcol6, anon_grp0.agg0=COUNT(*)} JoinNode(4) [Dependent] [ENHANCED SORT JOIN (SORT/ALREADY_SORTED)] [LEFT OUTER JOIN] criteria=[anon_grp1.gcol1=cl.culturenumber, anon_grp1.gcol2=cl.specimennumber, anon_grp1.gcol3=cl.sampleinsertts] output=[anon_grp1.gcol4, anon_grp1.gcol5, anon_grp1.gcol6] JoinNode(5) [Dependent] [ENHANCED SORT JOIN (ALREADY_SORTED/SORT)] [INNER JOIN] criteria=[anon_grp1.gcol0=convert(adm.patientid, string)] output=[anon_grp1.gcol1, anon_grp1.gcol2, anon_grp1.gcol3, anon_grp1.gcol4, anon_grp1.gcol5, anon_grp1.gcol6] AccessNode(6) output=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.gcol2, anon_grp1.gcol3, anon_grp1.gcol4, anon_grp1.gcol5, anon_grp1.gcol6] SELECT g_0.admissionid AS c_0, g_1.culturenr AS c_1, g_1.culturespecimennr AS c_2, g_1.culturesampleinsertts AS c_3, g_0.infectionid AS c_4, g_1.linkcultureid AS c_5, g_1.responsibleculture AS c_6 FROM cosara2.cos2_links AS g_0, cosara2.cos2_link_culture AS g_1 WHERE g_1.linkid = g_0.id GROUP BY g_0.admissionid, g_1.culturenr, g_1.culturespecimennr, g_1.culturesampleinsertts, g_0.infectionid, g_1.linkcultureid, g_1.responsibleculture ORDER BY c_0 SelectNode(7) output=[adm.patientid, convert(adm.patientid, string)] convert(adm.patientid, string) IN () ProjectNode(8) output=[adm.patientid, convert(adm.patientid, string)] [adm.patientid, convert(adm.patientid, string)] AccessNode(9) output=[adm.patientid] SELECT #tmp_admissions.patientid FROM #tmp_admissions DependentAccessNode(10) output=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts] SELECT g_0.culturenumber AS c_0, g_0.specimennumber AS c_1, g_0.sampleinsertts AS c_2 FROM (cosara2.cos2_lab_culture AS g_0 LEFT OUTER JOIN cosara2.cos2_lab_sample AS g_1 ON g_1.inserttime = g_0.sampleinsertts AND g_1.specimennumber = g_0.specimennumber) LEFT OUTER JOIN cosara2.cos2_antibiogramresistences AS g_2 ON g_2.specimennumber = g_0.specimennumber AND g_2.culturenumber = g_0.culturenumber AND g_2.sampleinsertts = g_0.sampleinsertts WHERE (g_0.culturenumber IN ()) AND (g_0.specimennumber IN ()) AND (g_0.sampleinsertts IN ()) ORDER BY c_0, c_1, c_2 ============================================================================ ---------------------------------------------------------------------------- OPTIMIZATION COMPLETE: PROCESSOR PLAN: ProjectNode(2) output=[anon_grp0.gcol0 AS infectionid, anon_grp0.gcol1 AS linkcultureid, anon_grp0.gcol2 AS responsibleculture, anon_grp0.agg0 AS expr4] [anon_grp0.gcol0 AS infectionid, anon_grp0.gcol1 AS linkcultureid, anon_grp0.gcol2 AS responsibleculture, anon_grp0.agg0 AS expr4] GroupingNode(3) output=[anon_grp0.gcol0, anon_grp0.gcol1, anon_grp0.gcol2, anon_grp0.agg0] [anon_grp1.gcol4, anon_grp1.gcol5, anon_grp1.gcol6]{anon_grp0.gcol0=anon_grp1.gcol4, anon_grp0.gcol1=anon_grp1.gcol5, anon_grp0.gcol2=anon_grp1.gcol6, anon_grp0.agg0=COUNT(*)} JoinNode(4) [Dependent] [ENHANCED SORT JOIN (SORT/ALREADY_SORTED)] [LEFT OUTER JOIN] criteria=[anon_grp1.gcol1=cl.culturenumber, anon_grp1.gcol2=cl.specimennumber, anon_grp1.gcol3=cl.sampleinsertts] output=[anon_grp1.gcol4, anon_grp1.gcol5, anon_grp1.gcol6] JoinNode(5) [Dependent] [ENHANCED SORT JOIN (ALREADY_SORTED/SORT)] [INNER JOIN] criteria=[anon_grp1.gcol0=convert(adm.patientid, string)] output=[anon_grp1.gcol1, anon_grp1.gcol2, anon_grp1.gcol3, anon_grp1.gcol4, anon_grp1.gcol5, anon_grp1.gcol6] AccessNode(6) output=[anon_grp1.gcol0, anon_grp1.gcol1, anon_grp1.gcol2, anon_grp1.gcol3, anon_grp1.gcol4, anon_grp1.gcol5, anon_grp1.gcol6] SELECT g_0.admissionid AS c_0, g_1.culturenr AS c_1, g_1.culturespecimennr AS c_2, g_1.culturesampleinsertts AS c_3, g_0.infectionid AS c_4, g_1.linkcultureid AS c_5, g_1.responsibleculture AS c_6 FROM cosara2.cos2_links AS g_0, cosara2.cos2_link_culture AS g_1 WHERE g_1.linkid = g_0.id GROUP BY g_0.admissionid, g_1.culturenr, g_1.culturespecimennr, g_1.culturesampleinsertts, g_0.infectionid, g_1.linkcultureid, g_1.responsibleculture ORDER BY c_0 SelectNode(7) output=[adm.patientid, convert(adm.patientid, string)] convert(adm.patientid, string) IN () ProjectNode(8) output=[adm.patientid, convert(adm.patientid, string)] [adm.patientid, convert(adm.patientid, string)] AccessNode(9) output=[adm.patientid] SELECT #tmp_admissions.patientid FROM #tmp_admissions DependentAccessNode(10) output=[cl.culturenumber, cl.specimennumber, cl.sampleinsertts] SELECT g_0.culturenumber AS c_0, g_0.specimennumber AS c_1, g_0.sampleinsertts AS c_2 FROM (cosara2.cos2_lab_culture AS g_0 LEFT OUTER JOIN cosara2.cos2_lab_sample AS g_1 ON g_1.inserttime = g_0.sampleinsertts AND g_1.specimennumber = g_0.specimennumber) LEFT OUTER JOIN cosara2.cos2_antibiogramresistences AS g_2 ON g_2.specimennumber = g_0.specimennumber AND g_2.culturenumber = g_0.culturenumber AND g_2.sampleinsertts = g_0.sampleinsertts WHERE (g_0.culturenumber IN ()) AND (g_0.specimennumber IN ()) AND (g_0.sampleinsertts IN ()) ORDER BY c_0, c_1, c_2 ============================================================================