26 Apr 2012 13:23:36,358 CDT INFO [org.teiid.PLANNER] (Worker2_QueryProcessorQueue8806) ============================================================================ USER COMMAND: SELECT CHORUS_B.SCDNAME, 'Storage.SSC' AS "__objecttype__" FROM Storage.SSC AS CHORUS_B LIMIT 100 ---------------------------------------------------------------------------- OPTIMIZE: SELECT CHORUS_B.SCDNAME, 'Storage.SSC' AS "__objecttype__" FROM Storage.SSC AS CHORUS_B LIMIT 100 ---------------------------------------------------------------------------- GENERATE CANONICAL: SELECT CHORUS_B.SCDNAME, 'Storage.SSC' AS "__objecttype__" FROM Storage.SSC AS CHORUS_B LIMIT 100 CANONICAL PLAN: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, IS_STRICT=true}) Project(groups=[Storage.SSC AS CHORUS_B], props={PROJECT_COLS=[CHORUS_B.SCDNAME, 'Storage.SSC' AS "__objecttype__"]}) Source(groups=[Storage.SSC AS CHORUS_B]) ============================================================================ EXECUTING PlaceAccess AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, IS_STRICT=true}) Project(groups=[Storage.SSC AS CHORUS_B], props={PROJECT_COLS=[CHORUS_B.SCDNAME, 'Storage.SSC' AS "__objecttype__"]}) Access(groups=[Storage.SSC AS CHORUS_B]) Source(groups=[Storage.SSC AS CHORUS_B]) ============================================================================ EXECUTING RaiseAccess limit not supported by source storage_ds AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, IS_STRICT=true}) Access(groups=[Storage.SSC AS CHORUS_B], props={MODEL_ID=Schema name=storage_ds, nameInSource=null, uuid=mmuuid:50959697-9f25-4f21-98da-d3669263edf6}) Project(groups=[Storage.SSC AS CHORUS_B], props={PROJECT_COLS=[CHORUS_B.SCDNAME, 'Storage.SSC' AS "__objecttype__"]}) Source(groups=[Storage.SSC AS CHORUS_B]) ============================================================================ EXECUTING PushLimit limit not supported by source storage_ds AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, IS_STRICT=true}) Access(groups=[Storage.SSC AS CHORUS_B], props={MODEL_ID=Schema name=storage_ds, nameInSource=null, uuid=mmuuid:50959697-9f25-4f21-98da-d3669263edf6}) Project(groups=[Storage.SSC AS CHORUS_B], props={PROJECT_COLS=[CHORUS_B.SCDNAME, 'Storage.SSC' AS "__objecttype__"]}) Source(groups=[Storage.SSC AS CHORUS_B]) ============================================================================ EXECUTING AssignOutputElements AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, IS_STRICT=true, OUTPUT_COLS=[CHORUS_B.SCDNAME, 'Storage.SSC' AS "__objecttype__"]}) Access(groups=[Storage.SSC AS CHORUS_B], props={MODEL_ID=Schema name=storage_ds, nameInSource=null, uuid=mmuuid:50959697-9f25-4f21-98da-d3669263edf6, OUTPUT_COLS=[CHORUS_B.SCDNAME, 'Storage.SSC' AS "__objecttype__"]}) Project(groups=[Storage.SSC AS CHORUS_B], props={PROJECT_COLS=[CHORUS_B.SCDNAME, 'Storage.SSC' AS "__objecttype__"], OUTPUT_COLS=[CHORUS_B.SCDNAME, 'Storage.SSC' AS "__objecttype__"]}) Source(groups=[Storage.SSC AS CHORUS_B], props={OUTPUT_COLS=[CHORUS_B.SCDNAME]}) ============================================================================ EXECUTING CalculateCost AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, IS_STRICT=true, OUTPUT_COLS=[CHORUS_B.SCDNAME, 'Storage.SSC' AS "__objecttype__"], EST_CARDINALITY=100.0, EST_COL_STATS={CHORUS_B.SCDNAME=[100.0, 0.0], 'Storage.SSC' AS "__objecttype__"=[100.0, 0.0]}}) Access(groups=[Storage.SSC AS CHORUS_B], props={MODEL_ID=Schema name=storage_ds, nameInSource=null, uuid=mmuuid:50959697-9f25-4f21-98da-d3669263edf6, OUTPUT_COLS=[CHORUS_B.SCDNAME, 'Storage.SSC' AS "__objecttype__"], EST_CARDINALITY=-1.0}) Project(groups=[Storage.SSC AS CHORUS_B], props={PROJECT_COLS=[CHORUS_B.SCDNAME, 'Storage.SSC' AS "__objecttype__"], OUTPUT_COLS=[CHORUS_B.SCDNAME, 'Storage.SSC' AS "__objecttype__"], EST_CARDINALITY=-1.0}) Source(groups=[Storage.SSC AS CHORUS_B], props={OUTPUT_COLS=[CHORUS_B.SCDNAME], EST_COL_STATS={CHORUS_B.SCDNAME=[-1.0, -1.0]}, EST_CARDINALITY=-1.0}) ============================================================================ EXECUTING PlanSorts AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, IS_STRICT=true, OUTPUT_COLS=[CHORUS_B.SCDNAME, 'Storage.SSC' AS "__objecttype__"], EST_CARDINALITY=100.0, EST_COL_STATS={CHORUS_B.SCDNAME=[100.0, 0.0], 'Storage.SSC' AS "__objecttype__"=[100.0, 0.0]}}) Access(groups=[Storage.SSC AS CHORUS_B], props={MODEL_ID=Schema name=storage_ds, nameInSource=null, uuid=mmuuid:50959697-9f25-4f21-98da-d3669263edf6, OUTPUT_COLS=[CHORUS_B.SCDNAME, 'Storage.SSC' AS "__objecttype__"], EST_CARDINALITY=-1.0}) Project(groups=[Storage.SSC AS CHORUS_B], props={PROJECT_COLS=[CHORUS_B.SCDNAME, 'Storage.SSC' AS "__objecttype__"], OUTPUT_COLS=[CHORUS_B.SCDNAME, 'Storage.SSC' AS "__objecttype__"], EST_CARDINALITY=-1.0}) Source(groups=[Storage.SSC AS CHORUS_B], props={OUTPUT_COLS=[CHORUS_B.SCDNAME], EST_COL_STATS={CHORUS_B.SCDNAME=[-1.0, -1.0]}, EST_CARDINALITY=-1.0}) ============================================================================ EXECUTING CollapseSource AFTER: TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=100, IS_STRICT=true, OUTPUT_COLS=[CHORUS_B.SCDNAME, 'Storage.SSC' AS "__objecttype__"], EST_CARDINALITY=100.0, EST_COL_STATS={CHORUS_B.SCDNAME=[100.0, 0.0], 'Storage.SSC' AS "__objecttype__"=[100.0, 0.0]}}) Access(groups=[Storage.SSC AS CHORUS_B], props={MODEL_ID=Schema name=storage_ds, nameInSource=null, uuid=mmuuid:50959697-9f25-4f21-98da-d3669263edf6, OUTPUT_COLS=[CHORUS_B.SCDNAME, 'Storage.SSC' AS "__objecttype__"], EST_CARDINALITY=-1.0, ATOMIC_REQUEST=SELECT CHORUS_B.SCDNAME, 'Storage.SSC' AS "__objecttype__" FROM Storage.SSC AS CHORUS_B}) ============================================================================ CONVERTING PLAN TREE TO PROCESS TREE PROCESS PLAN = LimitNode(0) output=[CHORUS_B.SCDNAME, 'Storage.SSC' AS "__objecttype__"] limit 100 UnionAllNode(4) output=[CHORUS_B.SCDNAME, 'Storage.SSC' AS "__objecttype__"] AccessNode(2) output=[CHORUS_B.SCDNAME, 'Storage.SSC' AS "__objecttype__"] SELECT storage_ds.Storage.SSC.SCDNAME FROM storage_ds.Storage.SSC AccessNode(3) output=[CHORUS_B.SCDNAME, 'Storage.SSC' AS "__objecttype__"] SELECT storage_ds.Storage.SSC.SCDNAME FROM storage_ds.Storage.SSC ============================================================================ ---------------------------------------------------------------------------- OPTIMIZATION COMPLETE: PROCESSOR PLAN: LimitNode(0) output=[CHORUS_B.SCDNAME, 'Storage.SSC' AS "__objecttype__"] limit 100 UnionAllNode(4) output=[CHORUS_B.SCDNAME, 'Storage.SSC' AS "__objecttype__"] AccessNode(2) output=[CHORUS_B.SCDNAME, 'Storage.SSC' AS "__objecttype__"] SELECT storage_ds.Storage.SSC.SCDNAME FROM storage_ds.Storage.SSC AccessNode(3) output=[CHORUS_B.SCDNAME, 'Storage.SSC' AS "__objecttype__"] SELECT storage_ds.Storage.SSC.SCDNAME FROM storage_ds.Storage.SSC ============================================================================