*********************************************** 06 Jan 2012 19:55:33,792 CST INFO [org.teiid.PLANNER] (Worker67_QueryProcessorQueue4250) ============================================================================ USER COMMAND: SELECT T.ROLE_NAME AS ROLE_NAME, T.SCHEMA_NAME AS SCHEMA_NAME, T.INSTALL_STATUS AS INSTALL_STATUS FROM (SELECT ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM demodata_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM security_cia_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM vantage_chorus_metadata.chorus_role) AS T, chorus_license.RL_LICENSE AS L WHERE (T.ROLE_NAME = L.ROLE_NAME) AND (T.install_status = TRUE) ---------------------------------------------------------------------------- OPTIMIZE: SELECT T.ROLE_NAME AS ROLE_NAME, T.SCHEMA_NAME AS SCHEMA_NAME, T.INSTALL_STATUS AS INSTALL_STATUS FROM (SELECT ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM demodata_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM security_cia_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM vantage_chorus_metadata.chorus_role) AS T, chorus_license.RL_LICENSE AS L WHERE (T.ROLE_NAME = L.ROLE_NAME) AND (T.install_status = TRUE) ---------------------------------------------------------------------------- GENERATE CANONICAL: SELECT T.ROLE_NAME AS ROLE_NAME, T.SCHEMA_NAME AS SCHEMA_NAME, T.INSTALL_STATUS AS INSTALL_STATUS FROM (SELECT ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM demodata_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM security_cia_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM vantage_chorus_metadata.chorus_role) AS T, chorus_license.RL_LICENSE AS L WHERE (T.ROLE_NAME = L.ROLE_NAME) AND (T.install_status = TRUE) CANONICAL PLAN: Project(groups=[T], props={PROJECT_COLS=[T.ROLE_NAME AS ROLE_NAME, T.SCHEMA_NAME AS SCHEMA_NAME, T.INSTALL_STATUS AS INSTALL_STATUS]}) Select(groups=[T], props={SELECT_CRITERIA=T.install_status = TRUE}) Select(groups=[T, chorus_license.RL_LICENSE AS L], props={SELECT_CRITERIA=T.ROLE_NAME = L.ROLE_NAME}) Join(groups=[T, chorus_license.RL_LICENSE AS L], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[]}) Source(groups=[T], props={NESTED_COMMAND=SELECT ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM demodata_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM security_cia_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM vantage_chorus_metadata.chorus_role, SYMBOL_MAP={T.ROLE_NAME=ROLE_NAME, T.SCHEMA_NAME='demodata_chorus_metadata', T.INSTALL_STATUS=INSTALL_STATUS}}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) Project(groups=[demodata_chorus_metadata.chorus_role], props={PROJECT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Source(groups=[demodata_chorus_metadata.chorus_role]) Project(groups=[security_cia_chorus_metadata.chorus_role], props={PROJECT_COLS=[ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Source(groups=[security_cia_chorus_metadata.chorus_role]) Project(groups=[vantage_chorus_metadata.chorus_role], props={PROJECT_COLS=[ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Source(groups=[vantage_chorus_metadata.chorus_role]) Source(groups=[chorus_license.RL_LICENSE AS L]) ============================================================================ EXECUTING PlaceAccess AFTER: Project(groups=[T], props={PROJECT_COLS=[T.ROLE_NAME AS ROLE_NAME, T.SCHEMA_NAME AS SCHEMA_NAME, T.INSTALL_STATUS AS INSTALL_STATUS]}) Select(groups=[T], props={SELECT_CRITERIA=T.install_status = TRUE}) Select(groups=[T, chorus_license.RL_LICENSE AS L], props={SELECT_CRITERIA=T.ROLE_NAME = L.ROLE_NAME}) Join(groups=[T, chorus_license.RL_LICENSE AS L], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[]}) Source(groups=[T], props={NESTED_COMMAND=SELECT ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM demodata_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM security_cia_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM vantage_chorus_metadata.chorus_role, SYMBOL_MAP={T.ROLE_NAME=ROLE_NAME, T.SCHEMA_NAME='demodata_chorus_metadata', T.INSTALL_STATUS=INSTALL_STATUS}}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) Project(groups=[demodata_chorus_metadata.chorus_role], props={PROJECT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Access(groups=[demodata_chorus_metadata.chorus_role]) Source(groups=[demodata_chorus_metadata.chorus_role]) Project(groups=[security_cia_chorus_metadata.chorus_role], props={PROJECT_COLS=[ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Access(groups=[security_cia_chorus_metadata.chorus_role]) Source(groups=[security_cia_chorus_metadata.chorus_role]) Project(groups=[vantage_chorus_metadata.chorus_role], props={PROJECT_COLS=[ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Access(groups=[vantage_chorus_metadata.chorus_role]) Source(groups=[vantage_chorus_metadata.chorus_role]) Access(groups=[chorus_license.RL_LICENSE AS L]) Source(groups=[chorus_license.RL_LICENSE AS L]) ============================================================================ EXECUTING AssignOutputElements AFTER: Project(groups=[T], props={PROJECT_COLS=[T.ROLE_NAME AS ROLE_NAME, T.SCHEMA_NAME AS SCHEMA_NAME, T.INSTALL_STATUS AS INSTALL_STATUS], OUTPUT_COLS=[T.ROLE_NAME AS ROLE_NAME, T.SCHEMA_NAME AS SCHEMA_NAME, T.INSTALL_STATUS AS INSTALL_STATUS]}) Select(groups=[T], props={SELECT_CRITERIA=T.install_status = TRUE, OUTPUT_COLS=[T.ROLE_NAME, T.SCHEMA_NAME, T.INSTALL_STATUS]}) Select(groups=[T, chorus_license.RL_LICENSE AS L], props={SELECT_CRITERIA=T.ROLE_NAME = L.ROLE_NAME, OUTPUT_COLS=[T.install_status, T.ROLE_NAME, T.SCHEMA_NAME]}) Join(groups=[T, chorus_license.RL_LICENSE AS L], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=[T.ROLE_NAME, L.ROLE_NAME, T.install_status, T.SCHEMA_NAME]}) Source(groups=[T], props={NESTED_COMMAND=SELECT ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM demodata_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM security_cia_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM vantage_chorus_metadata.chorus_role, SYMBOL_MAP={T.ROLE_NAME=ROLE_NAME, T.SCHEMA_NAME='demodata_chorus_metadata', T.INSTALL_STATUS=INSTALL_STATUS}, OUTPUT_COLS=[T.ROLE_NAME, T.SCHEMA_NAME, T.INSTALL_STATUS]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Project(groups=[demodata_chorus_metadata.chorus_role], props={PROJECT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS], OUTPUT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Access(groups=[demodata_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Source(groups=[demodata_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Project(groups=[security_cia_chorus_metadata.chorus_role], props={PROJECT_COLS=[ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS], OUTPUT_COLS=[ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Access(groups=[security_cia_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Source(groups=[security_cia_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Project(groups=[vantage_chorus_metadata.chorus_role], props={PROJECT_COLS=[ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS], OUTPUT_COLS=[ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Access(groups=[vantage_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Source(groups=[vantage_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Access(groups=[chorus_license.RL_LICENSE AS L], props={OUTPUT_COLS=[L.ROLE_NAME]}) Source(groups=[chorus_license.RL_LICENSE AS L], props={OUTPUT_COLS=[L.ROLE_NAME]}) ============================================================================ EXECUTING MergeVirtual AFTER: Project(groups=[T], props={PROJECT_COLS=[T.ROLE_NAME AS ROLE_NAME, T.SCHEMA_NAME AS SCHEMA_NAME, T.INSTALL_STATUS AS INSTALL_STATUS], OUTPUT_COLS=[T.ROLE_NAME AS ROLE_NAME, T.SCHEMA_NAME AS SCHEMA_NAME, T.INSTALL_STATUS AS INSTALL_STATUS]}) Select(groups=[T], props={SELECT_CRITERIA=T.install_status = TRUE, OUTPUT_COLS=[T.ROLE_NAME, T.SCHEMA_NAME, T.INSTALL_STATUS]}) Select(groups=[T, chorus_license.RL_LICENSE AS L], props={SELECT_CRITERIA=T.ROLE_NAME = L.ROLE_NAME, OUTPUT_COLS=[T.install_status, T.ROLE_NAME, T.SCHEMA_NAME]}) Join(groups=[T, chorus_license.RL_LICENSE AS L], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=[T.ROLE_NAME, L.ROLE_NAME, T.install_status, T.SCHEMA_NAME]}) Source(groups=[T], props={NESTED_COMMAND=SELECT ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM demodata_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM security_cia_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM vantage_chorus_metadata.chorus_role, SYMBOL_MAP={T.ROLE_NAME=ROLE_NAME, T.SCHEMA_NAME='demodata_chorus_metadata', T.INSTALL_STATUS=INSTALL_STATUS}, OUTPUT_COLS=[T.ROLE_NAME, T.SCHEMA_NAME, T.INSTALL_STATUS]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Project(groups=[demodata_chorus_metadata.chorus_role], props={PROJECT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS], OUTPUT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Access(groups=[demodata_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Source(groups=[demodata_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Project(groups=[security_cia_chorus_metadata.chorus_role], props={PROJECT_COLS=[ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS], OUTPUT_COLS=[ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Access(groups=[security_cia_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Source(groups=[security_cia_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Project(groups=[vantage_chorus_metadata.chorus_role], props={PROJECT_COLS=[ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS], OUTPUT_COLS=[ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Access(groups=[vantage_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Source(groups=[vantage_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Access(groups=[chorus_license.RL_LICENSE AS L], props={OUTPUT_COLS=[L.ROLE_NAME]}) Source(groups=[chorus_license.RL_LICENSE AS L], props={OUTPUT_COLS=[L.ROLE_NAME]}) ============================================================================ EXECUTING DecomposeJoin AFTER: Project(groups=[T], props={PROJECT_COLS=[T.ROLE_NAME AS ROLE_NAME, T.SCHEMA_NAME AS SCHEMA_NAME, T.INSTALL_STATUS AS INSTALL_STATUS], OUTPUT_COLS=[T.ROLE_NAME AS ROLE_NAME, T.SCHEMA_NAME AS SCHEMA_NAME, T.INSTALL_STATUS AS INSTALL_STATUS]}) Select(groups=[T], props={SELECT_CRITERIA=T.install_status = TRUE, OUTPUT_COLS=[T.ROLE_NAME, T.SCHEMA_NAME, T.INSTALL_STATUS]}) Select(groups=[T, chorus_license.RL_LICENSE AS L], props={SELECT_CRITERIA=T.ROLE_NAME = L.ROLE_NAME, OUTPUT_COLS=[T.install_status, T.ROLE_NAME, T.SCHEMA_NAME]}) Join(groups=[T, chorus_license.RL_LICENSE AS L], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=[T.ROLE_NAME, L.ROLE_NAME, T.install_status, T.SCHEMA_NAME]}) Source(groups=[T], props={NESTED_COMMAND=SELECT ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM demodata_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM security_cia_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM vantage_chorus_metadata.chorus_role, SYMBOL_MAP={T.ROLE_NAME=ROLE_NAME, T.SCHEMA_NAME='demodata_chorus_metadata', T.INSTALL_STATUS=INSTALL_STATUS}, OUTPUT_COLS=[T.ROLE_NAME, T.SCHEMA_NAME, T.INSTALL_STATUS]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Project(groups=[demodata_chorus_metadata.chorus_role], props={PROJECT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS], OUTPUT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Access(groups=[demodata_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Source(groups=[demodata_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Project(groups=[security_cia_chorus_metadata.chorus_role], props={PROJECT_COLS=[ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS], OUTPUT_COLS=[ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Access(groups=[security_cia_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Source(groups=[security_cia_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Project(groups=[vantage_chorus_metadata.chorus_role], props={PROJECT_COLS=[ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS], OUTPUT_COLS=[ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Access(groups=[vantage_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Source(groups=[vantage_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Access(groups=[chorus_license.RL_LICENSE AS L], props={OUTPUT_COLS=[L.ROLE_NAME]}) Source(groups=[chorus_license.RL_LICENSE AS L], props={OUTPUT_COLS=[L.ROLE_NAME]}) ============================================================================ EXECUTING PushSelectCriteria AFTER: Project(groups=[T], props={PROJECT_COLS=[T.ROLE_NAME AS ROLE_NAME, T.SCHEMA_NAME AS SCHEMA_NAME, T.INSTALL_STATUS AS INSTALL_STATUS], OUTPUT_COLS=[T.ROLE_NAME AS ROLE_NAME, T.SCHEMA_NAME AS SCHEMA_NAME, T.INSTALL_STATUS AS INSTALL_STATUS]}) Join(groups=[T, chorus_license.RL_LICENSE AS L], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[T.ROLE_NAME = L.ROLE_NAME], OUTPUT_COLS=[T.ROLE_NAME, L.ROLE_NAME, T.install_status, T.SCHEMA_NAME]}) Select(groups=[T], props={SELECT_CRITERIA=T.install_status = TRUE, OUTPUT_COLS=[T.ROLE_NAME, T.SCHEMA_NAME, T.INSTALL_STATUS], IS_PHANTOM=true}) Source(groups=[T], props={NESTED_COMMAND=SELECT ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM demodata_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM security_cia_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM vantage_chorus_metadata.chorus_role, SYMBOL_MAP={T.ROLE_NAME=ROLE_NAME, T.SCHEMA_NAME='demodata_chorus_metadata', T.INSTALL_STATUS=INSTALL_STATUS}, OUTPUT_COLS=[T.ROLE_NAME, T.SCHEMA_NAME, T.INSTALL_STATUS]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Project(groups=[demodata_chorus_metadata.chorus_role], props={PROJECT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS], OUTPUT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Access(groups=[demodata_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS], MODEL_ID=Schema name=demodata_chorus_metadata, nameInSource=null, uuid=mmuuid:52ce0c50-c433-496d-bcad-287699b86368}) Select(groups=[demodata_chorus_metadata.chorus_role], props={SELECT_CRITERIA=INSTALL_STATUS = TRUE}) Source(groups=[demodata_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Project(groups=[security_cia_chorus_metadata.chorus_role], props={PROJECT_COLS=[ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS], OUTPUT_COLS=[ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Access(groups=[security_cia_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS], MODEL_ID=Schema name=security_cia_chorus_metadata, nameInSource=null, uuid=mmuuid:143d8158-3899-4db9-a09b-0b54903f0c17}) Select(groups=[security_cia_chorus_metadata.chorus_role], props={SELECT_CRITERIA=INSTALL_STATUS = TRUE}) Source(groups=[security_cia_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Project(groups=[vantage_chorus_metadata.chorus_role], props={PROJECT_COLS=[ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS], OUTPUT_COLS=[ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Access(groups=[vantage_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS], MODEL_ID=Schema name=vantage_chorus_metadata, nameInSource=null, uuid=mmuuid:a568797a-5f41-4396-8d09-fef0b101b947}) Select(groups=[vantage_chorus_metadata.chorus_role], props={SELECT_CRITERIA=INSTALL_STATUS = TRUE}) Source(groups=[vantage_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Access(groups=[chorus_license.RL_LICENSE AS L], props={OUTPUT_COLS=[L.ROLE_NAME]}) Source(groups=[chorus_license.RL_LICENSE AS L], props={OUTPUT_COLS=[L.ROLE_NAME]}) ============================================================================ EXECUTING MergeVirtual AFTER: Project(groups=[T], props={PROJECT_COLS=[T.ROLE_NAME AS ROLE_NAME, T.SCHEMA_NAME AS SCHEMA_NAME, T.INSTALL_STATUS AS INSTALL_STATUS], OUTPUT_COLS=[T.ROLE_NAME AS ROLE_NAME, T.SCHEMA_NAME AS SCHEMA_NAME, T.INSTALL_STATUS AS INSTALL_STATUS]}) Join(groups=[T, chorus_license.RL_LICENSE AS L], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[T.ROLE_NAME = L.ROLE_NAME], OUTPUT_COLS=[T.ROLE_NAME, L.ROLE_NAME, T.install_status, T.SCHEMA_NAME]}) Select(groups=[T], props={SELECT_CRITERIA=T.install_status = TRUE, OUTPUT_COLS=[T.ROLE_NAME, T.SCHEMA_NAME, T.INSTALL_STATUS], IS_PHANTOM=true}) Source(groups=[T], props={NESTED_COMMAND=SELECT ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM demodata_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM security_cia_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM vantage_chorus_metadata.chorus_role, SYMBOL_MAP={T.ROLE_NAME=ROLE_NAME, T.SCHEMA_NAME='demodata_chorus_metadata', T.INSTALL_STATUS=INSTALL_STATUS}, OUTPUT_COLS=[T.ROLE_NAME, T.SCHEMA_NAME, T.INSTALL_STATUS]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Project(groups=[demodata_chorus_metadata.chorus_role], props={PROJECT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS], OUTPUT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Access(groups=[demodata_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS], MODEL_ID=Schema name=demodata_chorus_metadata, nameInSource=null, uuid=mmuuid:52ce0c50-c433-496d-bcad-287699b86368}) Select(groups=[demodata_chorus_metadata.chorus_role], props={SELECT_CRITERIA=INSTALL_STATUS = TRUE}) Source(groups=[demodata_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Project(groups=[security_cia_chorus_metadata.chorus_role], props={PROJECT_COLS=[ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS], OUTPUT_COLS=[ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Access(groups=[security_cia_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS], MODEL_ID=Schema name=security_cia_chorus_metadata, nameInSource=null, uuid=mmuuid:143d8158-3899-4db9-a09b-0b54903f0c17}) Select(groups=[security_cia_chorus_metadata.chorus_role], props={SELECT_CRITERIA=INSTALL_STATUS = TRUE}) Source(groups=[security_cia_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Project(groups=[vantage_chorus_metadata.chorus_role], props={PROJECT_COLS=[ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS], OUTPUT_COLS=[ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Access(groups=[vantage_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS], MODEL_ID=Schema name=vantage_chorus_metadata, nameInSource=null, uuid=mmuuid:a568797a-5f41-4396-8d09-fef0b101b947}) Select(groups=[vantage_chorus_metadata.chorus_role], props={SELECT_CRITERIA=INSTALL_STATUS = TRUE}) Source(groups=[vantage_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Access(groups=[chorus_license.RL_LICENSE AS L], props={OUTPUT_COLS=[L.ROLE_NAME]}) Source(groups=[chorus_license.RL_LICENSE AS L], props={OUTPUT_COLS=[L.ROLE_NAME]}) ============================================================================ EXECUTING PushNonJoinCriteria AFTER: Project(groups=[T], props={PROJECT_COLS=[T.ROLE_NAME AS ROLE_NAME, T.SCHEMA_NAME AS SCHEMA_NAME, T.INSTALL_STATUS AS INSTALL_STATUS], OUTPUT_COLS=[T.ROLE_NAME AS ROLE_NAME, T.SCHEMA_NAME AS SCHEMA_NAME, T.INSTALL_STATUS AS INSTALL_STATUS]}) Join(groups=[T, chorus_license.RL_LICENSE AS L], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[T.ROLE_NAME = L.ROLE_NAME], OUTPUT_COLS=[T.ROLE_NAME, L.ROLE_NAME, T.install_status, T.SCHEMA_NAME]}) Select(groups=[T], props={SELECT_CRITERIA=T.install_status = TRUE, OUTPUT_COLS=[T.ROLE_NAME, T.SCHEMA_NAME, T.INSTALL_STATUS], IS_PHANTOM=true}) Source(groups=[T], props={NESTED_COMMAND=SELECT ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM demodata_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM security_cia_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM vantage_chorus_metadata.chorus_role, SYMBOL_MAP={T.ROLE_NAME=ROLE_NAME, T.SCHEMA_NAME='demodata_chorus_metadata', T.INSTALL_STATUS=INSTALL_STATUS}, OUTPUT_COLS=[T.ROLE_NAME, T.SCHEMA_NAME, T.INSTALL_STATUS]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Project(groups=[demodata_chorus_metadata.chorus_role], props={PROJECT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS], OUTPUT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Access(groups=[demodata_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS], MODEL_ID=Schema name=demodata_chorus_metadata, nameInSource=null, uuid=mmuuid:52ce0c50-c433-496d-bcad-287699b86368}) Select(groups=[demodata_chorus_metadata.chorus_role], props={SELECT_CRITERIA=INSTALL_STATUS = TRUE}) Source(groups=[demodata_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Project(groups=[security_cia_chorus_metadata.chorus_role], props={PROJECT_COLS=[ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS], OUTPUT_COLS=[ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Access(groups=[security_cia_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS], MODEL_ID=Schema name=security_cia_chorus_metadata, nameInSource=null, uuid=mmuuid:143d8158-3899-4db9-a09b-0b54903f0c17}) Select(groups=[security_cia_chorus_metadata.chorus_role], props={SELECT_CRITERIA=INSTALL_STATUS = TRUE}) Source(groups=[security_cia_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Project(groups=[vantage_chorus_metadata.chorus_role], props={PROJECT_COLS=[ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS], OUTPUT_COLS=[ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Access(groups=[vantage_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS], MODEL_ID=Schema name=vantage_chorus_metadata, nameInSource=null, uuid=mmuuid:a568797a-5f41-4396-8d09-fef0b101b947}) Select(groups=[vantage_chorus_metadata.chorus_role], props={SELECT_CRITERIA=INSTALL_STATUS = TRUE}) Source(groups=[vantage_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Access(groups=[chorus_license.RL_LICENSE AS L], props={OUTPUT_COLS=[L.ROLE_NAME]}) Source(groups=[chorus_license.RL_LICENSE AS L], props={OUTPUT_COLS=[L.ROLE_NAME]}) ============================================================================ EXECUTING CopyCriteria AFTER: Project(groups=[T], props={PROJECT_COLS=[T.ROLE_NAME AS ROLE_NAME, T.SCHEMA_NAME AS SCHEMA_NAME, T.INSTALL_STATUS AS INSTALL_STATUS], OUTPUT_COLS=[T.ROLE_NAME AS ROLE_NAME, T.SCHEMA_NAME AS SCHEMA_NAME, T.INSTALL_STATUS AS INSTALL_STATUS]}) Join(groups=[T, chorus_license.RL_LICENSE AS L], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[T.ROLE_NAME = L.ROLE_NAME], OUTPUT_COLS=[T.ROLE_NAME, L.ROLE_NAME, T.install_status, T.SCHEMA_NAME], IS_COPIED=true}) Select(groups=[T], props={SELECT_CRITERIA=T.install_status = TRUE, OUTPUT_COLS=[T.ROLE_NAME, T.SCHEMA_NAME, T.INSTALL_STATUS], IS_PHANTOM=true, IS_COPIED=true}) Source(groups=[T], props={NESTED_COMMAND=SELECT ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM demodata_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM security_cia_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM vantage_chorus_metadata.chorus_role, SYMBOL_MAP={T.ROLE_NAME=ROLE_NAME, T.SCHEMA_NAME='demodata_chorus_metadata', T.INSTALL_STATUS=INSTALL_STATUS}, OUTPUT_COLS=[T.ROLE_NAME, T.SCHEMA_NAME, T.INSTALL_STATUS]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Project(groups=[demodata_chorus_metadata.chorus_role], props={PROJECT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS], OUTPUT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Access(groups=[demodata_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS], MODEL_ID=Schema name=demodata_chorus_metadata, nameInSource=null, uuid=mmuuid:52ce0c50-c433-496d-bcad-287699b86368}) Select(groups=[demodata_chorus_metadata.chorus_role], props={SELECT_CRITERIA=INSTALL_STATUS = TRUE, IS_COPIED=true}) Source(groups=[demodata_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Project(groups=[security_cia_chorus_metadata.chorus_role], props={PROJECT_COLS=[ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS], OUTPUT_COLS=[ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Access(groups=[security_cia_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS], MODEL_ID=Schema name=security_cia_chorus_metadata, nameInSource=null, uuid=mmuuid:143d8158-3899-4db9-a09b-0b54903f0c17}) Select(groups=[security_cia_chorus_metadata.chorus_role], props={SELECT_CRITERIA=INSTALL_STATUS = TRUE, IS_COPIED=true}) Source(groups=[security_cia_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Project(groups=[vantage_chorus_metadata.chorus_role], props={PROJECT_COLS=[ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS], OUTPUT_COLS=[ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Access(groups=[vantage_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS], MODEL_ID=Schema name=vantage_chorus_metadata, nameInSource=null, uuid=mmuuid:a568797a-5f41-4396-8d09-fef0b101b947}) Select(groups=[vantage_chorus_metadata.chorus_role], props={SELECT_CRITERIA=INSTALL_STATUS = TRUE, IS_COPIED=true}) Source(groups=[vantage_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Access(groups=[chorus_license.RL_LICENSE AS L], props={OUTPUT_COLS=[L.ROLE_NAME]}) Source(groups=[chorus_license.RL_LICENSE AS L], props={OUTPUT_COLS=[L.ROLE_NAME]}) ============================================================================ EXECUTING CleanCriteria AFTER: Project(groups=[T], props={PROJECT_COLS=[T.ROLE_NAME AS ROLE_NAME, T.SCHEMA_NAME AS SCHEMA_NAME, T.INSTALL_STATUS AS INSTALL_STATUS], OUTPUT_COLS=[T.ROLE_NAME AS ROLE_NAME, T.SCHEMA_NAME AS SCHEMA_NAME, T.INSTALL_STATUS AS INSTALL_STATUS]}) Join(groups=[T, chorus_license.RL_LICENSE AS L], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[T.ROLE_NAME = L.ROLE_NAME], OUTPUT_COLS=[T.ROLE_NAME, L.ROLE_NAME, T.install_status, T.SCHEMA_NAME], IS_COPIED=true}) Source(groups=[T], props={NESTED_COMMAND=SELECT ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM demodata_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM security_cia_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM vantage_chorus_metadata.chorus_role, SYMBOL_MAP={T.ROLE_NAME=ROLE_NAME, T.SCHEMA_NAME='demodata_chorus_metadata', T.INSTALL_STATUS=INSTALL_STATUS}, OUTPUT_COLS=[T.ROLE_NAME, T.SCHEMA_NAME, T.INSTALL_STATUS]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Project(groups=[demodata_chorus_metadata.chorus_role], props={PROJECT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS], OUTPUT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Access(groups=[demodata_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS], MODEL_ID=Schema name=demodata_chorus_metadata, nameInSource=null, uuid=mmuuid:52ce0c50-c433-496d-bcad-287699b86368}) Select(groups=[demodata_chorus_metadata.chorus_role], props={SELECT_CRITERIA=INSTALL_STATUS = TRUE, IS_COPIED=true}) Source(groups=[demodata_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Project(groups=[security_cia_chorus_metadata.chorus_role], props={PROJECT_COLS=[ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS], OUTPUT_COLS=[ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Access(groups=[security_cia_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS], MODEL_ID=Schema name=security_cia_chorus_metadata, nameInSource=null, uuid=mmuuid:143d8158-3899-4db9-a09b-0b54903f0c17}) Select(groups=[security_cia_chorus_metadata.chorus_role], props={SELECT_CRITERIA=INSTALL_STATUS = TRUE, IS_COPIED=true}) Source(groups=[security_cia_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Project(groups=[vantage_chorus_metadata.chorus_role], props={PROJECT_COLS=[ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS], OUTPUT_COLS=[ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Access(groups=[vantage_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS], MODEL_ID=Schema name=vantage_chorus_metadata, nameInSource=null, uuid=mmuuid:a568797a-5f41-4396-8d09-fef0b101b947}) Select(groups=[vantage_chorus_metadata.chorus_role], props={SELECT_CRITERIA=INSTALL_STATUS = TRUE, IS_COPIED=true}) Source(groups=[vantage_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Access(groups=[chorus_license.RL_LICENSE AS L], props={OUTPUT_COLS=[L.ROLE_NAME]}) Source(groups=[chorus_license.RL_LICENSE AS L], props={OUTPUT_COLS=[L.ROLE_NAME]}) ============================================================================ EXECUTING PlanUnions AFTER: Project(groups=[T], props={PROJECT_COLS=[T.ROLE_NAME AS ROLE_NAME, T.SCHEMA_NAME AS SCHEMA_NAME, T.INSTALL_STATUS AS INSTALL_STATUS], OUTPUT_COLS=[T.ROLE_NAME AS ROLE_NAME, T.SCHEMA_NAME AS SCHEMA_NAME, T.INSTALL_STATUS AS INSTALL_STATUS]}) Join(groups=[T, chorus_license.RL_LICENSE AS L], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[T.ROLE_NAME = L.ROLE_NAME], OUTPUT_COLS=[T.ROLE_NAME, L.ROLE_NAME, T.install_status, T.SCHEMA_NAME], IS_COPIED=true}) Source(groups=[T], props={NESTED_COMMAND=SELECT ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM demodata_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM security_cia_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM vantage_chorus_metadata.chorus_role, SYMBOL_MAP={T.ROLE_NAME=ROLE_NAME, T.SCHEMA_NAME='demodata_chorus_metadata', T.INSTALL_STATUS=INSTALL_STATUS}, OUTPUT_COLS=[T.ROLE_NAME, T.SCHEMA_NAME, T.INSTALL_STATUS]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Project(groups=[demodata_chorus_metadata.chorus_role], props={PROJECT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS], OUTPUT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Access(groups=[demodata_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS], MODEL_ID=Schema name=demodata_chorus_metadata, nameInSource=null, uuid=mmuuid:52ce0c50-c433-496d-bcad-287699b86368}) Select(groups=[demodata_chorus_metadata.chorus_role], props={SELECT_CRITERIA=INSTALL_STATUS = TRUE, IS_COPIED=true}) Source(groups=[demodata_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Project(groups=[security_cia_chorus_metadata.chorus_role], props={PROJECT_COLS=[ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS], OUTPUT_COLS=[ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Access(groups=[security_cia_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS], MODEL_ID=Schema name=security_cia_chorus_metadata, nameInSource=null, uuid=mmuuid:143d8158-3899-4db9-a09b-0b54903f0c17}) Select(groups=[security_cia_chorus_metadata.chorus_role], props={SELECT_CRITERIA=INSTALL_STATUS = TRUE, IS_COPIED=true}) Source(groups=[security_cia_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Project(groups=[vantage_chorus_metadata.chorus_role], props={PROJECT_COLS=[ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS], OUTPUT_COLS=[ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Access(groups=[vantage_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS], MODEL_ID=Schema name=vantage_chorus_metadata, nameInSource=null, uuid=mmuuid:a568797a-5f41-4396-8d09-fef0b101b947}) Select(groups=[vantage_chorus_metadata.chorus_role], props={SELECT_CRITERIA=INSTALL_STATUS = TRUE, IS_COPIED=true}) Source(groups=[vantage_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Access(groups=[chorus_license.RL_LICENSE AS L], props={OUTPUT_COLS=[L.ROLE_NAME]}) Source(groups=[chorus_license.RL_LICENSE AS L], props={OUTPUT_COLS=[L.ROLE_NAME]}) ============================================================================ EXECUTING RaiseAccess AFTER: Project(groups=[T], props={PROJECT_COLS=[T.ROLE_NAME AS ROLE_NAME, T.SCHEMA_NAME AS SCHEMA_NAME, T.INSTALL_STATUS AS INSTALL_STATUS], OUTPUT_COLS=[T.ROLE_NAME AS ROLE_NAME, T.SCHEMA_NAME AS SCHEMA_NAME, T.INSTALL_STATUS AS INSTALL_STATUS]}) Join(groups=[T, chorus_license.RL_LICENSE AS L], props={JOIN_TYPE=INNER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[T.ROLE_NAME = L.ROLE_NAME], OUTPUT_COLS=[T.ROLE_NAME, L.ROLE_NAME, T.install_status, T.SCHEMA_NAME], IS_COPIED=true}) Source(groups=[T], props={NESTED_COMMAND=SELECT ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM demodata_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM security_cia_chorus_metadata.chorus_role UNION SELECT ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS FROM vantage_chorus_metadata.chorus_role, SYMBOL_MAP={T.ROLE_NAME=ROLE_NAME, T.SCHEMA_NAME='demodata_chorus_metadata', T.INSTALL_STATUS=INSTALL_STATUS}, OUTPUT_COLS=[T.ROLE_NAME, T.SCHEMA_NAME, T.INSTALL_STATUS]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false, OUTPUT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Access(groups=[demodata_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS], MODEL_ID=Schema name=demodata_chorus_metadata, nameInSource=null, uuid=mmuuid:52ce0c50-c433-496d-bcad-287699b86368}) Project(groups=[demodata_chorus_metadata.chorus_role], props={PROJECT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS], OUTPUT_COLS=[ROLE_NAME, 'demodata_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Select(groups=[demodata_chorus_metadata.chorus_role], props={SELECT_CRITERIA=INSTALL_STATUS = TRUE, IS_COPIED=true}) Source(groups=[demodata_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Access(groups=[security_cia_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS], MODEL_ID=Schema name=security_cia_chorus_metadata, nameInSource=null, uuid=mmuuid:143d8158-3899-4db9-a09b-0b54903f0c17}) Project(groups=[security_cia_chorus_metadata.chorus_role], props={PROJECT_COLS=[ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS], OUTPUT_COLS=[ROLE_NAME, 'security_cia_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Select(groups=[security_cia_chorus_metadata.chorus_role], props={SELECT_CRITERIA=INSTALL_STATUS = TRUE, IS_COPIED=true}) Source(groups=[security_cia_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Access(groups=[vantage_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS], MODEL_ID=Schema name=vantage_chorus_metadata, nameInSource=null, uuid=mmuuid:a568797a-5f41-4396-8d09-fef0b101b947}) Project(groups=[vantage_chorus_metadata.chorus_role], props={PROJECT_COLS=[ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS], OUTPUT_COLS=[ROLE_NAME, 'vantage_chorus_metadata' AS SCHEMA_NAME, INSTALL_STATUS]}) Select(groups=[vantage_chorus_metadata.chorus_role], props={SELECT_CRITERIA=INSTALL_STATUS = TRUE, IS_COPIED=true}) Source(groups=[vantage_chorus_metadata.chorus_role], props={OUTPUT_COLS=[ROLE_NAME, INSTALL_STATUS]}) Access(groups=[chorus_license.RL_LICENSE AS L], props={OUTPUT_COLS=[L.ROLE_NAME], MODEL_ID=Schema name=chorus_license, nameInSource=null, uuid=mmuuid:23283130-6e48-4ef9-992c-ea6f85c5f726}) Source(groups=[chorus_license.RL_LICENSE AS L], props={OUTPUT_COLS=[L.ROLE_NAME]}) ============================================================================ EXECUTING PlanJoins 06 Jan 2012 19:55:33,799 CST ERROR [org.teiid.PROCESSOR] (Worker67_QueryProcessorQueue4250) Unexpected exception for request SkwfOSMhfPp3.0 java.lang.NullPointerException at org.teiid.query.optimizer.relational.rules.NewCalculateCostUtil.setColStatEstimates(NewCalculateCostUtil.java:427) at org.teiid.query.optimizer.relational.rules.NewCalculateCostUtil.setCardinalityEstimate(NewCalculateCostUtil.java:328) at org.teiid.query.optimizer.relational.rules.NewCalculateCostUtil.estimateSetOpCost(NewCalculateCostUtil.java:274) at org.teiid.query.optimizer.relational.rules.NewCalculateCostUtil.computeNodeCost(NewCalculateCostUtil.java:226) at org.teiid.query.optimizer.relational.rules.NewCalculateCostUtil.updateCardinality(NewCalculateCostUtil.java:158) at org.teiid.query.optimizer.relational.rules.NewCalculateCostUtil.updateCardinality(NewCalculateCostUtil.java:155) at org.teiid.query.optimizer.relational.rules.NewCalculateCostUtil.updateCardinality(NewCalculateCostUtil.java:155) at org.teiid.query.optimizer.relational.rules.NewCalculateCostUtil.computeCostForTree(NewCalculateCostUtil.java:144) at org.teiid.query.optimizer.relational.rules.JoinRegion.initializeCostingInformation(JoinRegion.java:399) at org.teiid.query.optimizer.relational.rules.RulePlanJoins.execute(RulePlanJoins.java:170) at org.teiid.query.optimizer.relational.RelationalPlanner.executeRules(RelationalPlanner.java:490) at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:249) at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:190) at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:436) at org.teiid.dqp.internal.process.Request.processRequest(Request.java:459) at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:506) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:276) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:215) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) ****************************