==> server.log <==
2017-02-15 13:59:47,497 DEBUG [org.teiid.TRANSPORT] (NIO4)  processing message:MessageHolder: key=2530 contents=Invoke interface org.teiid.client.security.ILogon.ping
2017-02-15 13:59:47,497 DEBUG [org.teiid.SECURITY] (NIO4) t1sHxoM3FjUP Keep-alive ping received for session: t1sHxoM3FjUP
2017-02-15 13:59:47,498 TRACE [org.teiid.SECURITY] (NIO4) t1sHxoM3FjUP Ping t1sHxoM3FjUP
2017-02-15 13:59:47,498 DEBUG [org.teiid.TRANSPORT] (NIO4) t1sHxoM3FjUP send message: MessageHolder: key=2530 contents=null
2017-02-15 13:59:47,515 DEBUG [org.teiid.TRANSPORT] (NIO5)  processing message:MessageHolder: key=2531 contents=Invoke interface org.teiid.client.security.ILogon.ping
2017-02-15 13:59:47,516 DEBUG [org.teiid.SECURITY] (NIO5) XgKeHAtjYhxx Keep-alive ping received for session: XgKeHAtjYhxx
2017-02-15 13:59:47,516 TRACE [org.teiid.SECURITY] (NIO5) XgKeHAtjYhxx Ping XgKeHAtjYhxx
2017-02-15 13:59:47,516 DEBUG [org.teiid.TRANSPORT] (NIO5) XgKeHAtjYhxx send message: MessageHolder: key=2531 contents=null
2017-02-15 13:59:47,519 DEBUG [org.teiid.TRANSPORT] (NIO5)  processing message:MessageHolder: key=2532 contents=Invoke interface org.teiid.client.DQP.executeRequest
2017-02-15 13:59:47,519 TRACE [org.teiid.PROCESSOR] (NIO5) XgKeHAtjYhxx before executeRequest:org.teiid.dqp.internal.process.DQPCore@67f89af4(18,org.teiid.client.RequestMessage@6b66e236)

==> teiid-command.log <==
13:59:47,520 INFO  [org.teiid.COMMAND_LOG] (NIO5) XgKeHAtjYhxx  START USER COMMAND:     startTime=2017-02-15 13:59:47.52        requestID=XgKeHAtjYhxx.18     txID=null       sessionID=XgKeHAtjYhxx  applicationName=JDBC    principal=manel vdbName=CountryServiceListVDBvdbVersion=1     sql=SELECT COUNT(*)
FROM
        VodafoneNl.vodafone_nl AS vnl
        LEFT JOIN NumberingPlan.numbering_plan AS np
        ON (np.mobile_country_code = vnl.mcc) AND (np.mobile_network_code = vnl.mnc)

==> server.log <==
2017-02-15 13:59:47,520 INFO  [org.teiid.COMMAND_LOG] (NIO5) XgKeHAtjYhxx       START USER COMMAND:     startTime=2017-02-15 13:59:47.52      requestID=XgKeHAtjYhxx.18       txID=null       sessionID=XgKeHAtjYhxx  applicationName=JDBC    principal=manel vdbName=CountryServiceListVDB vdbVersion=1    sql=SELECT COUNT(*)
FROM
        VodafoneNl.vodafone_nl AS vnl
        LEFT JOIN NumberingPlan.numbering_plan AS np
        ON (np.mobile_country_code = vnl.mcc) AND (np.mobile_network_code = vnl.mnc)
2017-02-15 13:59:47,520 TRACE [org.teiid.PROCESSOR] (NIO5) XgKeHAtjYhxx after executeRequest : org.teiid.client.util.ResultsFuture@7f24c4b3
2017-02-15 13:59:47,520 TRACE [org.teiid.RUNTIME] (Worker179_QueryProcessorQueue87114)  Beginning work with virtual worker Worker179_QueryProcessorQueue87114
2017-02-15 13:59:47,538 TRACE [org.teiid.PROCESSOR] (Worker179_QueryProcessorQueue87114) XgKeHAtjYhxx XgKeHAtjYhxx.18 start processing MORE_WORK
2017-02-15 13:59:47,539 DEBUG [org.teiid.PROCESSOR] (Worker179_QueryProcessorQueue87114) XgKeHAtjYhxx Request Thread XgKeHAtjYhxx.18 with state NEW
2017-02-15 13:59:47,539 DEBUG [org.teiid.PROCESSOR] (Worker179_QueryProcessorQueue87114) XgKeHAtjYhxx XgKeHAtjYhxx.18 Command has no cache hint and result set cache mode is not on.
2017-02-15 13:59:47,539 DEBUG [org.teiid.PROCESSOR] (Worker179_QueryProcessorQueue87114) XgKeHAtjYhxx XgKeHAtjYhxx.18 executing  SELECT COUNT(*)
FROM
        VodafoneNl.vodafone_nl AS vnl
        LEFT JOIN NumberingPlan.numbering_plan AS np
        ON (np.mobile_country_code = vnl.mcc) AND (np.mobile_network_code = vnl.mnc)
2017-02-15 13:59:47,540 TRACE [org.teiid.PLANNER.RESOLVER] (Worker179_QueryProcessorQueue87114) XgKeHAtjYhxx Resolving command SELECT COUNT(*) FROM VodafoneNl.vodafone_nl AS vnl LEFT OUTER JOIN NumberingPlan.numbering_plan AS np ON np.mobile_country_code = vnl.mcc AND np.mobile_network_code = vnl.mnc
2017-02-15 13:59:47,590 TRACE [org.teiid.PLANNER] (Worker179_QueryProcessorQueue87114) XgKeHAtjYhxx
============================================================================
USER COMMAND:
SELECT COUNT(*) FROM VodafoneNl.vodafone_nl AS vnl LEFT OUTER JOIN NumberingPlan.numbering_plan AS np ON np.mobile_country_code = vnl.mcc AND np.mobile_network_code = vnl.mnc

----------------------------------------------------------------------------
OPTIMIZE:
SELECT COUNT(*) FROM VodafoneNl.vodafone_nl AS vnl LEFT OUTER JOIN NumberingPlan.numbering_plan AS np ON np.mobile_country_code = vnl.mcc AND np.mobile_network_code = vnl.mnc

----------------------------------------------------------------------------
GENERATE CANONICAL:
SELECT COUNT(*) FROM VodafoneNl.vodafone_nl AS vnl LEFT OUTER JOIN NumberingPlan.numbering_plan AS np ON np.mobile_country_code = vnl.mcc AND np.mobile_network_code = vnl.mnc
LOW [Materialized View] The query against VodafoneNl.vodafone_nl AS vnl was redirected to the materialization table VodafoneNlMaterialized.vodafone_nl_cache. - null
LOW [Materialized View] The query against NumberingPlan.numbering_plan AS np was redirected to the materialization table NumberingPlanMaterialized.numbering_plan_cache. - null

CANONICAL PLAN:
Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.agg0 AS expr1]})
  Group(groups=[anon_grp0], props={SYMBOL_MAP={anon_grp0.agg0=COUNT(*)}})
    Join(groups=[VodafoneNl.vodafone_nl AS vnl, NumberingPlan.numbering_plan AS np], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[np.mobile_country_code = vnl.mcc, np.mobile_network_code = vnl.mnc]})
      Source(groups=[VodafoneNl.vodafone_nl AS vnl], props={NESTED_COMMAND=SELECT country, name_network, type_network, suspended_7, voice_sms, camel, camel_phase, data_gprs, data_umts, data_hsdpa, sms_iw_mvno_send, tap_code, mcc, mnc FROM VodafoneNlMaterialized.vodafone_nl_cache WHERE (SELECT mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN VodafoneNlMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'VodafoneNl' AND Name = 'vodafone_nl' LIMIT 2) = 1, SYMBOL_MAP={vnl.country=country, vnl.name_network=name_network, vnl.type_network=type_network, vnl.suspended_7=suspended_7, vnl.voice_sms=voice_sms, vnl.camel=camel, vnl.camel_phase=camel_phase, vnl.data_gprs=data_gprs, vnl.data_umts=data_umts, vnl.data_hsdpa=data_hsdpa, vnl.sms_iw_mvno_send=sms_iw_mvno_send, vnl.tap_code=tap_code, vnl.mcc=mcc, vnl.mnc=mnc}})
        Project(groups=[VodafoneNlMaterialized.vodafone_nl_cache], props={PROJECT_COLS=[country, name_network, type_network, suspended_7, voice_sms, camel, camel_phase, data_gprs, data_umts, data_hsdpa, sms_iw_mvno_send, tap_code, mcc, mnc]})
          Select(groups=[], props={SELECT_CRITERIA=(SELECT mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN VodafoneNlMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'VodafoneNl' AND Name = 'vodafone_nl' LIMIT 2) = 1})
            Source(groups=[VodafoneNlMaterialized.vodafone_nl_cache])
      Source(groups=[NumberingPlan.numbering_plan AS np], props={NESTED_COMMAND=SELECT cns, country_code, national_significant_number, iso_3166_alpha_2, iso_3166_alpha_3, utc_min, utc_max, destination, type_id, description, location, registrar, area_code_length, min_subscr_nr_length, max_subscr_nr_length, range_activation, range_deactivation, range_status, mobile_country_code, mobile_network_code, operating_company_number FROM NumberingPlanMaterialized.numbering_plan_cache WHERE (SELECT mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN NumberingPlanMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'NumberingPlan' AND Name = 'numbering_plan' LIMIT 2) = 1, SYMBOL_MAP={np.cns=cns, np.country_code=country_code, np.national_significant_number=national_significant_number, np.iso_3166_alpha_2=iso_3166_alpha_2, np.iso_3166_alpha_3=iso_3166_alpha_3, np.utc_min=utc_min, np.utc_max=utc_max, np.destination=destination, np.type_id=type_id, np.description=description, np.location=location, np.registrar=registrar, np.area_code_length=area_code_length, np.min_subscr_nr_length=min_subscr_nr_length, np.max_subscr_nr_length=max_subscr_nr_length, np.range_activation=range_activation, np.range_deactivation=range_deactivation, np.range_status=range_status, np.mobile_country_code=mobile_country_code, np.mobile_network_code=mobile_network_code, np.operating_company_number=operating_company_number}})
        Project(groups=[NumberingPlanMaterialized.numbering_plan_cache], props={PROJECT_COLS=[cns, country_code, national_significant_number, iso_3166_alpha_2, iso_3166_alpha_3, utc_min, utc_max, destination, type_id, description, location, registrar, area_code_length, min_subscr_nr_length, max_subscr_nr_length, range_activation, range_deactivation, range_status, mobile_country_code, mobile_network_code, operating_company_number]})
          Select(groups=[], props={SELECT_CRITERIA=(SELECT mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN NumberingPlanMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'NumberingPlan' AND Name = 'numbering_plan' LIMIT 2) = 1})
            Source(groups=[NumberingPlanMaterialized.numbering_plan_cache])


----------------------------------------------------------------------------
OPTIMIZE:
SELECT mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN VodafoneNlMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'VodafoneNl' AND Name = 'vodafone_nl' LIMIT 2

----------------------------------------------------------------------------
GENERATE CANONICAL:
SELECT mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN VodafoneNlMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'VodafoneNl' AND Name = 'vodafone_nl' LIMIT 2

CANONICAL PLAN:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true})
  Project(groups=[VodafoneNlMaterialized.status], props={PROJECT_COLS=[mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION')]})
    Join(groups=[x, VodafoneNlMaterialized.status], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[VDBName = 'CountryServiceListVDB', VDBVersion = '1', SchemaName = 'VodafoneNl', Name = 'vodafone_nl']})
      Source(groups=[x], props={NESTED_COMMAND=SELECT 1, SYMBOL_MAP={x.expr1=1}})
        Project(groups=[], props={PROJECT_COLS=[1]})
      Source(groups=[VodafoneNlMaterialized.status])


============================================================================
EXECUTING PlaceAccess

AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true})
  Project(groups=[VodafoneNlMaterialized.status], props={PROJECT_COLS=[mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION')]})
    Join(groups=[x, VodafoneNlMaterialized.status], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[VDBName = 'CountryServiceListVDB', VDBVersion = '1', SchemaName = 'VodafoneNl', Name = 'vodafone_nl']})
      Source(groups=[x], props={NESTED_COMMAND=SELECT 1, SYMBOL_MAP={x.expr1=1}})
        Project(groups=[], props={PROJECT_COLS=[1]})
      Access(groups=[VodafoneNlMaterialized.status], props={SOURCE_HINT=null, MODEL_ID=Schema name=VodafoneNlMaterialized, nameInSource=null, uuid=tid:97ebf59784d5-b8a1140b-00000000})
        Source(groups=[VodafoneNlMaterialized.status])


============================================================================
EXECUTING AssignOutputElements

AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=[mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION')]})
  Project(groups=[VodafoneNlMaterialized.status], props={PROJECT_COLS=[mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION')], OUTPUT_COLS=[mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION')]})
    Join(groups=[x, VodafoneNlMaterialized.status], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[VDBName = 'CountryServiceListVDB', VDBVersion = '1', SchemaName = 'VodafoneNl', Name = 'vodafone_nl'], OUTPUT_COLS=[Valid, LoadState]})
      Source(groups=[x], props={NESTED_COMMAND=SELECT 1, SYMBOL_MAP={}, OUTPUT_COLS=[]})
        Project(groups=[], props={PROJECT_COLS=[], OUTPUT_COLS=[]})
      Access(groups=[VodafoneNlMaterialized.status], props={SOURCE_HINT=null, MODEL_ID=Schema name=VodafoneNlMaterialized, nameInSource=null, uuid=tid:97ebf59784d5-b8a1140b-00000000, OUTPUT_COLS=[VDBName, VDBVersion, SchemaName, Name, Valid, LoadState]})
        Source(groups=[VodafoneNlMaterialized.status], props={OUTPUT_COLS=[VDBName, VDBVersion, SchemaName, Name, Valid, LoadState]})


============================================================================
EXECUTING RemoveOptionalJoins

AFTER:
TupleLimit(groups=[])
  Project(groups=[VodafoneNlMaterialized.status])
    Join(groups=[x, VodafoneNlMaterialized.status], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[VDBName = 'CountryServiceListVDB', VDBVersion = '1', SchemaName = 'VodafoneNl', Name = 'vodafone_nl'], OUTPUT_COLS=[Valid, LoadState]})
      Source(groups=[x])
        Project(groups=[])
      Access(groups=[VodafoneNlMaterialized.status])
        Source(groups=[VodafoneNlMaterialized.status])


============================================================================
EXECUTING MergeVirtual

AFTER:
TupleLimit(groups=[])
  Project(groups=[VodafoneNlMaterialized.status])
    Join(groups=[x, VodafoneNlMaterialized.status], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[VDBName = 'CountryServiceListVDB', VDBVersion = '1', SchemaName = 'VodafoneNl', Name = 'vodafone_nl'], OUTPUT_COLS=[Valid, LoadState]})
      Source(groups=[x], props={NESTED_COMMAND=SELECT 1, SYMBOL_MAP={}, OUTPUT_COLS=[]})
        Project(groups=[])
      Access(groups=[VodafoneNlMaterialized.status])
        Source(groups=[VodafoneNlMaterialized.status])


============================================================================
EXECUTING PushNonJoinCriteria

AFTER:
TupleLimit(groups=[])
  Project(groups=[VodafoneNlMaterialized.status])
    Join(groups=[x, VodafoneNlMaterialized.status], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=[Valid, LoadState]})
      Source(groups=[x])
        Project(groups=[])
      Select(groups=[VodafoneNlMaterialized.status], props={SELECT_CRITERIA=Name = 'vodafone_nl'})
        Select(groups=[VodafoneNlMaterialized.status], props={SELECT_CRITERIA=SchemaName = 'VodafoneNl'})
          Select(groups=[VodafoneNlMaterialized.status], props={SELECT_CRITERIA=VDBVersion = '1'})
            Select(groups=[VodafoneNlMaterialized.status], props={SELECT_CRITERIA=VDBName = 'CountryServiceListVDB'})
              Access(groups=[VodafoneNlMaterialized.status], props={SOURCE_HINT=null, MODEL_ID=Schema name=VodafoneNlMaterialized, nameInSource=null, uuid=tid:97ebf59784d5-b8a1140b-00000000, OUTPUT_COLS=[VDBName, VDBVersion, SchemaName, Name, Valid, LoadState]})
                Source(groups=[VodafoneNlMaterialized.status])


============================================================================
EXECUTING PushSelectCriteria

AFTER:
TupleLimit(groups=[])
  Project(groups=[VodafoneNlMaterialized.status])
    Join(groups=[x, VodafoneNlMaterialized.status], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=[Valid, LoadState]})
      Source(groups=[x])
        Project(groups=[])
      Access(groups=[VodafoneNlMaterialized.status], props={SOURCE_HINT=null, MODEL_ID=Schema name=VodafoneNlMaterialized, nameInSource=null, uuid=tid:97ebf59784d5-b8a1140b-00000000, OUTPUT_COLS=[VDBName, VDBVersion, SchemaName, Name, Valid, LoadState]})
        Select(groups=[VodafoneNlMaterialized.status], props={SELECT_CRITERIA=(VDBName = 'CountryServiceListVDB') AND (VDBVersion = '1') AND (SchemaName = 'VodafoneNl') AND (Name = 'vodafone_nl')})
          Source(groups=[VodafoneNlMaterialized.status], props={OUTPUT_COLS=[VDBName, VDBVersion, SchemaName, Name, Valid, LoadState]})


============================================================================
EXECUTING CleanCriteria

AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=null})
  Project(groups=[VodafoneNlMaterialized.status], props={PROJECT_COLS=[mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION')], OUTPUT_COLS=null})
    Join(groups=[x, VodafoneNlMaterialized.status], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=null})
      Source(groups=[x], props={NESTED_COMMAND=SELECT 1, SYMBOL_MAP={}, OUTPUT_COLS=null})
        Project(groups=[], props={PROJECT_COLS=[], OUTPUT_COLS=null})
      Access(groups=[VodafoneNlMaterialized.status], props={SOURCE_HINT=null, MODEL_ID=Schema name=VodafoneNlMaterialized, nameInSource=null, uuid=tid:97ebf59784d5-b8a1140b-00000000, OUTPUT_COLS=null})
        Select(groups=[VodafoneNlMaterialized.status], props={SELECT_CRITERIA=(VDBName = 'CountryServiceListVDB') AND (VDBVersion = '1') AND (SchemaName = 'VodafoneNl') AND (Name = 'vodafone_nl'), OUTPUT_COLS=null})
          Source(groups=[VodafoneNlMaterialized.status], props={OUTPUT_COLS=null})


============================================================================
EXECUTING RaiseAccess

AFTER:
TupleLimit(groups=[])
  Project(groups=[VodafoneNlMaterialized.status])
    Join(groups=[x, VodafoneNlMaterialized.status], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=null})
      Source(groups=[x])
        Project(groups=[])
      Access(groups=[VodafoneNlMaterialized.status], props={SOURCE_HINT=null, MODEL_ID=Schema name=VodafoneNlMaterialized, nameInSource=null, uuid=tid:97ebf59784d5-b8a1140b-00000000, OUTPUT_COLS=null})
        Select(groups=[VodafoneNlMaterialized.status])
          Source(groups=[VodafoneNlMaterialized.status])


============================================================================
EXECUTING CopyCriteria

AFTER:
TupleLimit(groups=[])
  Project(groups=[VodafoneNlMaterialized.status])
    Join(groups=[x, VodafoneNlMaterialized.status], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=null, IS_COPIED=true})
      Source(groups=[x])
        Project(groups=[])
      Access(groups=[VodafoneNlMaterialized.status])
        Select(groups=[VodafoneNlMaterialized.status], props={SELECT_CRITERIA=(VDBName = 'CountryServiceListVDB') AND (VDBVersion = '1') AND (SchemaName = 'VodafoneNl') AND (Name = 'vodafone_nl'), OUTPUT_COLS=null, IS_COPIED=true})
          Source(groups=[VodafoneNlMaterialized.status])


============================================================================
EXECUTING CleanCriteria

AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=null})
  Project(groups=[VodafoneNlMaterialized.status], props={PROJECT_COLS=[mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION')], OUTPUT_COLS=null})
    Join(groups=[x, VodafoneNlMaterialized.status], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=null, IS_COPIED=true})
      Source(groups=[x], props={NESTED_COMMAND=SELECT 1, SYMBOL_MAP={}, OUTPUT_COLS=null})
        Project(groups=[], props={PROJECT_COLS=[], OUTPUT_COLS=null})
      Access(groups=[VodafoneNlMaterialized.status], props={SOURCE_HINT=null, MODEL_ID=Schema name=VodafoneNlMaterialized, nameInSource=null, uuid=tid:97ebf59784d5-b8a1140b-00000000, OUTPUT_COLS=null})
        Select(groups=[VodafoneNlMaterialized.status], props={SELECT_CRITERIA=(VDBName = 'CountryServiceListVDB') AND (VDBVersion = '1') AND (SchemaName = 'VodafoneNl') AND (Name = 'vodafone_nl'), OUTPUT_COLS=null, IS_COPIED=true})
          Source(groups=[VodafoneNlMaterialized.status], props={OUTPUT_COLS=null})


============================================================================
EXECUTING PlanJoins

AFTER:
TupleLimit(groups=[])
  Project(groups=[VodafoneNlMaterialized.status])
    Join(groups=[x, VodafoneNlMaterialized.status], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=null, IS_COPIED=true})
      Source(groups=[x])
        Project(groups=[])
      Access(groups=[VodafoneNlMaterialized.status])
        Select(groups=[VodafoneNlMaterialized.status])
          Source(groups=[VodafoneNlMaterialized.status])


============================================================================
EXECUTING PushSelectCriteria

AFTER:
TupleLimit(groups=[])
  Project(groups=[VodafoneNlMaterialized.status])
    Join(groups=[x, VodafoneNlMaterialized.status])
      Source(groups=[x])
        Project(groups=[])
      Access(groups=[VodafoneNlMaterialized.status])
        Select(groups=[VodafoneNlMaterialized.status], props={SELECT_CRITERIA=(VDBName = 'CountryServiceListVDB') AND (VDBVersion = '1') AND (SchemaName = 'VodafoneNl') AND (Name = 'vodafone_nl'), OUTPUT_COLS=null, IS_COPIED=true})
          Source(groups=[VodafoneNlMaterialized.status])


============================================================================
EXECUTING RaiseAccess

AFTER:
TupleLimit(groups=[])
  Project(groups=[VodafoneNlMaterialized.status])
    Join(groups=[x, VodafoneNlMaterialized.status], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=null, IS_COPIED=true})
      Source(groups=[x])
        Project(groups=[])
      Access(groups=[VodafoneNlMaterialized.status], props={SOURCE_HINT=null, MODEL_ID=Schema name=VodafoneNlMaterialized, nameInSource=null, uuid=tid:97ebf59784d5-b8a1140b-00000000, OUTPUT_COLS=null})
        Select(groups=[VodafoneNlMaterialized.status])
          Source(groups=[VodafoneNlMaterialized.status])


============================================================================
EXECUTING PlanOuterJoins

AFTER:
TupleLimit(groups=[])
  Project(groups=[VodafoneNlMaterialized.status])
    Join(groups=[x, VodafoneNlMaterialized.status], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=null, IS_COPIED=true})
      Source(groups=[x])
        Project(groups=[])
      Access(groups=[VodafoneNlMaterialized.status])
        Select(groups=[VodafoneNlMaterialized.status])
          Source(groups=[VodafoneNlMaterialized.status])


============================================================================
EXECUTING ChooseJoinStrategy

AFTER:
TupleLimit(groups=[])
  Project(groups=[VodafoneNlMaterialized.status])
    Join(groups=[x, VodafoneNlMaterialized.status], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=null, IS_COPIED=true})
      Source(groups=[x])
        Project(groups=[])
      Access(groups=[VodafoneNlMaterialized.status])
        Select(groups=[VodafoneNlMaterialized.status])
          Source(groups=[VodafoneNlMaterialized.status])


============================================================================
EXECUTING ChooseDependent
LOW [Relational Planner] parent join has has no join criteria - Rejecting dependent join Source(groups=[x], props={NESTED_COMMAND=SELECT 1, SYMBOL_MAP={}, OUTPUT_COLS=null}
LOW [Relational Planner] parent join has has no join criteria - Rejecting dependent join Access(groups=[VodafoneNlMaterialized.status], props={SOURCE_HINT=null, MODEL_ID=Schema name=VodafoneNlMaterialized, nameInSource=null, uuid=tid:97ebf59784d5-b8a1140b-00000000, OUTPUT_COLS=null}

AFTER:
TupleLimit(groups=[])
  Project(groups=[VodafoneNlMaterialized.status])
    Join(groups=[x, VodafoneNlMaterialized.status], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=null, IS_COPIED=true})
      Source(groups=[x])
        Project(groups=[])
      Access(groups=[VodafoneNlMaterialized.status])
        Select(groups=[VodafoneNlMaterialized.status])
          Source(groups=[VodafoneNlMaterialized.status])


============================================================================
EXECUTING AssignOutputElements

AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=[mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION')]})
  Project(groups=[VodafoneNlMaterialized.status], props={PROJECT_COLS=[mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION')], OUTPUT_COLS=[mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION')]})
    Join(groups=[x, VodafoneNlMaterialized.status], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=[Valid, LoadState], IS_COPIED=true})
      Source(groups=[x], props={NESTED_COMMAND=SELECT 1, SYMBOL_MAP={}, OUTPUT_COLS=[]})
        Project(groups=[], props={PROJECT_COLS=[], OUTPUT_COLS=[]})
      Access(groups=[VodafoneNlMaterialized.status], props={SOURCE_HINT=null, MODEL_ID=Schema name=VodafoneNlMaterialized, nameInSource=null, uuid=tid:97ebf59784d5-b8a1140b-00000000, OUTPUT_COLS=[Valid, LoadState]})
        Select(groups=[VodafoneNlMaterialized.status], props={SELECT_CRITERIA=(VDBName = 'CountryServiceListVDB') AND (VDBVersion = '1') AND (SchemaName = 'VodafoneNl') AND (Name = 'vodafone_nl'), OUTPUT_COLS=[Valid, LoadState], IS_COPIED=true})
          Source(groups=[VodafoneNlMaterialized.status], props={OUTPUT_COLS=[VDBName, VDBVersion, SchemaName, Name, Valid, LoadState]})


============================================================================
EXECUTING PushLimit

AFTER:
Project(groups=[VodafoneNlMaterialized.status], props={PROJECT_COLS=[mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION')], OUTPUT_COLS=[mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION')], SOURCE_HINT=null})
  TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=[Valid, LoadState]})
    Join(groups=[x, VodafoneNlMaterialized.status], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=[Valid, LoadState], IS_COPIED=true})
      Source(groups=[x], props={NESTED_COMMAND=SELECT 1, SYMBOL_MAP={}, OUTPUT_COLS=[], SOURCE_HINT=null})
        TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, OUTPUT_COLS=[]})
          Project(groups=[], props={PROJECT_COLS=[], OUTPUT_COLS=[]})
      Access(groups=[VodafoneNlMaterialized.status])
        Select(groups=[VodafoneNlMaterialized.status])
          Source(groups=[VodafoneNlMaterialized.status])


============================================================================
EXECUTING CalculateCost

AFTER:
Project(groups=[VodafoneNlMaterialized.status], props={PROJECT_COLS=[mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION')], OUTPUT_COLS=[mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION')], SOURCE_HINT=null, EST_CARDINALITY=1.0, EST_COL_STATS={mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION')=[1.0, 1.0, 1.0]}})
  TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=[Valid, LoadState], EST_CARDINALITY=1.0, EST_COL_STATS={Valid=[1.0, 1.0, 1.0], LoadState=[1.0, 1.0, 1.0]}})
    Join(groups=[x, VodafoneNlMaterialized.status], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=[Valid, LoadState], IS_COPIED=true, EST_CARDINALITY=1.0, EST_COL_STATS={Valid=[1.0, 1.0, 1.0], LoadState=[1.0, 1.0, 1.0]}})
      Source(groups=[x], props={NESTED_COMMAND=SELECT 1, SYMBOL_MAP={}, OUTPUT_COLS=[], SOURCE_HINT=null, EST_CARDINALITY=1.0, EST_COL_STATS={}})
        TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, OUTPUT_COLS=[], EST_CARDINALITY=1.0, EST_COL_STATS={}})
          Project(groups=[], props={PROJECT_COLS=[], OUTPUT_COLS=[], EST_CARDINALITY=1.0, EST_COL_STATS={}})
      Access(groups=[VodafoneNlMaterialized.status], props={SOURCE_HINT=null, MODEL_ID=Schema name=VodafoneNlMaterialized, nameInSource=null, uuid=tid:97ebf59784d5-b8a1140b-00000000, OUTPUT_COLS=[Valid, LoadState], EST_CARDINALITY=1.0, EST_COL_STATS={Valid=[1.0, 1.0, 1.0], LoadState=[1.0, 1.0, 1.0]}})
        Select(groups=[VodafoneNlMaterialized.status], props={SELECT_CRITERIA=(VDBName = 'CountryServiceListVDB') AND (VDBVersion = '1') AND (SchemaName = 'VodafoneNl') AND (Name = 'vodafone_nl'), OUTPUT_COLS=[Valid, LoadState], IS_COPIED=true, EST_CARDINALITY=1.0, EST_COL_STATS={Valid=[1.0, 1.0, 0.0], LoadState=[1.0, 1.0, 0.0]}})
          Source(groups=[VodafoneNlMaterialized.status], props={OUTPUT_COLS=[VDBName, VDBVersion, SchemaName, Name, Valid, LoadState], EST_COL_STATS={VDBName=[-1.0, -1.0, -1.0], VDBVersion=[-1.0, -1.0, -1.0], SchemaName=[-1.0, -1.0, -1.0], Name=[-1.0, -1.0, -1.0], ...}, EST_CARDINALITY=-1.0})


============================================================================
EXECUTING ImplementJoinStrategy

AFTER:
Project(groups=[VodafoneNlMaterialized.status])
  TupleLimit(groups=[])
    Join(groups=[x, VodafoneNlMaterialized.status], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=[Valid, LoadState], IS_COPIED=true, EST_CARDINALITY=1.0, EST_COL_STATS={Valid=[1.0, 1.0, 1.0], LoadState=[1.0, 1.0, 1.0]}})
      Source(groups=[x])
        TupleLimit(groups=[])
          Project(groups=[])
      Access(groups=[VodafoneNlMaterialized.status])
        Select(groups=[VodafoneNlMaterialized.status])
          Source(groups=[VodafoneNlMaterialized.status])


============================================================================
EXECUTING MergeCriteria

AFTER:
Project(groups=[VodafoneNlMaterialized.status])
  TupleLimit(groups=[])
    Join(groups=[x, VodafoneNlMaterialized.status])
      Source(groups=[x])
        TupleLimit(groups=[])
          Project(groups=[])
      Access(groups=[VodafoneNlMaterialized.status])
        Select(groups=[VodafoneNlMaterialized.status])
          Source(groups=[VodafoneNlMaterialized.status])


============================================================================
EXECUTING PlanSorts

AFTER:
Project(groups=[VodafoneNlMaterialized.status])
  TupleLimit(groups=[])
    Join(groups=[x, VodafoneNlMaterialized.status], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=[Valid, LoadState], IS_COPIED=true, EST_CARDINALITY=1.0, EST_COL_STATS={Valid=[1.0, 1.0, 1.0], LoadState=[1.0, 1.0, 1.0]}})
      Source(groups=[x])
        TupleLimit(groups=[])
          Project(groups=[])
      Access(groups=[VodafoneNlMaterialized.status])
        Select(groups=[VodafoneNlMaterialized.status])
          Source(groups=[VodafoneNlMaterialized.status])


============================================================================
EXECUTING CollapseSource

AFTER:
Project(groups=[VodafoneNlMaterialized.status])
  TupleLimit(groups=[])
    Join(groups=[x, VodafoneNlMaterialized.status])
      Source(groups=[x])
        TupleLimit(groups=[])
          Project(groups=[])
      Access(groups=[VodafoneNlMaterialized.status], props={SOURCE_HINT=null, MODEL_ID=Schema name=VodafoneNlMaterialized, nameInSource=null, uuid=tid:97ebf59784d5-b8a1140b-00000000, OUTPUT_COLS=[Valid, LoadState], EST_CARDINALITY=1.0, EST_COL_STATS={Valid=[1.0, 1.0, 1.0], LoadState=[1.0, 1.0, 1.0]}, ATOMIC_REQUEST=SELECT Valid, LoadState FROM VodafoneNlMaterialized.status WHERE (VDBName = 'CountryServiceListVDB') AND (VDBVersion = '1') AND (SchemaName = 'VodafoneNl') AND (Name = 'vodafone_nl')})


============================================================================
CONVERTING PLAN TREE TO PROCESS TREE

PROCESS PLAN =
ProjectNode(1) output=[mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION')] [mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION')]
  LimitNode(2) output=[Valid, LoadState] limit 2
    JoinNode(3) [NESTED LOOP JOIN] [LEFT OUTER JOIN] criteria=[] output=[Valid, LoadState]
      LimitNode(4) output=[] limit 2
        ProjectNode(5) output=[] []
      AccessNode(6) output=[Valid, LoadState] SELECT g_0.Valid, g_0.LoadState FROM VodafoneNlMaterialized.status AS g_0 WHERE (g_0.VDBName = 'CountryServiceListVDB') AND (g_0.VDBVersion = '1') AND (g_0.SchemaName = 'VodafoneNl') AND (g_0.Name = 'vodafone_nl')

============================================================================

----------------------------------------------------------------------------
OPTIMIZATION COMPLETE:
PROCESSOR PLAN:
ProjectNode(1) output=[mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION')] [mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION')]
  LimitNode(2) output=[Valid, LoadState] limit 2
    JoinNode(3) [NESTED LOOP JOIN] [LEFT OUTER JOIN] criteria=[] output=[Valid, LoadState]
      LimitNode(4) output=[] limit 2
        ProjectNode(5) output=[] []
      AccessNode(6) output=[Valid, LoadState] SELECT g_0.Valid, g_0.LoadState FROM VodafoneNlMaterialized.status AS g_0 WHERE (g_0.VDBName = 'CountryServiceListVDB') AND (g_0.VDBVersion = '1') AND (g_0.SchemaName = 'VodafoneNl') AND (g_0.Name = 'vodafone_nl')

============================================================================

----------------------------------------------------------------------------
OPTIMIZE:
SELECT mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN NumberingPlanMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'NumberingPlan' AND Name = 'numbering_plan' LIMIT 2

----------------------------------------------------------------------------
GENERATE CANONICAL:
SELECT mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN NumberingPlanMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'NumberingPlan' AND Name = 'numbering_plan' LIMIT 2

CANONICAL PLAN:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true})
  Project(groups=[NumberingPlanMaterialized.status], props={PROJECT_COLS=[mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION')]})
    Join(groups=[x, NumberingPlanMaterialized.status], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[VDBName = 'CountryServiceListVDB', VDBVersion = '1', SchemaName = 'NumberingPlan', Name = 'numbering_plan']})
      Source(groups=[x], props={NESTED_COMMAND=SELECT 1, SYMBOL_MAP={x.expr1=1}})
        Project(groups=[], props={PROJECT_COLS=[1]})
      Source(groups=[NumberingPlanMaterialized.status])


============================================================================
EXECUTING PlaceAccess

AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true})
  Project(groups=[NumberingPlanMaterialized.status], props={PROJECT_COLS=[mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION')]})
    Join(groups=[NumberingPlanMaterialized.status, x AS x__1], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[VDBName = 'CountryServiceListVDB', VDBVersion = '1', SchemaName = 'NumberingPlan', Name = 'numbering_plan']})
      Source(groups=[x AS x__1], props={NESTED_COMMAND=SELECT 1, SYMBOL_MAP={x__1.expr1=1}})
        Project(groups=[], props={PROJECT_COLS=[1]})
      Access(groups=[NumberingPlanMaterialized.status], props={SOURCE_HINT=null, MODEL_ID=Schema name=NumberingPlanMaterialized, nameInSource=null, uuid=tid:f41d3bd875ef-f14912f9-00000000})
        Source(groups=[NumberingPlanMaterialized.status])


============================================================================
EXECUTING AssignOutputElements

AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=[mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION')]})
  Project(groups=[NumberingPlanMaterialized.status], props={PROJECT_COLS=[mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION')], OUTPUT_COLS=[mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION')]})
    Join(groups=[NumberingPlanMaterialized.status, x AS x__1], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[VDBName = 'CountryServiceListVDB', VDBVersion = '1', SchemaName = 'NumberingPlan', Name = 'numbering_plan'], OUTPUT_COLS=[Valid, LoadState]})
      Source(groups=[x AS x__1], props={NESTED_COMMAND=SELECT 1, SYMBOL_MAP={}, OUTPUT_COLS=[]})
        Project(groups=[], props={PROJECT_COLS=[], OUTPUT_COLS=[]})
      Access(groups=[NumberingPlanMaterialized.status], props={SOURCE_HINT=null, MODEL_ID=Schema name=NumberingPlanMaterialized, nameInSource=null, uuid=tid:f41d3bd875ef-f14912f9-00000000, OUTPUT_COLS=[VDBName, VDBVersion, SchemaName, Name, Valid, LoadState]})
        Source(groups=[NumberingPlanMaterialized.status], props={OUTPUT_COLS=[VDBName, VDBVersion, SchemaName, Name, Valid, LoadState]})


============================================================================
EXECUTING RemoveOptionalJoins

AFTER:
TupleLimit(groups=[])
  Project(groups=[NumberingPlanMaterialized.status])
    Join(groups=[NumberingPlanMaterialized.status, x AS x__1], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[VDBName = 'CountryServiceListVDB', VDBVersion = '1', SchemaName = 'NumberingPlan', Name = 'numbering_plan'], OUTPUT_COLS=[Valid, LoadState]})
      Source(groups=[x AS x__1])
        Project(groups=[])
      Access(groups=[NumberingPlanMaterialized.status])
        Source(groups=[NumberingPlanMaterialized.status])


============================================================================
EXECUTING MergeVirtual

AFTER:
TupleLimit(groups=[])
  Project(groups=[NumberingPlanMaterialized.status])
    Join(groups=[NumberingPlanMaterialized.status, x AS x__1], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[VDBName = 'CountryServiceListVDB', VDBVersion = '1', SchemaName = 'NumberingPlan', Name = 'numbering_plan'], OUTPUT_COLS=[Valid, LoadState]})
      Source(groups=[x AS x__1], props={NESTED_COMMAND=SELECT 1, SYMBOL_MAP={}, OUTPUT_COLS=[]})
        Project(groups=[])
      Access(groups=[NumberingPlanMaterialized.status])
        Source(groups=[NumberingPlanMaterialized.status])


============================================================================
EXECUTING PushNonJoinCriteria

AFTER:
TupleLimit(groups=[])
  Project(groups=[NumberingPlanMaterialized.status])
    Join(groups=[NumberingPlanMaterialized.status, x AS x__1], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=[Valid, LoadState]})
      Source(groups=[x AS x__1])
        Project(groups=[])
      Select(groups=[NumberingPlanMaterialized.status], props={SELECT_CRITERIA=Name = 'numbering_plan'})
        Select(groups=[NumberingPlanMaterialized.status], props={SELECT_CRITERIA=SchemaName = 'NumberingPlan'})
          Select(groups=[NumberingPlanMaterialized.status], props={SELECT_CRITERIA=VDBVersion = '1'})
            Select(groups=[NumberingPlanMaterialized.status], props={SELECT_CRITERIA=VDBName = 'CountryServiceListVDB'})
              Access(groups=[NumberingPlanMaterialized.status], props={SOURCE_HINT=null, MODEL_ID=Schema name=NumberingPlanMaterialized, nameInSource=null, uuid=tid:f41d3bd875ef-f14912f9-00000000, OUTPUT_COLS=[VDBName, VDBVersion, SchemaName, Name, Valid, LoadState]})
                Source(groups=[NumberingPlanMaterialized.status])


============================================================================
EXECUTING PushSelectCriteria

AFTER:
TupleLimit(groups=[])
  Project(groups=[NumberingPlanMaterialized.status])
    Join(groups=[NumberingPlanMaterialized.status, x AS x__1], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=[Valid, LoadState]})
      Source(groups=[x AS x__1])
        Project(groups=[])
      Access(groups=[NumberingPlanMaterialized.status], props={SOURCE_HINT=null, MODEL_ID=Schema name=NumberingPlanMaterialized, nameInSource=null, uuid=tid:f41d3bd875ef-f14912f9-00000000, OUTPUT_COLS=[VDBName, VDBVersion, SchemaName, Name, Valid, LoadState]})
        Select(groups=[NumberingPlanMaterialized.status], props={SELECT_CRITERIA=(VDBName = 'CountryServiceListVDB') AND (VDBVersion = '1') AND (SchemaName = 'NumberingPlan') AND (Name = 'numbering_plan')})
          Source(groups=[NumberingPlanMaterialized.status], props={OUTPUT_COLS=[VDBName, VDBVersion, SchemaName, Name, Valid, LoadState]})


============================================================================
EXECUTING CleanCriteria

AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=null})
  Project(groups=[NumberingPlanMaterialized.status], props={PROJECT_COLS=[mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION')], OUTPUT_COLS=null})
    Join(groups=[NumberingPlanMaterialized.status, x AS x__1], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=null})
      Source(groups=[x AS x__1], props={NESTED_COMMAND=SELECT 1, SYMBOL_MAP={}, OUTPUT_COLS=null})
        Project(groups=[], props={PROJECT_COLS=[], OUTPUT_COLS=null})
      Access(groups=[NumberingPlanMaterialized.status], props={SOURCE_HINT=null, MODEL_ID=Schema name=NumberingPlanMaterialized, nameInSource=null, uuid=tid:f41d3bd875ef-f14912f9-00000000, OUTPUT_COLS=null})
        Select(groups=[NumberingPlanMaterialized.status], props={SELECT_CRITERIA=(VDBName = 'CountryServiceListVDB') AND (VDBVersion = '1') AND (SchemaName = 'NumberingPlan') AND (Name = 'numbering_plan'), OUTPUT_COLS=null})
          Source(groups=[NumberingPlanMaterialized.status], props={OUTPUT_COLS=null})


============================================================================
EXECUTING RaiseAccess

AFTER:
TupleLimit(groups=[])
  Project(groups=[NumberingPlanMaterialized.status])
    Join(groups=[NumberingPlanMaterialized.status, x AS x__1], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=null})
      Source(groups=[x AS x__1])
        Project(groups=[])
      Access(groups=[NumberingPlanMaterialized.status], props={SOURCE_HINT=null, MODEL_ID=Schema name=NumberingPlanMaterialized, nameInSource=null, uuid=tid:f41d3bd875ef-f14912f9-00000000, OUTPUT_COLS=null})
        Select(groups=[NumberingPlanMaterialized.status])
          Source(groups=[NumberingPlanMaterialized.status])


============================================================================
EXECUTING CopyCriteria

AFTER:
TupleLimit(groups=[])
  Project(groups=[NumberingPlanMaterialized.status])
    Join(groups=[NumberingPlanMaterialized.status, x AS x__1], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=null, IS_COPIED=true})
      Source(groups=[x AS x__1])
        Project(groups=[])
      Access(groups=[NumberingPlanMaterialized.status])
        Select(groups=[NumberingPlanMaterialized.status], props={SELECT_CRITERIA=(VDBName = 'CountryServiceListVDB') AND (VDBVersion = '1') AND (SchemaName = 'NumberingPlan') AND (Name = 'numbering_plan'), OUTPUT_COLS=null, IS_COPIED=true})
          Source(groups=[NumberingPlanMaterialized.status])


============================================================================
EXECUTING CleanCriteria

AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=null})
  Project(groups=[NumberingPlanMaterialized.status], props={PROJECT_COLS=[mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION')], OUTPUT_COLS=null})
    Join(groups=[NumberingPlanMaterialized.status, x AS x__1], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=null, IS_COPIED=true})
      Source(groups=[x AS x__1], props={NESTED_COMMAND=SELECT 1, SYMBOL_MAP={}, OUTPUT_COLS=null})
        Project(groups=[], props={PROJECT_COLS=[], OUTPUT_COLS=null})
      Access(groups=[NumberingPlanMaterialized.status], props={SOURCE_HINT=null, MODEL_ID=Schema name=NumberingPlanMaterialized, nameInSource=null, uuid=tid:f41d3bd875ef-f14912f9-00000000, OUTPUT_COLS=null})
        Select(groups=[NumberingPlanMaterialized.status], props={SELECT_CRITERIA=(VDBName = 'CountryServiceListVDB') AND (VDBVersion = '1') AND (SchemaName = 'NumberingPlan') AND (Name = 'numbering_plan'), OUTPUT_COLS=null, IS_COPIED=true})
          Source(groups=[NumberingPlanMaterialized.status], props={OUTPUT_COLS=null})


============================================================================
EXECUTING PlanJoins

AFTER:
TupleLimit(groups=[])
  Project(groups=[NumberingPlanMaterialized.status])
    Join(groups=[NumberingPlanMaterialized.status, x AS x__1], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=null, IS_COPIED=true})
      Source(groups=[x AS x__1])
        Project(groups=[])
      Access(groups=[NumberingPlanMaterialized.status])
        Select(groups=[NumberingPlanMaterialized.status])
          Source(groups=[NumberingPlanMaterialized.status])


============================================================================
EXECUTING PushSelectCriteria

AFTER:
TupleLimit(groups=[])
  Project(groups=[NumberingPlanMaterialized.status])
    Join(groups=[NumberingPlanMaterialized.status, x AS x__1])
      Source(groups=[x AS x__1])
        Project(groups=[])
      Access(groups=[NumberingPlanMaterialized.status])
        Select(groups=[NumberingPlanMaterialized.status], props={SELECT_CRITERIA=(VDBName = 'CountryServiceListVDB') AND (VDBVersion = '1') AND (SchemaName = 'NumberingPlan') AND (Name = 'numbering_plan'), OUTPUT_COLS=null, IS_COPIED=true})
          Source(groups=[NumberingPlanMaterialized.status])


============================================================================
EXECUTING RaiseAccess

AFTER:
TupleLimit(groups=[])
  Project(groups=[NumberingPlanMaterialized.status])
    Join(groups=[NumberingPlanMaterialized.status, x AS x__1], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=null, IS_COPIED=true})
      Source(groups=[x AS x__1])
        Project(groups=[])
      Access(groups=[NumberingPlanMaterialized.status], props={SOURCE_HINT=null, MODEL_ID=Schema name=NumberingPlanMaterialized, nameInSource=null, uuid=tid:f41d3bd875ef-f14912f9-00000000, OUTPUT_COLS=null})
        Select(groups=[NumberingPlanMaterialized.status])
          Source(groups=[NumberingPlanMaterialized.status])


============================================================================
EXECUTING PlanOuterJoins

AFTER:
TupleLimit(groups=[])
  Project(groups=[NumberingPlanMaterialized.status])
    Join(groups=[NumberingPlanMaterialized.status, x AS x__1], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=null, IS_COPIED=true})
      Source(groups=[x AS x__1])
        Project(groups=[])
      Access(groups=[NumberingPlanMaterialized.status])
        Select(groups=[NumberingPlanMaterialized.status])
          Source(groups=[NumberingPlanMaterialized.status])


============================================================================
EXECUTING ChooseJoinStrategy

AFTER:
TupleLimit(groups=[])
  Project(groups=[NumberingPlanMaterialized.status])
    Join(groups=[NumberingPlanMaterialized.status, x AS x__1], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=null, IS_COPIED=true})
      Source(groups=[x AS x__1])
        Project(groups=[])
      Access(groups=[NumberingPlanMaterialized.status])
        Select(groups=[NumberingPlanMaterialized.status])
          Source(groups=[NumberingPlanMaterialized.status])


============================================================================
EXECUTING ChooseDependent
LOW [Relational Planner] parent join has has no join criteria - Rejecting dependent join Source(groups=[x AS x__1], props={NESTED_COMMAND=SELECT 1, SYMBOL_MAP={}, OUTPUT_COLS=null}
LOW [Relational Planner] parent join has has no join criteria - Rejecting dependent join Access(groups=[NumberingPlanMaterialized.status], props={SOURCE_HINT=null, MODEL_ID=Schema name=NumberingPlanMaterialized, nameInSource=null, uuid=tid:f41d3bd875ef-f14912f9-00000000, OUTPUT_COLS=null}

AFTER:
TupleLimit(groups=[])
  Project(groups=[NumberingPlanMaterialized.status])
    Join(groups=[NumberingPlanMaterialized.status, x AS x__1], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=null, IS_COPIED=true})
      Source(groups=[x AS x__1])
        Project(groups=[])
      Access(groups=[NumberingPlanMaterialized.status])
        Select(groups=[NumberingPlanMaterialized.status])
          Source(groups=[NumberingPlanMaterialized.status])


============================================================================
EXECUTING AssignOutputElements

AFTER:
TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=[mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION')]})
  Project(groups=[NumberingPlanMaterialized.status], props={PROJECT_COLS=[mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION')], OUTPUT_COLS=[mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION')]})
    Join(groups=[NumberingPlanMaterialized.status, x AS x__1], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=[Valid, LoadState], IS_COPIED=true})
      Source(groups=[x AS x__1], props={NESTED_COMMAND=SELECT 1, SYMBOL_MAP={}, OUTPUT_COLS=[]})
        Project(groups=[], props={PROJECT_COLS=[], OUTPUT_COLS=[]})
      Access(groups=[NumberingPlanMaterialized.status], props={SOURCE_HINT=null, MODEL_ID=Schema name=NumberingPlanMaterialized, nameInSource=null, uuid=tid:f41d3bd875ef-f14912f9-00000000, OUTPUT_COLS=[Valid, LoadState]})
        Select(groups=[NumberingPlanMaterialized.status], props={SELECT_CRITERIA=(VDBName = 'CountryServiceListVDB') AND (VDBVersion = '1') AND (SchemaName = 'NumberingPlan') AND (Name = 'numbering_plan'), OUTPUT_COLS=[Valid, LoadState], IS_COPIED=true})
          Source(groups=[NumberingPlanMaterialized.status], props={OUTPUT_COLS=[VDBName, VDBVersion, SchemaName, Name, Valid, LoadState]})


============================================================================
EXECUTING PushLimit

AFTER:
Project(groups=[NumberingPlanMaterialized.status], props={PROJECT_COLS=[mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION')], OUTPUT_COLS=[mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION')], SOURCE_HINT=null})
  TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=[Valid, LoadState]})
    Join(groups=[NumberingPlanMaterialized.status, x AS x__1], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=[Valid, LoadState], IS_COPIED=true})
      Source(groups=[x AS x__1], props={NESTED_COMMAND=SELECT 1, SYMBOL_MAP={}, OUTPUT_COLS=[], SOURCE_HINT=null})
        TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, OUTPUT_COLS=[]})
          Project(groups=[], props={PROJECT_COLS=[], OUTPUT_COLS=[]})
      Access(groups=[NumberingPlanMaterialized.status])
        Select(groups=[NumberingPlanMaterialized.status])
          Source(groups=[NumberingPlanMaterialized.status])


============================================================================
EXECUTING CalculateCost

AFTER:
Project(groups=[NumberingPlanMaterialized.status], props={PROJECT_COLS=[mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION')], OUTPUT_COLS=[mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION')], SOURCE_HINT=null, EST_CARDINALITY=1.0, EST_COL_STATS={mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION')=[1.0, 1.0, 1.0]}})
  TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, IS_IMPLICIT_LIMIT=true, OUTPUT_COLS=[Valid, LoadState], EST_CARDINALITY=1.0, EST_COL_STATS={Valid=[1.0, 1.0, 1.0], LoadState=[1.0, 1.0, 1.0]}})
    Join(groups=[NumberingPlanMaterialized.status, x AS x__1], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=[Valid, LoadState], IS_COPIED=true, EST_CARDINALITY=1.0, EST_COL_STATS={Valid=[1.0, 1.0, 1.0], LoadState=[1.0, 1.0, 1.0]}})
      Source(groups=[x AS x__1], props={NESTED_COMMAND=SELECT 1, SYMBOL_MAP={}, OUTPUT_COLS=[], SOURCE_HINT=null, EST_CARDINALITY=1.0, EST_COL_STATS={}})
        TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=2, OUTPUT_COLS=[], EST_CARDINALITY=1.0, EST_COL_STATS={}})
          Project(groups=[], props={PROJECT_COLS=[], OUTPUT_COLS=[], EST_CARDINALITY=1.0, EST_COL_STATS={}})
      Access(groups=[NumberingPlanMaterialized.status], props={SOURCE_HINT=null, MODEL_ID=Schema name=NumberingPlanMaterialized, nameInSource=null, uuid=tid:f41d3bd875ef-f14912f9-00000000, OUTPUT_COLS=[Valid, LoadState], EST_CARDINALITY=1.0, EST_COL_STATS={Valid=[1.0, 1.0, 1.0], LoadState=[1.0, 1.0, 1.0]}})
        Select(groups=[NumberingPlanMaterialized.status], props={SELECT_CRITERIA=(VDBName = 'CountryServiceListVDB') AND (VDBVersion = '1') AND (SchemaName = 'NumberingPlan') AND (Name = 'numbering_plan'), OUTPUT_COLS=[Valid, LoadState], IS_COPIED=true, EST_CARDINALITY=1.0, EST_COL_STATS={Valid=[1.0, 1.0, 0.0], LoadState=[1.0, 1.0, 0.0]}})
          Source(groups=[NumberingPlanMaterialized.status], props={OUTPUT_COLS=[VDBName, VDBVersion, SchemaName, Name, Valid, LoadState], EST_COL_STATS={VDBName=[-1.0, -1.0, -1.0], VDBVersion=[-1.0, -1.0, -1.0], SchemaName=[-1.0, -1.0, -1.0], Name=[-1.0, -1.0, -1.0], ...}, EST_CARDINALITY=-1.0})


============================================================================
EXECUTING ImplementJoinStrategy

AFTER:
Project(groups=[NumberingPlanMaterialized.status])
  TupleLimit(groups=[])
    Join(groups=[NumberingPlanMaterialized.status, x AS x__1], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=[Valid, LoadState], IS_COPIED=true, EST_CARDINALITY=1.0, EST_COL_STATS={Valid=[1.0, 1.0, 1.0], LoadState=[1.0, 1.0, 1.0]}})
      Source(groups=[x AS x__1])
        TupleLimit(groups=[])
          Project(groups=[])
      Access(groups=[NumberingPlanMaterialized.status])
        Select(groups=[NumberingPlanMaterialized.status])
          Source(groups=[NumberingPlanMaterialized.status])


============================================================================
EXECUTING MergeCriteria

AFTER:
Project(groups=[NumberingPlanMaterialized.status])
  TupleLimit(groups=[])
    Join(groups=[NumberingPlanMaterialized.status, x AS x__1])
      Source(groups=[x AS x__1])
        TupleLimit(groups=[])
          Project(groups=[])
      Access(groups=[NumberingPlanMaterialized.status])
        Select(groups=[NumberingPlanMaterialized.status])
          Source(groups=[NumberingPlanMaterialized.status])


============================================================================
EXECUTING PlanSorts

AFTER:
Project(groups=[NumberingPlanMaterialized.status])
  TupleLimit(groups=[])
    Join(groups=[NumberingPlanMaterialized.status, x AS x__1], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=[Valid, LoadState], IS_COPIED=true, EST_CARDINALITY=1.0, EST_COL_STATS={Valid=[1.0, 1.0, 1.0], LoadState=[1.0, 1.0, 1.0]}})
      Source(groups=[x AS x__1])
        TupleLimit(groups=[])
          Project(groups=[])
      Access(groups=[NumberingPlanMaterialized.status])
        Select(groups=[NumberingPlanMaterialized.status])
          Source(groups=[NumberingPlanMaterialized.status])


============================================================================
EXECUTING CollapseSource

AFTER:
Project(groups=[NumberingPlanMaterialized.status])
  TupleLimit(groups=[])
    Join(groups=[NumberingPlanMaterialized.status, x AS x__1])
      Source(groups=[x AS x__1])
        TupleLimit(groups=[])
          Project(groups=[])
      Access(groups=[NumberingPlanMaterialized.status], props={SOURCE_HINT=null, MODEL_ID=Schema name=NumberingPlanMaterialized, nameInSource=null, uuid=tid:f41d3bd875ef-f14912f9-00000000, OUTPUT_COLS=[Valid, LoadState], EST_CARDINALITY=1.0, EST_COL_STATS={Valid=[1.0, 1.0, 1.0], LoadState=[1.0, 1.0, 1.0]}, ATOMIC_REQUEST=SELECT Valid, LoadState FROM NumberingPlanMaterialized.status WHERE (VDBName = 'CountryServiceListVDB') AND (VDBVersion = '1') AND (SchemaName = 'NumberingPlan') AND (Name = 'numbering_plan')})


============================================================================
CONVERTING PLAN TREE TO PROCESS TREE

PROCESS PLAN =
ProjectNode(7) output=[mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION')] [mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION')]
  LimitNode(8) output=[Valid, LoadState] limit 2
    JoinNode(9) [NESTED LOOP JOIN] [LEFT OUTER JOIN] criteria=[] output=[Valid, LoadState]
      LimitNode(10) output=[] limit 2
        ProjectNode(11) output=[] []
      AccessNode(12) output=[Valid, LoadState] SELECT g_0.Valid, g_0.LoadState FROM NumberingPlanMaterialized.status AS g_0 WHERE (g_0.VDBName = 'CountryServiceListVDB') AND (g_0.VDBVersion = '1') AND (g_0.SchemaName = 'NumberingPlan') AND (g_0.Name = 'numbering_plan')

============================================================================

----------------------------------------------------------------------------
OPTIMIZATION COMPLETE:
PROCESSOR PLAN:
ProjectNode(7) output=[mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION')] [mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION')]
  LimitNode(8) output=[Valid, LoadState] limit 2
    JoinNode(9) [NESTED LOOP JOIN] [LEFT OUTER JOIN] criteria=[] output=[Valid, LoadState]
      LimitNode(10) output=[] limit 2
        ProjectNode(11) output=[] []
      AccessNode(12) output=[Valid, LoadState] SELECT g_0.Valid, g_0.LoadState FROM NumberingPlanMaterialized.status AS g_0 WHERE (g_0.VDBName = 'CountryServiceListVDB') AND (g_0.VDBVersion = '1') AND (g_0.SchemaName = 'NumberingPlan') AND (g_0.Name = 'numbering_plan')

============================================================================

============================================================================
EXECUTING PlaceAccess

AFTER:
Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.agg0 AS expr1]})
  Group(groups=[anon_grp0], props={SYMBOL_MAP={anon_grp0.agg0=COUNT(*)}})
    Join(groups=[VodafoneNl.vodafone_nl AS vnl, NumberingPlan.numbering_plan AS np], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[np.mobile_country_code = vnl.mcc, np.mobile_network_code = vnl.mnc]})
      Source(groups=[VodafoneNl.vodafone_nl AS vnl], props={NESTED_COMMAND=SELECT country, name_network, type_network, suspended_7, voice_sms, camel, camel_phase, data_gprs, data_umts, data_hsdpa, sms_iw_mvno_send, tap_code, mcc, mnc FROM VodafoneNlMaterialized.vodafone_nl_cache WHERE (SELECT mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN VodafoneNlMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'VodafoneNl' AND Name = 'vodafone_nl' LIMIT 2) = 1, SYMBOL_MAP={vnl.country=country, vnl.name_network=name_network, vnl.type_network=type_network, vnl.suspended_7=suspended_7, vnl.voice_sms=voice_sms, vnl.camel=camel, vnl.camel_phase=camel_phase, vnl.data_gprs=data_gprs, vnl.data_umts=data_umts, vnl.data_hsdpa=data_hsdpa, vnl.sms_iw_mvno_send=sms_iw_mvno_send, vnl.tap_code=tap_code, vnl.mcc=mcc, vnl.mnc=mnc}})
        Project(groups=[VodafoneNlMaterialized.vodafone_nl_cache], props={PROJECT_COLS=[country, name_network, type_network, suspended_7, voice_sms, camel, camel_phase, data_gprs, data_umts, data_hsdpa, sms_iw_mvno_send, tap_code, mcc, mnc]})
          Select(groups=[], props={SELECT_CRITERIA=(SELECT mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN VodafoneNlMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'VodafoneNl' AND Name = 'vodafone_nl' LIMIT 2) = 1})
            Access(groups=[VodafoneNlMaterialized.vodafone_nl_cache], props={SOURCE_HINT=null, MODEL_ID=Schema name=VodafoneNlMaterialized, nameInSource=null, uuid=tid:97ebf59784d5-b8a1140b-00000000})
              Source(groups=[VodafoneNlMaterialized.vodafone_nl_cache])
      Source(groups=[NumberingPlan.numbering_plan AS np], props={NESTED_COMMAND=SELECT cns, country_code, national_significant_number, iso_3166_alpha_2, iso_3166_alpha_3, utc_min, utc_max, destination, type_id, description, location, registrar, area_code_length, min_subscr_nr_length, max_subscr_nr_length, range_activation, range_deactivation, range_status, mobile_country_code, mobile_network_code, operating_company_number FROM NumberingPlanMaterialized.numbering_plan_cache WHERE (SELECT mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN NumberingPlanMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'NumberingPlan' AND Name = 'numbering_plan' LIMIT 2) = 1, SYMBOL_MAP={np.cns=cns, np.country_code=country_code, np.national_significant_number=national_significant_number, np.iso_3166_alpha_2=iso_3166_alpha_2, np.iso_3166_alpha_3=iso_3166_alpha_3, np.utc_min=utc_min, np.utc_max=utc_max, np.destination=destination, np.type_id=type_id, np.description=description, np.location=location, np.registrar=registrar, np.area_code_length=area_code_length, np.min_subscr_nr_length=min_subscr_nr_length, np.max_subscr_nr_length=max_subscr_nr_length, np.range_activation=range_activation, np.range_deactivation=range_deactivation, np.range_status=range_status, np.mobile_country_code=mobile_country_code, np.mobile_network_code=mobile_network_code, np.operating_company_number=operating_company_number}})
        Project(groups=[NumberingPlanMaterialized.numbering_plan_cache], props={PROJECT_COLS=[cns, country_code, national_significant_number, iso_3166_alpha_2, iso_3166_alpha_3, utc_min, utc_max, destination, type_id, description, location, registrar, area_code_length, min_subscr_nr_length, max_subscr_nr_length, range_activation, range_deactivation, range_status, mobile_country_code, mobile_network_code, operating_company_number]})
          Select(groups=[], props={SELECT_CRITERIA=(SELECT mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN NumberingPlanMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'NumberingPlan' AND Name = 'numbering_plan' LIMIT 2) = 1})
            Access(groups=[NumberingPlanMaterialized.numbering_plan_cache], props={SOURCE_HINT=null, MODEL_ID=Schema name=NumberingPlanMaterialized, nameInSource=null, uuid=tid:f41d3bd875ef-f14912f9-00000000})
              Source(groups=[NumberingPlanMaterialized.numbering_plan_cache])


============================================================================
EXECUTING AssignOutputElements

AFTER:
Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.agg0 AS expr1], OUTPUT_COLS=[anon_grp0.agg0 AS expr1]})
  Group(groups=[anon_grp0], props={SYMBOL_MAP={anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=[anon_grp0.agg0]})
    Join(groups=[VodafoneNl.vodafone_nl AS vnl, NumberingPlan.numbering_plan AS np], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[np.mobile_country_code = vnl.mcc, np.mobile_network_code = vnl.mnc], OUTPUT_COLS=[]})
      Source(groups=[VodafoneNl.vodafone_nl AS vnl], props={NESTED_COMMAND=SELECT country, name_network, type_network, suspended_7, voice_sms, camel, camel_phase, data_gprs, data_umts, data_hsdpa, sms_iw_mvno_send, tap_code, mcc, mnc FROM VodafoneNlMaterialized.vodafone_nl_cache WHERE (SELECT mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN VodafoneNlMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'VodafoneNl' AND Name = 'vodafone_nl' LIMIT 2) = 1, SYMBOL_MAP={vnl.mcc=mcc, vnl.mnc=mnc}, OUTPUT_COLS=[vnl.mcc, vnl.mnc]})
        Project(groups=[VodafoneNlMaterialized.vodafone_nl_cache], props={PROJECT_COLS=[mcc, mnc], OUTPUT_COLS=[mcc, mnc]})
          Select(groups=[], props={SELECT_CRITERIA=(SELECT mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN VodafoneNlMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'VodafoneNl' AND Name = 'vodafone_nl' LIMIT 2) = 1, OUTPUT_COLS=[mcc, mnc]})
            Access(groups=[VodafoneNlMaterialized.vodafone_nl_cache], props={SOURCE_HINT=null, MODEL_ID=Schema name=VodafoneNlMaterialized, nameInSource=null, uuid=tid:97ebf59784d5-b8a1140b-00000000, OUTPUT_COLS=[mcc, mnc]})
              Source(groups=[VodafoneNlMaterialized.vodafone_nl_cache], props={OUTPUT_COLS=[mcc, mnc]})
      Source(groups=[NumberingPlan.numbering_plan AS np], props={NESTED_COMMAND=SELECT cns, country_code, national_significant_number, iso_3166_alpha_2, iso_3166_alpha_3, utc_min, utc_max, destination, type_id, description, location, registrar, area_code_length, min_subscr_nr_length, max_subscr_nr_length, range_activation, range_deactivation, range_status, mobile_country_code, mobile_network_code, operating_company_number FROM NumberingPlanMaterialized.numbering_plan_cache WHERE (SELECT mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN NumberingPlanMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'NumberingPlan' AND Name = 'numbering_plan' LIMIT 2) = 1, SYMBOL_MAP={np.mobile_country_code=mobile_country_code, np.mobile_network_code=mobile_network_code}, OUTPUT_COLS=[np.mobile_country_code, np.mobile_network_code]})
        Project(groups=[NumberingPlanMaterialized.numbering_plan_cache], props={PROJECT_COLS=[mobile_country_code, mobile_network_code], OUTPUT_COLS=[mobile_country_code, mobile_network_code]})
          Select(groups=[], props={SELECT_CRITERIA=(SELECT mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN NumberingPlanMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'NumberingPlan' AND Name = 'numbering_plan' LIMIT 2) = 1, OUTPUT_COLS=[mobile_country_code, mobile_network_code]})
            Access(groups=[NumberingPlanMaterialized.numbering_plan_cache], props={SOURCE_HINT=null, MODEL_ID=Schema name=NumberingPlanMaterialized, nameInSource=null, uuid=tid:f41d3bd875ef-f14912f9-00000000, OUTPUT_COLS=[mobile_country_code, mobile_network_code]})
              Source(groups=[NumberingPlanMaterialized.numbering_plan_cache], props={OUTPUT_COLS=[mobile_country_code, mobile_network_code]})


============================================================================
EXECUTING RemoveOptionalJoins

AFTER:
Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.agg0 AS expr1], OUTPUT_COLS=[anon_grp0.agg0 AS expr1]})
  Group(groups=[anon_grp0], props={SYMBOL_MAP={anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=[anon_grp0.agg0]})
    Join(groups=[VodafoneNl.vodafone_nl AS vnl, NumberingPlan.numbering_plan AS np], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[np.mobile_country_code = vnl.mcc, np.mobile_network_code = vnl.mnc], OUTPUT_COLS=[]})
      Source(groups=[VodafoneNl.vodafone_nl AS vnl])
        Project(groups=[VodafoneNlMaterialized.vodafone_nl_cache])
          Select(groups=[], props={SELECT_CRITERIA=(SELECT mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN VodafoneNlMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'VodafoneNl' AND Name = 'vodafone_nl' LIMIT 2) = 1, OUTPUT_COLS=[mcc, mnc]})
            Access(groups=[VodafoneNlMaterialized.vodafone_nl_cache])
              Source(groups=[VodafoneNlMaterialized.vodafone_nl_cache])
      Source(groups=[NumberingPlan.numbering_plan AS np])
        Project(groups=[NumberingPlanMaterialized.numbering_plan_cache])
          Select(groups=[], props={SELECT_CRITERIA=(SELECT mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN NumberingPlanMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'NumberingPlan' AND Name = 'numbering_plan' LIMIT 2) = 1, OUTPUT_COLS=[mobile_country_code, mobile_network_code]})
            Access(groups=[NumberingPlanMaterialized.numbering_plan_cache])
              Source(groups=[NumberingPlanMaterialized.numbering_plan_cache])


============================================================================
EXECUTING PushSelectCriteria

AFTER:
Project(groups=[anon_grp0])
  Group(groups=[anon_grp0])
    Join(groups=[VodafoneNl.vodafone_nl AS vnl, NumberingPlan.numbering_plan AS np])
      Source(groups=[VodafoneNl.vodafone_nl AS vnl])
        Project(groups=[VodafoneNlMaterialized.vodafone_nl_cache], props={PROJECT_COLS=[mcc, mnc], OUTPUT_COLS=[mcc, mnc]})
          Access(groups=[VodafoneNlMaterialized.vodafone_nl_cache], props={SOURCE_HINT=null, MODEL_ID=Schema name=VodafoneNlMaterialized, nameInSource=null, uuid=tid:97ebf59784d5-b8a1140b-00000000, OUTPUT_COLS=[mcc, mnc]})
            Select(groups=[], props={SELECT_CRITERIA=(SELECT mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN VodafoneNlMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'VodafoneNl' AND Name = 'vodafone_nl' LIMIT 2) = 1, OUTPUT_COLS=[mcc, mnc]})
              Source(groups=[VodafoneNlMaterialized.vodafone_nl_cache], props={OUTPUT_COLS=[mcc, mnc]})
      Source(groups=[NumberingPlan.numbering_plan AS np])
        Project(groups=[NumberingPlanMaterialized.numbering_plan_cache], props={PROJECT_COLS=[mobile_country_code, mobile_network_code], OUTPUT_COLS=[mobile_country_code, mobile_network_code]})
          Access(groups=[NumberingPlanMaterialized.numbering_plan_cache], props={SOURCE_HINT=null, MODEL_ID=Schema name=NumberingPlanMaterialized, nameInSource=null, uuid=tid:f41d3bd875ef-f14912f9-00000000, OUTPUT_COLS=[mobile_country_code, mobile_network_code]})
            Select(groups=[], props={SELECT_CRITERIA=(SELECT mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN NumberingPlanMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'NumberingPlan' AND Name = 'numbering_plan' LIMIT 2) = 1, OUTPUT_COLS=[mobile_country_code, mobile_network_code]})
              Source(groups=[NumberingPlanMaterialized.numbering_plan_cache], props={OUTPUT_COLS=[mobile_country_code, mobile_network_code]})


============================================================================
EXECUTING MergeVirtual

AFTER:
Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.agg0 AS expr1], OUTPUT_COLS=[anon_grp0.agg0 AS expr1]})
  Group(groups=[anon_grp0], props={SYMBOL_MAP={anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=[anon_grp0.agg0]})
    Join(groups=[NumberingPlan.numbering_plan AS np, VodafoneNlMaterialized.vodafone_nl_cache], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[np.mobile_country_code = mcc, np.mobile_network_code = mnc], OUTPUT_COLS=[]})
      Access(groups=[VodafoneNlMaterialized.vodafone_nl_cache], props={SOURCE_HINT=null, MODEL_ID=Schema name=VodafoneNlMaterialized, nameInSource=null, uuid=tid:97ebf59784d5-b8a1140b-00000000, OUTPUT_COLS=[mcc, mnc]})
        Select(groups=[])
          Source(groups=[VodafoneNlMaterialized.vodafone_nl_cache])
      Source(groups=[NumberingPlan.numbering_plan AS np], props={NESTED_COMMAND=SELECT cns, country_code, national_significant_number, iso_3166_alpha_2, iso_3166_alpha_3, utc_min, utc_max, destination, type_id, description, location, registrar, area_code_length, min_subscr_nr_length, max_subscr_nr_length, range_activation, range_deactivation, range_status, mobile_country_code, mobile_network_code, operating_company_number FROM NumberingPlanMaterialized.numbering_plan_cache WHERE (SELECT mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN NumberingPlanMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'NumberingPlan' AND Name = 'numbering_plan' LIMIT 2) = 1, SYMBOL_MAP={np.mobile_country_code=mobile_country_code, np.mobile_network_code=mobile_network_code}, OUTPUT_COLS=[np.mobile_country_code, np.mobile_network_code]})
        Project(groups=[NumberingPlanMaterialized.numbering_plan_cache])
          Access(groups=[NumberingPlanMaterialized.numbering_plan_cache])
            Select(groups=[])
              Source(groups=[NumberingPlanMaterialized.numbering_plan_cache])


============================================================================
EXECUTING PushNonJoinCriteria

AFTER:
Project(groups=[anon_grp0])
  Group(groups=[anon_grp0])
    Join(groups=[NumberingPlan.numbering_plan AS np, VodafoneNlMaterialized.vodafone_nl_cache], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[np.mobile_country_code = mcc, np.mobile_network_code = mnc], OUTPUT_COLS=[]})
      Access(groups=[VodafoneNlMaterialized.vodafone_nl_cache])
        Select(groups=[])
          Source(groups=[VodafoneNlMaterialized.vodafone_nl_cache])
      Source(groups=[NumberingPlan.numbering_plan AS np])
        Project(groups=[NumberingPlanMaterialized.numbering_plan_cache])
          Access(groups=[NumberingPlanMaterialized.numbering_plan_cache])
            Select(groups=[])
              Source(groups=[NumberingPlanMaterialized.numbering_plan_cache])


============================================================================
EXECUTING CleanCriteria

AFTER:
Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.agg0 AS expr1], OUTPUT_COLS=null})
  Group(groups=[anon_grp0], props={SYMBOL_MAP={anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=null})
    Join(groups=[NumberingPlan.numbering_plan AS np, VodafoneNlMaterialized.vodafone_nl_cache], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[np.mobile_country_code = mcc, np.mobile_network_code = mnc], OUTPUT_COLS=null})
      Access(groups=[VodafoneNlMaterialized.vodafone_nl_cache], props={SOURCE_HINT=null, MODEL_ID=Schema name=VodafoneNlMaterialized, nameInSource=null, uuid=tid:97ebf59784d5-b8a1140b-00000000, OUTPUT_COLS=null})
        Select(groups=[], props={SELECT_CRITERIA=(SELECT mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN VodafoneNlMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'VodafoneNl' AND Name = 'vodafone_nl' LIMIT 2) = 1, OUTPUT_COLS=null})
          Source(groups=[VodafoneNlMaterialized.vodafone_nl_cache], props={OUTPUT_COLS=null})
      Source(groups=[NumberingPlan.numbering_plan AS np], props={NESTED_COMMAND=SELECT cns, country_code, national_significant_number, iso_3166_alpha_2, iso_3166_alpha_3, utc_min, utc_max, destination, type_id, description, location, registrar, area_code_length, min_subscr_nr_length, max_subscr_nr_length, range_activation, range_deactivation, range_status, mobile_country_code, mobile_network_code, operating_company_number FROM NumberingPlanMaterialized.numbering_plan_cache WHERE (SELECT mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN NumberingPlanMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'NumberingPlan' AND Name = 'numbering_plan' LIMIT 2) = 1, SYMBOL_MAP={np.mobile_country_code=mobile_country_code, np.mobile_network_code=mobile_network_code}, OUTPUT_COLS=null})
        Project(groups=[NumberingPlanMaterialized.numbering_plan_cache], props={PROJECT_COLS=[mobile_country_code, mobile_network_code], OUTPUT_COLS=null})
          Access(groups=[NumberingPlanMaterialized.numbering_plan_cache], props={SOURCE_HINT=null, MODEL_ID=Schema name=NumberingPlanMaterialized, nameInSource=null, uuid=tid:f41d3bd875ef-f14912f9-00000000, OUTPUT_COLS=null})
            Select(groups=[], props={SELECT_CRITERIA=(SELECT mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN NumberingPlanMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'NumberingPlan' AND Name = 'numbering_plan' LIMIT 2) = 1, OUTPUT_COLS=null})
              Source(groups=[NumberingPlanMaterialized.numbering_plan_cache], props={OUTPUT_COLS=null})


============================================================================
EXECUTING RaiseAccess

AFTER:
Access(groups=[anon_grp0], props={SOURCE_HINT=null, MODEL_ID=Schema name=NumberingPlanMaterialized, nameInSource=null, uuid=tid:f41d3bd875ef-f14912f9-00000000, OUTPUT_COLS=null, CONFORMED_SOURCES=null})
  Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.agg0 AS expr1], OUTPUT_COLS=null})
    Group(groups=[anon_grp0], props={SYMBOL_MAP={anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=null})
      Join(groups=[NumberingPlan.numbering_plan AS np, VodafoneNlMaterialized.vodafone_nl_cache], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[np.mobile_country_code = mcc, np.mobile_network_code = mnc], OUTPUT_COLS=null, MODEL_ID=Schema name=VodafoneNlMaterialized, nameInSource=null, uuid=tid:97ebf59784d5-b8a1140b-00000000})
        Select(groups=[], props={SELECT_CRITERIA=(SELECT mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN VodafoneNlMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'VodafoneNl' AND Name = 'vodafone_nl' LIMIT 2) = 1, OUTPUT_COLS=null})
          Source(groups=[VodafoneNlMaterialized.vodafone_nl_cache])
        Source(groups=[NumberingPlan.numbering_plan AS np], props={NESTED_COMMAND=SELECT cns, country_code, national_significant_number, iso_3166_alpha_2, iso_3166_alpha_3, utc_min, utc_max, destination, type_id, description, location, registrar, area_code_length, min_subscr_nr_length, max_subscr_nr_length, range_activation, range_deactivation, range_status, mobile_country_code, mobile_network_code, operating_company_number FROM NumberingPlanMaterialized.numbering_plan_cache WHERE (SELECT mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN NumberingPlanMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'NumberingPlan' AND Name = 'numbering_plan' LIMIT 2) = 1, SYMBOL_MAP={np.mobile_country_code=mobile_country_code, np.mobile_network_code=mobile_network_code}, OUTPUT_COLS=null, INLINE_VIEW=true})
          Project(groups=[NumberingPlanMaterialized.numbering_plan_cache], props={PROJECT_COLS=[mobile_country_code, mobile_network_code], OUTPUT_COLS=null})
            Select(groups=[], props={SELECT_CRITERIA=(SELECT mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN NumberingPlanMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'NumberingPlan' AND Name = 'numbering_plan' LIMIT 2) = 1, OUTPUT_COLS=null})
              Source(groups=[NumberingPlanMaterialized.numbering_plan_cache])


============================================================================
EXECUTING CopyCriteria

AFTER:
Access(groups=[anon_grp0])
  Project(groups=[anon_grp0])
    Group(groups=[anon_grp0])
      Join(groups=[NumberingPlan.numbering_plan AS np, VodafoneNlMaterialized.vodafone_nl_cache], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[np.mobile_country_code = mcc, np.mobile_network_code = mnc], OUTPUT_COLS=null, MODEL_ID=Schema name=VodafoneNlMaterialized, nameInSource=null, uuid=tid:97ebf59784d5-b8a1140b-00000000, IS_COPIED=true})
        Select(groups=[], props={SELECT_CRITERIA=(SELECT mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN VodafoneNlMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'VodafoneNl' AND Name = 'vodafone_nl' LIMIT 2) = 1, OUTPUT_COLS=null, IS_COPIED=true})
          Source(groups=[VodafoneNlMaterialized.vodafone_nl_cache])
        Source(groups=[NumberingPlan.numbering_plan AS np])
          Project(groups=[NumberingPlanMaterialized.numbering_plan_cache])
            Select(groups=[], props={SELECT_CRITERIA=(SELECT mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN NumberingPlanMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'NumberingPlan' AND Name = 'numbering_plan' LIMIT 2) = 1, OUTPUT_COLS=null, IS_COPIED=true})
              Source(groups=[NumberingPlanMaterialized.numbering_plan_cache])


============================================================================
EXECUTING CleanCriteria

AFTER:
Access(groups=[anon_grp0], props={SOURCE_HINT=null, MODEL_ID=Schema name=NumberingPlanMaterialized, nameInSource=null, uuid=tid:f41d3bd875ef-f14912f9-00000000, OUTPUT_COLS=null, CONFORMED_SOURCES=null})
  Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.agg0 AS expr1], OUTPUT_COLS=null})
    Group(groups=[anon_grp0], props={SYMBOL_MAP={anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=null})
      Join(groups=[NumberingPlan.numbering_plan AS np, VodafoneNlMaterialized.vodafone_nl_cache], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[np.mobile_country_code = mcc, np.mobile_network_code = mnc], OUTPUT_COLS=null, MODEL_ID=Schema name=VodafoneNlMaterialized, nameInSource=null, uuid=tid:97ebf59784d5-b8a1140b-00000000, IS_COPIED=true})
        Select(groups=[], props={SELECT_CRITERIA=(SELECT mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN VodafoneNlMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'VodafoneNl' AND Name = 'vodafone_nl' LIMIT 2) = 1, OUTPUT_COLS=null, IS_COPIED=true})
          Source(groups=[VodafoneNlMaterialized.vodafone_nl_cache], props={OUTPUT_COLS=null})
        Source(groups=[NumberingPlan.numbering_plan AS np], props={NESTED_COMMAND=SELECT cns, country_code, national_significant_number, iso_3166_alpha_2, iso_3166_alpha_3, utc_min, utc_max, destination, type_id, description, location, registrar, area_code_length, min_subscr_nr_length, max_subscr_nr_length, range_activation, range_deactivation, range_status, mobile_country_code, mobile_network_code, operating_company_number FROM NumberingPlanMaterialized.numbering_plan_cache WHERE (SELECT mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN NumberingPlanMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'NumberingPlan' AND Name = 'numbering_plan' LIMIT 2) = 1, SYMBOL_MAP={np.mobile_country_code=mobile_country_code, np.mobile_network_code=mobile_network_code}, OUTPUT_COLS=null, INLINE_VIEW=true})
          Project(groups=[NumberingPlanMaterialized.numbering_plan_cache], props={PROJECT_COLS=[mobile_country_code, mobile_network_code], OUTPUT_COLS=null})
            Select(groups=[], props={SELECT_CRITERIA=(SELECT mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN NumberingPlanMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'NumberingPlan' AND Name = 'numbering_plan' LIMIT 2) = 1, OUTPUT_COLS=null, IS_COPIED=true})
              Source(groups=[NumberingPlanMaterialized.numbering_plan_cache], props={OUTPUT_COLS=null})


============================================================================
EXECUTING PlanJoins

AFTER:
Access(groups=[anon_grp0])
  Project(groups=[anon_grp0])
    Group(groups=[anon_grp0])
      Join(groups=[NumberingPlan.numbering_plan AS np, VodafoneNlMaterialized.vodafone_nl_cache])
        Select(groups=[])
          Source(groups=[VodafoneNlMaterialized.vodafone_nl_cache])
        Source(groups=[NumberingPlan.numbering_plan AS np])
          Project(groups=[NumberingPlanMaterialized.numbering_plan_cache])
            Select(groups=[])
              Source(groups=[NumberingPlanMaterialized.numbering_plan_cache])


============================================================================
EXECUTING PushSelectCriteria

AFTER:
Access(groups=[anon_grp0])
  Project(groups=[anon_grp0])
    Group(groups=[anon_grp0])
      Join(groups=[NumberingPlan.numbering_plan AS np, VodafoneNlMaterialized.vodafone_nl_cache])
        Select(groups=[], props={SELECT_CRITERIA=(SELECT mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN VodafoneNlMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'VodafoneNl' AND Name = 'vodafone_nl' LIMIT 2) = 1, OUTPUT_COLS=null, IS_COPIED=true})
          Source(groups=[VodafoneNlMaterialized.vodafone_nl_cache])
        Source(groups=[NumberingPlan.numbering_plan AS np])
          Project(groups=[NumberingPlanMaterialized.numbering_plan_cache])
            Select(groups=[], props={SELECT_CRITERIA=(SELECT mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN NumberingPlanMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'NumberingPlan' AND Name = 'numbering_plan' LIMIT 2) = 1, OUTPUT_COLS=null, IS_COPIED=true})
              Source(groups=[NumberingPlanMaterialized.numbering_plan_cache])


============================================================================
EXECUTING RaiseAccess

AFTER:
Access(groups=[anon_grp0])
  Project(groups=[anon_grp0])
    Group(groups=[anon_grp0])
      Join(groups=[NumberingPlan.numbering_plan AS np, VodafoneNlMaterialized.vodafone_nl_cache])
        Select(groups=[])
          Source(groups=[VodafoneNlMaterialized.vodafone_nl_cache])
        Source(groups=[NumberingPlan.numbering_plan AS np])
          Project(groups=[NumberingPlanMaterialized.numbering_plan_cache])
            Select(groups=[])
              Source(groups=[NumberingPlanMaterialized.numbering_plan_cache])


============================================================================
EXECUTING PlanOuterJoins

AFTER:
Access(groups=[anon_grp0])
  Project(groups=[anon_grp0])
    Group(groups=[anon_grp0])
      Join(groups=[NumberingPlan.numbering_plan AS np, VodafoneNlMaterialized.vodafone_nl_cache])
        Select(groups=[])
          Source(groups=[VodafoneNlMaterialized.vodafone_nl_cache])
        Source(groups=[NumberingPlan.numbering_plan AS np])
          Project(groups=[NumberingPlanMaterialized.numbering_plan_cache])
            Select(groups=[])
              Source(groups=[NumberingPlanMaterialized.numbering_plan_cache])


============================================================================
EXECUTING ChooseJoinStrategy

AFTER:
Access(groups=[anon_grp0])
  Project(groups=[anon_grp0])
    Group(groups=[anon_grp0])
      Join(groups=[NumberingPlan.numbering_plan AS np, VodafoneNlMaterialized.vodafone_nl_cache])
        Select(groups=[])
          Source(groups=[VodafoneNlMaterialized.vodafone_nl_cache])
        Source(groups=[NumberingPlan.numbering_plan AS np])
          Project(groups=[NumberingPlanMaterialized.numbering_plan_cache])
            Select(groups=[])
              Source(groups=[NumberingPlanMaterialized.numbering_plan_cache])


============================================================================
EXECUTING ChooseDependent

AFTER:
Access(groups=[anon_grp0])
  Project(groups=[anon_grp0])
    Group(groups=[anon_grp0])
      Join(groups=[NumberingPlan.numbering_plan AS np, VodafoneNlMaterialized.vodafone_nl_cache])
        Select(groups=[])
          Source(groups=[VodafoneNlMaterialized.vodafone_nl_cache])
        Source(groups=[NumberingPlan.numbering_plan AS np])
          Project(groups=[NumberingPlanMaterialized.numbering_plan_cache])
            Select(groups=[])
              Source(groups=[NumberingPlanMaterialized.numbering_plan_cache])


============================================================================
EXECUTING PushAggregates

AFTER:
Access(groups=[anon_grp0])
  Project(groups=[anon_grp0])
    Group(groups=[anon_grp0])
      Join(groups=[NumberingPlan.numbering_plan AS np, VodafoneNlMaterialized.vodafone_nl_cache])
        Select(groups=[])
          Source(groups=[VodafoneNlMaterialized.vodafone_nl_cache])
        Source(groups=[NumberingPlan.numbering_plan AS np])
          Project(groups=[NumberingPlanMaterialized.numbering_plan_cache])
            Select(groups=[])
              Source(groups=[NumberingPlanMaterialized.numbering_plan_cache])


============================================================================
EXECUTING ChooseDependent

AFTER:
Access(groups=[anon_grp0])
  Project(groups=[anon_grp0])
    Group(groups=[anon_grp0])
      Join(groups=[NumberingPlan.numbering_plan AS np, VodafoneNlMaterialized.vodafone_nl_cache])
        Select(groups=[])
          Source(groups=[VodafoneNlMaterialized.vodafone_nl_cache])
        Source(groups=[NumberingPlan.numbering_plan AS np])
          Project(groups=[NumberingPlanMaterialized.numbering_plan_cache])
            Select(groups=[])
              Source(groups=[NumberingPlanMaterialized.numbering_plan_cache])


============================================================================
EXECUTING AssignOutputElements

AFTER:
Access(groups=[anon_grp0], props={SOURCE_HINT=null, MODEL_ID=Schema name=NumberingPlanMaterialized, nameInSource=null, uuid=tid:f41d3bd875ef-f14912f9-00000000, OUTPUT_COLS=[anon_grp0.agg0 AS expr1], CONFORMED_SOURCES=null})
  Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.agg0 AS expr1], OUTPUT_COLS=[anon_grp0.agg0 AS expr1]})
    Group(groups=[anon_grp0], props={SYMBOL_MAP={anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=[anon_grp0.agg0]})
      Join(groups=[NumberingPlan.numbering_plan AS np, VodafoneNlMaterialized.vodafone_nl_cache], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[np.mobile_country_code = mcc, np.mobile_network_code = mnc], OUTPUT_COLS=[], MODEL_ID=Schema name=VodafoneNlMaterialized, nameInSource=null, uuid=tid:97ebf59784d5-b8a1140b-00000000, IS_COPIED=true})
        Select(groups=[], props={SELECT_CRITERIA=(SELECT mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN VodafoneNlMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'VodafoneNl' AND Name = 'vodafone_nl' LIMIT 2) = 1, OUTPUT_COLS=[mcc, mnc], IS_COPIED=true})
          Source(groups=[VodafoneNlMaterialized.vodafone_nl_cache], props={OUTPUT_COLS=[mcc, mnc]})
        Source(groups=[NumberingPlan.numbering_plan AS np], props={NESTED_COMMAND=SELECT cns, country_code, national_significant_number, iso_3166_alpha_2, iso_3166_alpha_3, utc_min, utc_max, destination, type_id, description, location, registrar, area_code_length, min_subscr_nr_length, max_subscr_nr_length, range_activation, range_deactivation, range_status, mobile_country_code, mobile_network_code, operating_company_number FROM NumberingPlanMaterialized.numbering_plan_cache WHERE (SELECT mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN NumberingPlanMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'NumberingPlan' AND Name = 'numbering_plan' LIMIT 2) = 1, SYMBOL_MAP={np.mobile_country_code=mobile_country_code, np.mobile_network_code=mobile_network_code}, OUTPUT_COLS=[np.mobile_country_code, np.mobile_network_code], INLINE_VIEW=true})
          Project(groups=[NumberingPlanMaterialized.numbering_plan_cache], props={PROJECT_COLS=[mobile_country_code, mobile_network_code], OUTPUT_COLS=[mobile_country_code, mobile_network_code]})
            Select(groups=[], props={SELECT_CRITERIA=(SELECT mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN NumberingPlanMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'NumberingPlan' AND Name = 'numbering_plan' LIMIT 2) = 1, OUTPUT_COLS=[mobile_country_code, mobile_network_code], IS_COPIED=true})
              Source(groups=[NumberingPlanMaterialized.numbering_plan_cache], props={OUTPUT_COLS=[mobile_country_code, mobile_network_code]})


============================================================================
EXECUTING CalculateCost

AFTER:
Access(groups=[anon_grp0], props={SOURCE_HINT=null, MODEL_ID=Schema name=NumberingPlanMaterialized, nameInSource=null, uuid=tid:f41d3bd875ef-f14912f9-00000000, OUTPUT_COLS=[anon_grp0.agg0 AS expr1], CONFORMED_SOURCES=null, EST_CARDINALITY=1.0, EST_COL_STATS={anon_grp0.agg0=[1.0, 1.0, 1.0]}})
  Project(groups=[anon_grp0], props={PROJECT_COLS=[anon_grp0.agg0 AS expr1], OUTPUT_COLS=[anon_grp0.agg0 AS expr1], EST_CARDINALITY=1.0, EST_COL_STATS={anon_grp0.agg0=[1.0, 1.0, 1.0]}})
    Group(groups=[anon_grp0], props={SYMBOL_MAP={anon_grp0.agg0=COUNT(*)}, OUTPUT_COLS=[anon_grp0.agg0], EST_CARDINALITY=1.0, EST_COL_STATS={anon_grp0.agg0=[1.0, 1.0, 0.0]}})
      Join(groups=[NumberingPlan.numbering_plan AS np, VodafoneNlMaterialized.vodafone_nl_cache], props={JOIN_TYPE=LEFT OUTER JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[np.mobile_country_code = mcc, np.mobile_network_code = mnc], OUTPUT_COLS=[], MODEL_ID=Schema name=VodafoneNlMaterialized, nameInSource=null, uuid=tid:97ebf59784d5-b8a1140b-00000000, IS_COPIED=true, EST_CARDINALITY=-1.0})
        Select(groups=[], props={SELECT_CRITERIA=(SELECT mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN VodafoneNlMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'VodafoneNl' AND Name = 'vodafone_nl' LIMIT 2) = 1, OUTPUT_COLS=[mcc, mnc], IS_COPIED=true, EST_CARDINALITY=-1.0})
          Source(groups=[VodafoneNlMaterialized.vodafone_nl_cache], props={OUTPUT_COLS=[mcc, mnc], EST_COL_STATS={mcc=[-1.0, -1.0, -1.0], mnc=[-1.0, -1.0, -1.0]}, EST_CARDINALITY=-1.0})
        Source(groups=[NumberingPlan.numbering_plan AS np], props={NESTED_COMMAND=SELECT cns, country_code, national_significant_number, iso_3166_alpha_2, iso_3166_alpha_3, utc_min, utc_max, destination, type_id, description, location, registrar, area_code_length, min_subscr_nr_length, max_subscr_nr_length, range_activation, range_deactivation, range_status, mobile_country_code, mobile_network_code, operating_company_number FROM NumberingPlanMaterialized.numbering_plan_cache WHERE (SELECT mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN NumberingPlanMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'NumberingPlan' AND Name = 'numbering_plan' LIMIT 2) = 1, SYMBOL_MAP={np.mobile_country_code=mobile_country_code, np.mobile_network_code=mobile_network_code}, OUTPUT_COLS=[np.mobile_country_code, np.mobile_network_code], INLINE_VIEW=true, EST_CARDINALITY=-1.0, EST_COL_STATS={np.mobile_country_code=[-1.0, -1.0, -1.0], np.mobile_network_code=[-1.0, -1.0, -1.0]}})
          Project(groups=[NumberingPlanMaterialized.numbering_plan_cache], props={PROJECT_COLS=[mobile_country_code, mobile_network_code], OUTPUT_COLS=[mobile_country_code, mobile_network_code], EST_CARDINALITY=-1.0})
            Select(groups=[], props={SELECT_CRITERIA=(SELECT mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN NumberingPlanMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'NumberingPlan' AND Name = 'numbering_plan' LIMIT 2) = 1, OUTPUT_COLS=[mobile_country_code, mobile_network_code], IS_COPIED=true, EST_CARDINALITY=-1.0})
              Source(groups=[NumberingPlanMaterialized.numbering_plan_cache], props={OUTPUT_COLS=[mobile_country_code, mobile_network_code], EST_COL_STATS={mobile_country_code=[-1.0, -1.0, -1.0], mobile_network_code=[-1.0, -1.0, -1.0]}, EST_CARDINALITY=-1.0})


============================================================================
EXECUTING ImplementJoinStrategy

AFTER:
Access(groups=[anon_grp0])
  Project(groups=[anon_grp0])
    Group(groups=[anon_grp0])
      Join(groups=[NumberingPlan.numbering_plan AS np, VodafoneNlMaterialized.vodafone_nl_cache])
        Select(groups=[])
          Source(groups=[VodafoneNlMaterialized.vodafone_nl_cache])
        Source(groups=[NumberingPlan.numbering_plan AS np])
          Project(groups=[NumberingPlanMaterialized.numbering_plan_cache])
            Select(groups=[])
              Source(groups=[NumberingPlanMaterialized.numbering_plan_cache])


============================================================================
EXECUTING MergeCriteria

AFTER:
Access(groups=[anon_grp0])
  Project(groups=[anon_grp0])
    Group(groups=[anon_grp0])
      Join(groups=[NumberingPlan.numbering_plan AS np, VodafoneNlMaterialized.vodafone_nl_cache])
        Select(groups=[])
          Source(groups=[VodafoneNlMaterialized.vodafone_nl_cache])
        Source(groups=[NumberingPlan.numbering_plan AS np])
          Project(groups=[NumberingPlanMaterialized.numbering_plan_cache])
            Select(groups=[])
              Source(groups=[NumberingPlanMaterialized.numbering_plan_cache])


============================================================================
EXECUTING PlanSorts

AFTER:
Access(groups=[anon_grp0])
  Project(groups=[anon_grp0])
    Group(groups=[anon_grp0])
      Join(groups=[NumberingPlan.numbering_plan AS np, VodafoneNlMaterialized.vodafone_nl_cache])
        Select(groups=[])
          Source(groups=[VodafoneNlMaterialized.vodafone_nl_cache])
        Source(groups=[NumberingPlan.numbering_plan AS np])
          Project(groups=[NumberingPlanMaterialized.numbering_plan_cache])
            Select(groups=[])
              Source(groups=[NumberingPlanMaterialized.numbering_plan_cache])


============================================================================
EXECUTING CollapseSource

AFTER:
Access(groups=[anon_grp0], props={SOURCE_HINT=null, MODEL_ID=Schema name=NumberingPlanMaterialized, nameInSource=null, uuid=tid:f41d3bd875ef-f14912f9-00000000, OUTPUT_COLS=[anon_grp0.agg0 AS expr1], CONFORMED_SOURCES=null, EST_CARDINALITY=1.0, EST_COL_STATS={anon_grp0.agg0=[1.0, 1.0, 1.0]}, ATOMIC_REQUEST=SELECT COUNT(*) AS expr1 FROM VodafoneNlMaterialized.vodafone_nl_cache LEFT OUTER JOIN (SELECT mobile_country_code, mobile_network_code FROM NumberingPlanMaterialized.numbering_plan_cache WHERE (SELECT mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN NumberingPlanMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'NumberingPlan' AND Name = 'numbering_plan' LIMIT 2) = 1) AS np ON np.mobile_country_code = mcc AND np.mobile_network_code = mnc WHERE (SELECT mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN VodafoneNlMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'VodafoneNl' AND Name = 'vodafone_nl' LIMIT 2) = 1})


============================================================================
CONVERTING PLAN TREE TO PROCESS TREE

PROCESS PLAN =
AccessNode(13) output=[anon_grp0.agg0 AS expr1] SELECT COUNT(*) FROM VodafoneNlMaterialized.vodafone_nl_cache AS g_0 LEFT OUTER JOIN (SELECT g_1.mobile_country_code AS c_0, g_1.mobile_network_code AS c_1 FROM NumberingPlanMaterialized.numbering_plan_cache AS g_1 WHERE (SELECT mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN NumberingPlanMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'NumberingPlan' AND Name = 'numbering_plan' LIMIT 2) = 1) AS v_0 ON v_0.c_0 = g_0.mcc AND v_0.c_1 = g_0.mnc WHERE (SELECT mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN VodafoneNlMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'VodafoneNl' AND Name = 'vodafone_nl' LIMIT 2) = 1

============================================================================

----------------------------------------------------------------------------
OPTIMIZATION COMPLETE:
PROCESSOR PLAN:
AccessNode(13) output=[anon_grp0.agg0 AS expr1] SELECT COUNT(*) FROM VodafoneNlMaterialized.vodafone_nl_cache AS g_0 LEFT OUTER JOIN (SELECT g_1.mobile_country_code AS c_0, g_1.mobile_network_code AS c_1 FROM NumberingPlanMaterialized.numbering_plan_cache AS g_1 WHERE (SELECT mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN NumberingPlanMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'NumberingPlan' AND Name = 'numbering_plan' LIMIT 2) = 1) AS v_0 ON v_0.c_0 = g_0.mcc AND v_0.c_1 = g_0.mnc WHERE (SELECT mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN VodafoneNlMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'VodafoneNl' AND Name = 'vodafone_nl' LIMIT 2) = 1

============================================================================

2017-02-15 13:59:47,591 DEBUG [org.teiid.PLANNER] (Worker179_QueryProcessorQueue87114) XgKeHAtjYhxx [LOW [Materialized View] The query against VodafoneNl.vodafone_nl AS vnl was redirected to the materialization table VodafoneNlMaterialized.vodafone_nl_cache. - null, LOW [Materialized View] The query against NumberingPlan.numbering_plan AS np was redirected to the materialization table NumberingPlanMaterialized.numbering_plan_cache. - null, LOW [Relational Planner] parent join has has no join criteria - Rejecting dependent join Source(groups=[x], props={NESTED_COMMAND=SELECT 1, SYMBOL_MAP={}, OUTPUT_COLS=null}, LOW [Relational Planner] parent join has has no join criteria - Rejecting dependent join Access(groups=[VodafoneNlMaterialized.status], props={SOURCE_HINT=null, MODEL_ID=Schema name=VodafoneNlMaterialized, nameInSource=null, uuid=tid:97ebf59784d5-b8a1140b-00000000, OUTPUT_COLS=null}, LOW [Relational Planner] parent join has has no join criteria - Rejecting dependent join Source(groups=[x AS x__1], props={NESTED_COMMAND=SELECT 1, SYMBOL_MAP={}, OUTPUT_COLS=null}, LOW [Relational Planner] parent join has has no join criteria - Rejecting dependent join Access(groups=[NumberingPlanMaterialized.status], props={SOURCE_HINT=null, MODEL_ID=Schema name=NumberingPlanMaterialized, nameInSource=null, uuid=tid:f41d3bd875ef-f14912f9-00000000, OUTPUT_COLS=null}]
2017-02-15 13:59:47,591 DEBUG [org.teiid.PROCESSOR] (Worker179_QueryProcessorQueue87114) XgKeHAtjYhxx ProcessTree for XgKeHAtjYhxx.18 AccessNode(13) output=[anon_grp0.agg0 AS expr1] SELECT COUNT(*) FROM VodafoneNlMaterialized.vodafone_nl_cache AS g_0 LEFT OUTER JOIN (SELECT g_1.mobile_country_code AS c_0, g_1.mobile_network_code AS c_1 FROM NumberingPlanMaterialized.numbering_plan_cache AS g_1 WHERE (SELECT mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN NumberingPlanMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'NumberingPlan' AND Name = 'numbering_plan' LIMIT 2) = 1) AS v_0 ON v_0.c_0 = g_0.mcc AND v_0.c_1 = g_0.mnc WHERE (SELECT mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION') FROM (SELECT 1) AS x LEFT OUTER JOIN VodafoneNlMaterialized.status ON VDBName = 'CountryServiceListVDB' AND VDBVersion = '1' AND SchemaName = 'VodafoneNl' AND Name = 'vodafone_nl' LIMIT 2) = 1

2017-02-15 13:59:47,592 DEBUG [org.teiid.TXN_LOG] (Worker179_QueryProcessorQueue87114) XgKeHAtjYhxx before getOrCreateTransactionContext:org.teiid.dqp.internal.process.TransactionServerImpl@77dcd5d4(XgKeHAtjYhxx)
2017-02-15 13:59:47,592 DEBUG [org.teiid.TXN_LOG] (Worker179_QueryProcessorQueue87114) XgKeHAtjYhxx after getOrCreateTransactionContext : XgKeHAtjYhxx NONE ID:NONE
2017-02-15 13:59:47,592 DEBUG [org.teiid.BUFFER_MGR] (Worker179_QueryProcessorQueue87114) XgKeHAtjYhxx Creating TupleBuffer: 84988 [anon_grp0.agg0 AS expr1] [class java.lang.Integer] batch size 2048 of type PROCESSOR
2017-02-15 13:59:47,593 TRACE [org.teiid.BUFFER_MGR] (Worker179_QueryProcessorQueue87114) XgKeHAtjYhxx Reserving buffer space 114688 FORCE
2017-02-15 13:59:47,593 DEBUG [org.teiid.BUFFER_MGR] (Worker179_QueryProcessorQueue87114) XgKeHAtjYhxx Creating TupleBuffer: 84989 [mvstatus('NumberingPlan', 'numbering_plan', Valid, LoadState, 'THROW_EXCEPTION')] [class java.lang.Integer] batch size 2048 of type PROCESSOR
2017-02-15 13:59:47,593 TRACE [org.teiid.BUFFER_MGR] (Worker179_QueryProcessorQueue87114) XgKeHAtjYhxx Reserving buffer space 114688 FORCE
2017-02-15 13:59:47,593 TRACE [org.teiid.BUFFER_MGR] (Worker179_QueryProcessorQueue87114) XgKeHAtjYhxx Reserving buffer space 316416 FORCE
2017-02-15 13:59:47,593 DEBUG [org.teiid.CONNECTOR] (Worker179_QueryProcessorQueue87114) XgKeHAtjYhxx XgKeHAtjYhxx.18.12.10756 Create State
2017-02-15 13:59:47,593 TRACE [org.teiid.PROCESSOR] (Worker179_QueryProcessorQueue87114) XgKeHAtjYhxx XgKeHAtjYhxx.18.12.10756 no cache directive
2017-02-15 13:59:47,594 DEBUG [org.teiid.BUFFER_MGR] (Worker179_QueryProcessorQueue87114) XgKeHAtjYhxx Creating TupleBuffer: 84990 [Valid, LoadState] [class java.lang.Boolean, class java.lang.String] batch size 1024 of type PROCESSOR
2017-02-15 13:59:47,594 TRACE [org.teiid.RUNTIME] (Worker180_QueryProcessorQueue87115)  Beginning work with virtual worker Worker180_QueryProcessorQueue87115
2017-02-15 13:59:47,594 DEBUG [org.teiid.BUFFER_MGR] (Worker179_QueryProcessorQueue87114) XgKeHAtjYhxx XgKeHAtjYhxx.18.12.10756 Blocking on source query XgKeHAtjYhxx.18.12.10756
2017-02-15 13:59:47,594 DEBUG [org.teiid.PROCESSOR] (Worker180_QueryProcessorQueue87115) XgKeHAtjYhxx Running task for parent thread Worker179_QueryProcessorQueue87114
2017-02-15 13:59:47,594 DEBUG [org.teiid.BUFFER_MGR] (Worker179_QueryProcessorQueue87114) XgKeHAtjYhxx XgKeHAtjYhxx.18 Blocking on source request(s).
2017-02-15 13:59:47,594 DEBUG [org.teiid.CONNECTOR] (Worker180_QueryProcessorQueue87115) XgKeHAtjYhxx XgKeHAtjYhxx.18.12.10756 Processing NEW request: SELECT g_0.Valid, g_0.LoadState FROM NumberingPlanMaterialized.status AS g_0 WHERE (g_0.VDBName = 'CountryServiceListVDB') AND (g_0.VDBVersion = '1') AND (g_0.SchemaName = 'NumberingPlan') AND (g_0.Name = 'numbering_plan')
2017-02-15 13:59:47,594 DEBUG [org.teiid.BUFFER_MGR] (Worker179_QueryProcessorQueue87114) XgKeHAtjYhxx XgKeHAtjYhxx.18.12.10756 Blocking on source query XgKeHAtjYhxx.18.12.10756
2017-02-15 13:59:47,594 DEBUG [org.teiid.BUFFER_MGR] (Worker179_QueryProcessorQueue87114) XgKeHAtjYhxx XgKeHAtjYhxx.18 Blocking on source request(s).
2017-02-15 13:59:47,594 DEBUG [org.teiid.CONNECTOR] (Worker180_QueryProcessorQueue87115) XgKeHAtjYhxx XgKeHAtjYhxx.18.12.10756 Obtained execution
2017-02-15 13:59:47,594 DEBUG [org.teiid.COMMAND_LOG] (Worker180_QueryProcessorQueue87115) XgKeHAtjYhxx         START DATA SRC COMMAND:       startTime=2017-02-15 13:59:47.594       requestID=XgKeHAtjYhxx.18       sourceCommandID=12      executionID=10756       txID=null     modelName=NumberingPlanMaterialized     translatorName=mysql-override   sessionID=XgKeHAtjYhxx  principal=manel sql=SELECT g_0.Valid, g_0.LoadState FROM NumberingPlanMaterialized.status AS g_0 WHERE (g_0.VDBName = 'CountryServiceListVDB') AND (g_0.VDBVersion = '1') AND (g_0.SchemaName = 'NumberingPlan') AND (g_0.Name = 'numbering_plan')
2017-02-15 13:59:47,595 DEBUG [org.teiid.CONNECTOR] (Worker180_QueryProcessorQueue87115) XgKeHAtjYhxx Source-specific command: SELECT g_0.`Valid`, g_0.`LoadState` FROM `mnom`.`status` AS g_0 WHERE g_0.`VDBName` = 'CountryServiceListVDB' AND g_0.`VDBVersion` = '1' AND g_0.`SchemaName` = 'NumberingPlan' AND g_0.`Name` = 'numbering_plan'
2017-02-15 13:59:47,595 DEBUG [org.teiid.COMMAND_LOG] (Worker180_QueryProcessorQueue87115) XgKeHAtjYhxx         SOURCE SRC COMMAND:  endTime=2017-02-15 13:59:47.595  requestID=XgKeHAtjYhxx.18       sourceCommandID=12      executionID=10756       txID=null       modelName=NumberingPlanMaterialized   translatorName=mysql-override   sessionID=XgKeHAtjYhxx  principal=manel sourceCommand=[SELECT g_0.`Valid`, g_0.`LoadState` FROM `mnom`.`status` AS g_0 WHERE g_0.`VDBName` = 'CountryServiceListVDB' AND g_0.`VDBVersion` = '1' AND g_0.`SchemaName` = 'NumberingPlan' AND g_0.`Name` = 'numbering_plan']
2017-02-15 13:59:47,596 DEBUG [org.teiid.CONNECTOR] (Worker180_QueryProcessorQueue87115) XgKeHAtjYhxx XgKeHAtjYhxx.18.12.10756 Executed command
2017-02-15 13:59:47,596 DEBUG [org.teiid.BUFFER_MGR] (Worker179_QueryProcessorQueue87114) XgKeHAtjYhxx XgKeHAtjYhxx.18.12.10756 Blocking on source query XgKeHAtjYhxx.18.12.10756
2017-02-15 13:59:47,596 DEBUG [org.teiid.CONNECTOR] (Worker180_QueryProcessorQueue87115) XgKeHAtjYhxx XgKeHAtjYhxx.18.12.10756 Processing MORE request
2017-02-15 13:59:47,596 DEBUG [org.teiid.BUFFER_MGR] (Worker179_QueryProcessorQueue87114) XgKeHAtjYhxx XgKeHAtjYhxx.18 Blocking on source request(s).
2017-02-15 13:59:47,596 DEBUG [org.teiid.BUFFER_MGR] (Worker179_QueryProcessorQueue87114) XgKeHAtjYhxx XgKeHAtjYhxx.18.12.10756 Blocking on source query XgKeHAtjYhxx.18.12.10756
2017-02-15 13:59:47,596 DEBUG [org.teiid.CONNECTOR] (Worker180_QueryProcessorQueue87115) XgKeHAtjYhxx XgKeHAtjYhxx.18.12.10756 Getting results from connector
2017-02-15 13:59:47,596 DEBUG [org.teiid.BUFFER_MGR] (Worker179_QueryProcessorQueue87114) XgKeHAtjYhxx XgKeHAtjYhxx.18 Blocking on source request(s).
2017-02-15 13:59:47,596 DEBUG [org.teiid.PROCESSOR] (Worker179_QueryProcessorQueue87114) XgKeHAtjYhxx Request Thread XgKeHAtjYhxx.18 - processor blocked
2017-02-15 13:59:47,596 DEBUG [org.teiid.CONNECTOR] (Worker180_QueryProcessorQueue87115) XgKeHAtjYhxx XgKeHAtjYhxx.18.12.10756 Obtained last batch, total row count: 1
2017-02-15 13:59:47,596 TRACE [org.teiid.PROCESSOR] (Worker179_QueryProcessorQueue87114) XgKeHAtjYhxx XgKeHAtjYhxx.18 end processing WORKING
2017-02-15 13:59:47,596 TRACE [org.teiid.PROCESSOR] (Worker180_QueryProcessorQueue87115) XgKeHAtjYhxx XgKeHAtjYhxx.18 more work IDLE
2017-02-15 13:59:47,596 TRACE [org.teiid.RUNTIME] (Worker179_QueryProcessorQueue87116)  Beginning work with virtual worker Worker179_QueryProcessorQueue87116
2017-02-15 13:59:47,597 TRACE [org.teiid.PROCESSOR] (Worker179_QueryProcessorQueue87116) XgKeHAtjYhxx XgKeHAtjYhxx.18 start processing MORE_WORK
2017-02-15 13:59:47,597 DEBUG [org.teiid.PROCESSOR] (Worker179_QueryProcessorQueue87116) XgKeHAtjYhxx Request Thread XgKeHAtjYhxx.18 with state PROCESSING
2017-02-15 13:59:47,597 TRACE [org.teiid.PROCESSOR] (Worker179_QueryProcessorQueue87116) XgKeHAtjYhxx closed atomic-request: XgKeHAtjYhxx.18.12.10756
2017-02-15 13:59:47,597 DEBUG [org.teiid.CONNECTOR] (Worker179_QueryProcessorQueue87116) XgKeHAtjYhxx XgKeHAtjYhxx.18.12.10756 Remove State
2017-02-15 13:59:47,597 DEBUG [org.teiid.CONNECTOR] (Worker179_QueryProcessorQueue87116) XgKeHAtjYhxx XgKeHAtjYhxx.18.12.10756 Processing Close : SELECT g_0.Valid, g_0.LoadState FROM NumberingPlanMaterialized.status AS g_0 WHERE (g_0.VDBName = 'CountryServiceListVDB') AND (g_0.VDBVersion = '1') AND (g_0.SchemaName = 'NumberingPlan') AND (g_0.Name = 'numbering_plan')
2017-02-15 13:59:47,597 DEBUG [org.teiid.CONNECTOR] (Worker179_QueryProcessorQueue87116) XgKeHAtjYhxx XgKeHAtjYhxx.18.12.10756 Closed execution
2017-02-15 13:59:47,597 DEBUG [org.teiid.CONNECTOR] (Worker179_QueryProcessorQueue87116) XgKeHAtjYhxx XgKeHAtjYhxx.18.12.10756 Closed connection
2017-02-15 13:59:47,597 DEBUG [org.teiid.COMMAND_LOG] (Worker179_QueryProcessorQueue87116) XgKeHAtjYhxx         END SRC COMMAND:     endTime=2017-02-15 13:59:47.597  requestID=XgKeHAtjYhxx.18       sourceCommandID=12      executionID=10756       txID=null       modelName=NumberingPlanMaterialized   translatorName=mysql-override   sessionID=XgKeHAtjYhxx  principal=manel finalRowCount=1 cpuTime(ns)=2083771
2017-02-15 13:59:47,597 TRACE [org.teiid.BUFFER_MGR] (Worker179_QueryProcessorQueue87116) XgKeHAtjYhxx Releasing buffer space 316416
2017-02-15 13:59:47,597 DEBUG [org.teiid.BUFFER_MGR] (Worker179_QueryProcessorQueue87116) XgKeHAtjYhxx Removing TupleBuffer: 84990
2017-02-15 13:59:47,597 DEBUG [org.teiid.PROCESSOR] (Worker179_QueryProcessorQueue87116) XgKeHAtjYhxx QueryProcessor: closing processor
2017-02-15 13:59:47,598 TRACE [org.teiid.BUFFER_MGR] (Worker179_QueryProcessorQueue87116) XgKeHAtjYhxx Releasing buffer space 114688
2017-02-15 13:59:47,598 DEBUG [org.teiid.BUFFER_MGR] (Worker179_QueryProcessorQueue87116) XgKeHAtjYhxx Creating TupleBuffer: 84991 [mvstatus('VodafoneNl', 'vodafone_nl', Valid, LoadState, 'THROW_EXCEPTION')] [class java.lang.Integer] batch size 2048 of type PROCESSOR
2017-02-15 13:59:47,598 TRACE [org.teiid.BUFFER_MGR] (Worker179_QueryProcessorQueue87116) XgKeHAtjYhxx Reserving buffer space 114688 FORCE
2017-02-15 13:59:47,598 TRACE [org.teiid.BUFFER_MGR] (Worker179_QueryProcessorQueue87116) XgKeHAtjYhxx Reserving buffer space 316416 FORCE
2017-02-15 13:59:47,598 DEBUG [org.teiid.CONNECTOR] (Worker179_QueryProcessorQueue87116) XgKeHAtjYhxx XgKeHAtjYhxx.18.6.10757 Create State
2017-02-15 13:59:47,598 TRACE [org.teiid.PROCESSOR] (Worker179_QueryProcessorQueue87116) XgKeHAtjYhxx XgKeHAtjYhxx.18.6.10757 no cache directive
2017-02-15 13:59:47,598 TRACE [org.teiid.RUNTIME] (Worker180_QueryProcessorQueue87117)  Beginning work with virtual worker Worker180_QueryProcessorQueue87117
2017-02-15 13:59:47,598 DEBUG [org.teiid.BUFFER_MGR] (Worker179_QueryProcessorQueue87116) XgKeHAtjYhxx Creating TupleBuffer: 84992 [Valid, LoadState] [class java.lang.Boolean, class java.lang.String] batch size 1024 of type PROCESSOR
2017-02-15 13:59:47,598 DEBUG [org.teiid.BUFFER_MGR] (Worker179_QueryProcessorQueue87116) XgKeHAtjYhxx XgKeHAtjYhxx.18.6.10757 Blocking on source query XgKeHAtjYhxx.18.6.10757
2017-02-15 13:59:47,598 DEBUG [org.teiid.PROCESSOR] (Worker180_QueryProcessorQueue87117) XgKeHAtjYhxx Running task for parent thread Worker179_QueryProcessorQueue87116
2017-02-15 13:59:47,598 DEBUG [org.teiid.BUFFER_MGR] (Worker179_QueryProcessorQueue87116) XgKeHAtjYhxx XgKeHAtjYhxx.18 Blocking on source request(s).
2017-02-15 13:59:47,598 DEBUG [org.teiid.BUFFER_MGR] (Worker179_QueryProcessorQueue87116) XgKeHAtjYhxx XgKeHAtjYhxx.18.6.10757 Blocking on source query XgKeHAtjYhxx.18.6.10757
2017-02-15 13:59:47,598 DEBUG [org.teiid.BUFFER_MGR] (Worker179_QueryProcessorQueue87116) XgKeHAtjYhxx XgKeHAtjYhxx.18 Blocking on source request(s).
2017-02-15 13:59:47,598 DEBUG [org.teiid.CONNECTOR] (Worker180_QueryProcessorQueue87117) XgKeHAtjYhxx XgKeHAtjYhxx.18.6.10757 Processing NEW request: SELECT g_0.Valid, g_0.LoadState FROM VodafoneNlMaterialized.status AS g_0 WHERE (g_0.VDBName = 'CountryServiceListVDB') AND (g_0.VDBVersion = '1') AND (g_0.SchemaName = 'VodafoneNl') AND (g_0.Name = 'vodafone_nl')
2017-02-15 13:59:47,598 DEBUG [org.teiid.PROCESSOR] (Worker179_QueryProcessorQueue87116) XgKeHAtjYhxx Request Thread XgKeHAtjYhxx.18 - processor blocked
2017-02-15 13:59:47,598 TRACE [org.teiid.PROCESSOR] (Worker179_QueryProcessorQueue87116) XgKeHAtjYhxx XgKeHAtjYhxx.18 end processing WORKING
2017-02-15 13:59:47,599 DEBUG [org.teiid.CONNECTOR] (Worker180_QueryProcessorQueue87117) XgKeHAtjYhxx XgKeHAtjYhxx.18.6.10757 Obtained execution
2017-02-15 13:59:47,599 DEBUG [org.teiid.COMMAND_LOG] (Worker180_QueryProcessorQueue87117) XgKeHAtjYhxx         START DATA SRC COMMAND:       startTime=2017-02-15 13:59:47.599       requestID=XgKeHAtjYhxx.18       sourceCommandID=6       executionID=10757       txID=null     modelName=VodafoneNlMaterialized        translatorName=mysql-override   sessionID=XgKeHAtjYhxx  principal=manel sql=SELECT g_0.Valid, g_0.LoadState FROM VodafoneNlMaterialized.status AS g_0 WHERE (g_0.VDBName = 'CountryServiceListVDB') AND (g_0.VDBVersion = '1') AND (g_0.SchemaName = 'VodafoneNl') AND (g_0.Name = 'vodafone_nl')
2017-02-15 13:59:47,599 DEBUG [org.teiid.CONNECTOR] (Worker180_QueryProcessorQueue87117) XgKeHAtjYhxx Source-specific command: SELECT g_0.`Valid`, g_0.`LoadState` FROM `mnom`.`status` AS g_0 WHERE g_0.`VDBName` = 'CountryServiceListVDB' AND g_0.`VDBVersion` = '1' AND g_0.`SchemaName` = 'VodafoneNl' AND g_0.`Name` = 'vodafone_nl'
2017-02-15 13:59:47,599 DEBUG [org.teiid.COMMAND_LOG] (Worker180_QueryProcessorQueue87117) XgKeHAtjYhxx         SOURCE SRC COMMAND:  endTime=2017-02-15 13:59:47.599  requestID=XgKeHAtjYhxx.18       sourceCommandID=6       executionID=10757       txID=null       modelName=VodafoneNlMaterialized      translatorName=mysql-override   sessionID=XgKeHAtjYhxx  principal=manel sourceCommand=[SELECT g_0.`Valid`, g_0.`LoadState` FROM `mnom`.`status` AS g_0 WHERE g_0.`VDBName` = 'CountryServiceListVDB' AND g_0.`VDBVersion` = '1' AND g_0.`SchemaName` = 'VodafoneNl' AND g_0.`Name` = 'vodafone_nl']
2017-02-15 13:59:47,600 DEBUG [org.teiid.CONNECTOR] (Worker180_QueryProcessorQueue87117) XgKeHAtjYhxx XgKeHAtjYhxx.18.6.10757 Executed command
2017-02-15 13:59:47,600 DEBUG [org.teiid.CONNECTOR] (Worker180_QueryProcessorQueue87117) XgKeHAtjYhxx XgKeHAtjYhxx.18.6.10757 Processing MORE request
2017-02-15 13:59:47,600 DEBUG [org.teiid.CONNECTOR] (Worker180_QueryProcessorQueue87117) XgKeHAtjYhxx XgKeHAtjYhxx.18.6.10757 Getting results from connector
2017-02-15 13:59:47,600 DEBUG [org.teiid.CONNECTOR] (Worker180_QueryProcessorQueue87117) XgKeHAtjYhxx XgKeHAtjYhxx.18.6.10757 Obtained last batch, total row count: 1
2017-02-15 13:59:47,600 TRACE [org.teiid.PROCESSOR] (Worker180_QueryProcessorQueue87117) XgKeHAtjYhxx XgKeHAtjYhxx.18 more work IDLE
2017-02-15 13:59:47,600 TRACE [org.teiid.RUNTIME] (Worker179_QueryProcessorQueue87118)  Beginning work with virtual worker Worker179_QueryProcessorQueue87118
2017-02-15 13:59:47,600 TRACE [org.teiid.PROCESSOR] (Worker179_QueryProcessorQueue87118) XgKeHAtjYhxx XgKeHAtjYhxx.18 start processing MORE_WORK
2017-02-15 13:59:47,600 DEBUG [org.teiid.PROCESSOR] (Worker179_QueryProcessorQueue87118) XgKeHAtjYhxx Request Thread XgKeHAtjYhxx.18 with state PROCESSING
2017-02-15 13:59:47,601 TRACE [org.teiid.PROCESSOR] (Worker179_QueryProcessorQueue87118) XgKeHAtjYhxx closed atomic-request: XgKeHAtjYhxx.18.6.10757
2017-02-15 13:59:47,601 DEBUG [org.teiid.CONNECTOR] (Worker179_QueryProcessorQueue87118) XgKeHAtjYhxx XgKeHAtjYhxx.18.6.10757 Remove State
2017-02-15 13:59:47,601 DEBUG [org.teiid.CONNECTOR] (Worker179_QueryProcessorQueue87118) XgKeHAtjYhxx XgKeHAtjYhxx.18.6.10757 Processing Close : SELECT g_0.Valid, g_0.LoadState FROM VodafoneNlMaterialized.status AS g_0 WHERE (g_0.VDBName = 'CountryServiceListVDB') AND (g_0.VDBVersion = '1') AND (g_0.SchemaName = 'VodafoneNl') AND (g_0.Name = 'vodafone_nl')
2017-02-15 13:59:47,601 DEBUG [org.teiid.CONNECTOR] (Worker179_QueryProcessorQueue87118) XgKeHAtjYhxx XgKeHAtjYhxx.18.6.10757 Closed execution
2017-02-15 13:59:47,601 DEBUG [org.teiid.CONNECTOR] (Worker179_QueryProcessorQueue87118) XgKeHAtjYhxx XgKeHAtjYhxx.18.6.10757 Closed connection
2017-02-15 13:59:47,601 DEBUG [org.teiid.COMMAND_LOG] (Worker179_QueryProcessorQueue87118) XgKeHAtjYhxx         END SRC COMMAND:     endTime=2017-02-15 13:59:47.601  requestID=XgKeHAtjYhxx.18       sourceCommandID=6       executionID=10757       txID=null       modelName=VodafoneNlMaterialized      translatorName=mysql-override   sessionID=XgKeHAtjYhxx  principal=manel finalRowCount=1 cpuTime(ns)=1469795
2017-02-15 13:59:47,601 TRACE [org.teiid.BUFFER_MGR] (Worker179_QueryProcessorQueue87118) XgKeHAtjYhxx Releasing buffer space 316416
2017-02-15 13:59:47,601 DEBUG [org.teiid.BUFFER_MGR] (Worker179_QueryProcessorQueue87118) XgKeHAtjYhxx Removing TupleBuffer: 84992
2017-02-15 13:59:47,601 DEBUG [org.teiid.PROCESSOR] (Worker179_QueryProcessorQueue87118) XgKeHAtjYhxx QueryProcessor: closing processor
2017-02-15 13:59:47,601 TRACE [org.teiid.BUFFER_MGR] (Worker179_QueryProcessorQueue87118) XgKeHAtjYhxx Releasing buffer space 114688
2017-02-15 13:59:47,601 DEBUG [org.teiid.CONNECTOR] (Worker179_QueryProcessorQueue87118) XgKeHAtjYhxx XgKeHAtjYhxx.18.13.10758 Create State
2017-02-15 13:59:47,601 TRACE [org.teiid.PROCESSOR] (Worker179_QueryProcessorQueue87118) XgKeHAtjYhxx XgKeHAtjYhxx.18.13.10758 no cache directive
2017-02-15 13:59:47,602 DEBUG [org.teiid.BUFFER_MGR] (Worker179_QueryProcessorQueue87118) XgKeHAtjYhxx XgKeHAtjYhxx.18.13.10758 Blocking on source query XgKeHAtjYhxx.18.13.10758
2017-02-15 13:59:47,602 DEBUG [org.teiid.BUFFER_MGR] (Worker179_QueryProcessorQueue87118) XgKeHAtjYhxx XgKeHAtjYhxx.18 Blocking on source request(s).
2017-02-15 13:59:47,602 TRACE [org.teiid.RUNTIME] (Worker180_QueryProcessorQueue87119)  Beginning work with virtual worker Worker180_QueryProcessorQueue87119
2017-02-15 13:59:47,602 DEBUG [org.teiid.PROCESSOR] (Worker179_QueryProcessorQueue87118) XgKeHAtjYhxx Request Thread XgKeHAtjYhxx.18 - processor blocked
2017-02-15 13:59:47,602 DEBUG [org.teiid.PROCESSOR] (Worker180_QueryProcessorQueue87119) XgKeHAtjYhxx Running task for parent thread Worker179_QueryProcessorQueue87118
2017-02-15 13:59:47,602 TRACE [org.teiid.PROCESSOR] (Worker179_QueryProcessorQueue87118) XgKeHAtjYhxx XgKeHAtjYhxx.18 end processing WORKING
2017-02-15 13:59:47,602 DEBUG [org.teiid.CONNECTOR] (Worker180_QueryProcessorQueue87119) XgKeHAtjYhxx XgKeHAtjYhxx.18.13.10758 Processing NEW request: SELECT COUNT(*) FROM VodafoneNlMaterialized.vodafone_nl_cache AS g_0 LEFT OUTER JOIN (SELECT g_1.mobile_country_code AS c_0, g_1.mobile_network_code AS c_1 FROM NumberingPlanMaterialized.numbering_plan_cache AS g_1) AS v_0 ON v_0.c_0 = g_0.mcc AND v_0.c_1 = g_0.mnc
2017-02-15 13:59:47,602 DEBUG [org.teiid.CONNECTOR] (Worker180_QueryProcessorQueue87119) XgKeHAtjYhxx XgKeHAtjYhxx.18.13.10758 Obtained execution
2017-02-15 13:59:47,602 DEBUG [org.teiid.COMMAND_LOG] (Worker180_QueryProcessorQueue87119) XgKeHAtjYhxx         START DATA SRC COMMAND:       startTime=2017-02-15 13:59:47.602       requestID=XgKeHAtjYhxx.18       sourceCommandID=13      executionID=10758       txID=null     modelName=NumberingPlanMaterialized     translatorName=mysql-override   sessionID=XgKeHAtjYhxx  principal=manel sql=SELECT COUNT(*) FROM VodafoneNlMaterialized.vodafone_nl_cache AS g_0 LEFT OUTER JOIN (SELECT g_1.mobile_country_code AS c_0, g_1.mobile_network_code AS c_1 FROM NumberingPlanMaterialized.numbering_plan_cache AS g_1) AS v_0 ON v_0.c_0 = g_0.mcc AND v_0.c_1 = g_0.mnc
2017-02-15 13:59:47,602 DEBUG [org.teiid.CONNECTOR] (Worker180_QueryProcessorQueue87119) XgKeHAtjYhxx Source-specific command: SELECT COUNT(*) FROM `mnom`.`vodafone_nl_cache` AS g_0 LEFT OUTER JOIN (SELECT g_1.`mobile_country_code` AS c_0, g_1.`mobile_network_code` AS c_1 FROM `mnom`.`numbering_plan_cache` AS g_1) AS v_0 ON v_0.c_0 = g_0.`mcc` AND v_0.c_1 = g_0.`mnc`
2017-02-15 13:59:47,602 DEBUG [org.teiid.COMMAND_LOG] (Worker180_QueryProcessorQueue87119) XgKeHAtjYhxx         SOURCE SRC COMMAND:  endTime=2017-02-15 13:59:47.602  requestID=XgKeHAtjYhxx.18       sourceCommandID=13      executionID=10758       txID=null       modelName=NumberingPlanMaterialized   translatorName=mysql-override   sessionID=XgKeHAtjYhxx  principal=manel sourceCommand=[SELECT COUNT(*) FROM `mnom`.`vodafone_nl_cache` AS g_0 LEFT OUTER JOIN (SELECT g_1.`mobile_country_code` AS c_0, g_1.`mobile_network_code` AS c_1 FROM `mnom`.`numbering_plan_cache` AS g_1) AS v_0 ON v_0.c_0 = g_0.`mcc` AND v_0.c_1 = g_0.`mnc`]

==> teiid-command.log <==
13:59:47,594 DEBUG [org.teiid.COMMAND_LOG] (Worker180_QueryProcessorQueue87115) XgKeHAtjYhxx    START DATA SRC COMMAND: startTime=2017-02-15 13:59:47.594     requestID=XgKeHAtjYhxx.18       sourceCommandID=12      executionID=10756       txID=null       modelName=NumberingPlanMaterialized   translatorName=mysql-override   sessionID=XgKeHAtjYhxx  principal=manel sql=SELECT g_0.Valid, g_0.LoadState FROM NumberingPlanMaterialized.status AS g_0 WHERE (g_0.VDBName = 'CountryServiceListVDB') AND (g_0.VDBVersion = '1') AND (g_0.SchemaName = 'NumberingPlan') AND (g_0.Name = 'numbering_plan')
13:59:47,595 DEBUG [org.teiid.COMMAND_LOG] (Worker180_QueryProcessorQueue87115) XgKeHAtjYhxx    SOURCE SRC COMMAND:     endTime=2017-02-15 13:59:47.595       requestID=XgKeHAtjYhxx.18       sourceCommandID=12      executionID=10756       txID=null       modelName=NumberingPlanMaterialized   translatorName=mysql-override   sessionID=XgKeHAtjYhxx  principal=manel sourceCommand=[SELECT g_0.`Valid`, g_0.`LoadState` FROM `mnom`.`status` AS g_0 WHERE g_0.`VDBName` = 'CountryServiceListVDB' AND g_0.`VDBVersion` = '1' AND g_0.`SchemaName` = 'NumberingPlan' AND g_0.`Name` = 'numbering_plan']
13:59:47,597 DEBUG [org.teiid.COMMAND_LOG] (Worker179_QueryProcessorQueue87116) XgKeHAtjYhxx    END SRC COMMAND:        endTime=2017-02-15 13:59:47.597       requestID=XgKeHAtjYhxx.18       sourceCommandID=12      executionID=10756       txID=null       modelName=NumberingPlanMaterialized   translatorName=mysql-override   sessionID=XgKeHAtjYhxx  principal=manel finalRowCount=1 cpuTime(ns)=2083771
13:59:47,599 DEBUG [org.teiid.COMMAND_LOG] (Worker180_QueryProcessorQueue87117) XgKeHAtjYhxx    START DATA SRC COMMAND: startTime=2017-02-15 13:59:47.599     requestID=XgKeHAtjYhxx.18       sourceCommandID=6       executionID=10757       txID=null       modelName=VodafoneNlMaterialized      translatorName=mysql-override   sessionID=XgKeHAtjYhxx  principal=manel sql=SELECT g_0.Valid, g_0.LoadState FROM VodafoneNlMaterialized.status AS g_0 WHERE (g_0.VDBName = 'CountryServiceListVDB') AND (g_0.VDBVersion = '1') AND (g_0.SchemaName = 'VodafoneNl') AND (g_0.Name = 'vodafone_nl')
13:59:47,599 DEBUG [org.teiid.COMMAND_LOG] (Worker180_QueryProcessorQueue87117) XgKeHAtjYhxx    SOURCE SRC COMMAND:     endTime=2017-02-15 13:59:47.599       requestID=XgKeHAtjYhxx.18       sourceCommandID=6       executionID=10757       txID=null       modelName=VodafoneNlMaterialized      translatorName=mysql-override   sessionID=XgKeHAtjYhxx  principal=manel sourceCommand=[SELECT g_0.`Valid`, g_0.`LoadState` FROM `mnom`.`status` AS g_0 WHERE g_0.`VDBName` = 'CountryServiceListVDB' AND g_0.`VDBVersion` = '1' AND g_0.`SchemaName` = 'VodafoneNl' AND g_0.`Name` = 'vodafone_nl']
13:59:47,601 DEBUG [org.teiid.COMMAND_LOG] (Worker179_QueryProcessorQueue87118) XgKeHAtjYhxx    END SRC COMMAND:        endTime=2017-02-15 13:59:47.601       requestID=XgKeHAtjYhxx.18       sourceCommandID=6       executionID=10757       txID=null       modelName=VodafoneNlMaterialized      translatorName=mysql-override   sessionID=XgKeHAtjYhxx  principal=manel finalRowCount=1 cpuTime(ns)=1469795
13:59:47,602 DEBUG [org.teiid.COMMAND_LOG] (Worker180_QueryProcessorQueue87119) XgKeHAtjYhxx    START DATA SRC COMMAND: startTime=2017-02-15 13:59:47.602     requestID=XgKeHAtjYhxx.18       sourceCommandID=13      executionID=10758       txID=null       modelName=NumberingPlanMaterialized   translatorName=mysql-override   sessionID=XgKeHAtjYhxx  principal=manel sql=SELECT COUNT(*) FROM VodafoneNlMaterialized.vodafone_nl_cache AS g_0 LEFT OUTER JOIN (SELECT g_1.mobile_country_code AS c_0, g_1.mobile_network_code AS c_1 FROM NumberingPlanMaterialized.numbering_plan_cache AS g_1) AS v_0 ON v_0.c_0 = g_0.mcc AND v_0.c_1 = g_0.mnc
13:59:47,602 DEBUG [org.teiid.COMMAND_LOG] (Worker180_QueryProcessorQueue87119) XgKeHAtjYhxx    SOURCE SRC COMMAND:     endTime=2017-02-15 13:59:47.602       requestID=XgKeHAtjYhxx.18       sourceCommandID=13      executionID=10758       txID=null       modelName=NumberingPlanMaterialized   translatorName=mysql-override   sessionID=XgKeHAtjYhxx  principal=manel sourceCommand=[SELECT COUNT(*) FROM `mnom`.`vodafone_nl_cache` AS g_0 LEFT OUTER JOIN (SELECT g_1.`mobile_country_code` AS c_0, g_1.`mobile_network_code` AS c_1 FROM `mnom`.`numbering_plan_cache` AS g_1) AS v_0 ON v_0.c_0 = g_0.`mcc` AND v_0.c_1 = g_0.`mnc`]

==> server.log <==

==> teiid-command.log <==

==> server.log <==

==> teiid-command.log <==

==> server.log <==

==> teiid-command.log <==

==> server.log <==

==> teiid-command.log <==

==> server.log <==

==> teiid-command.log <==

==> server.log <==

==> teiid-command.log <==

==> server.log <==

==> teiid-command.log <==

==> server.log <==
2017-02-15 14:00:09,635 DEBUG [org.teiid.CONNECTOR] (Worker180_QueryProcessorQueue87119) XgKeHAtjYhxx XgKeHAtjYhxx.18.13.10758 Executed command
2017-02-15 14:00:09,636 DEBUG [org.teiid.CONNECTOR] (Worker180_QueryProcessorQueue87119) XgKeHAtjYhxx XgKeHAtjYhxx.18.13.10758 Processing MORE request
2017-02-15 14:00:09,636 DEBUG [org.teiid.CONNECTOR] (Worker180_QueryProcessorQueue87119) XgKeHAtjYhxx XgKeHAtjYhxx.18.13.10758 Getting results from connector
2017-02-15 14:00:09,636 DEBUG [org.teiid.CONNECTOR] (Worker180_QueryProcessorQueue87119) XgKeHAtjYhxx XgKeHAtjYhxx.18.13.10758 Obtained last batch, total row count: 1
2017-02-15 14:00:09,636 TRACE [org.teiid.PROCESSOR] (Worker180_QueryProcessorQueue87119) XgKeHAtjYhxx XgKeHAtjYhxx.18 more work IDLE
2017-02-15 14:00:09,636 TRACE [org.teiid.RUNTIME] (Worker179_QueryProcessorQueue87120)  Beginning work with virtual worker Worker179_QueryProcessorQueue87120
2017-02-15 14:00:09,636 TRACE [org.teiid.PROCESSOR] (Worker179_QueryProcessorQueue87120) XgKeHAtjYhxx XgKeHAtjYhxx.18 start processing MORE_WORK
2017-02-15 14:00:09,636 DEBUG [org.teiid.PROCESSOR] (Worker179_QueryProcessorQueue87120) XgKeHAtjYhxx Request Thread XgKeHAtjYhxx.18 with state PROCESSING
2017-02-15 14:00:09,637 TRACE [org.teiid.PROCESSOR] (Worker179_QueryProcessorQueue87120) XgKeHAtjYhxx closed atomic-request: XgKeHAtjYhxx.18.13.10758
2017-02-15 14:00:09,637 DEBUG [org.teiid.CONNECTOR] (Worker179_QueryProcessorQueue87120) XgKeHAtjYhxx XgKeHAtjYhxx.18.13.10758 Remove State
2017-02-15 14:00:09,637 DEBUG [org.teiid.CONNECTOR] (Worker179_QueryProcessorQueue87120) XgKeHAtjYhxx XgKeHAtjYhxx.18.13.10758 Processing Close : SELECT COUNT(*) FROM VodafoneNlMaterialized.vodafone_nl_cache AS g_0 LEFT OUTER JOIN (SELECT g_1.mobile_country_code AS c_0, g_1.mobile_network_code AS c_1 FROM NumberingPlanMaterialized.numbering_plan_cache AS g_1) AS v_0 ON v_0.c_0 = g_0.mcc AND v_0.c_1 = g_0.mnc
2017-02-15 14:00:09,637 DEBUG [org.teiid.CONNECTOR] (Worker179_QueryProcessorQueue87120) XgKeHAtjYhxx XgKeHAtjYhxx.18.13.10758 Closed execution
2017-02-15 14:00:09,637 DEBUG [org.teiid.CONNECTOR] (Worker179_QueryProcessorQueue87120) XgKeHAtjYhxx XgKeHAtjYhxx.18.13.10758 Closed connection

==> teiid-command.log <==
14:00:09,637 DEBUG [org.teiid.COMMAND_LOG] (Worker179_QueryProcessorQueue87120) XgKeHAtjYhxx    END SRC COMMAND:        endTime=2017-02-15 14:00:09.637       requestID=XgKeHAtjYhxx.18       sourceCommandID=13      executionID=10758       txID=null       modelName=NumberingPlanMaterialized   translatorName=mysql-override   sessionID=XgKeHAtjYhxx  principal=manel finalRowCount=1 cpuTime(ns)=2190969

==> server.log <==
2017-02-15 14:00:09,637 DEBUG [org.teiid.COMMAND_LOG] (Worker179_QueryProcessorQueue87120) XgKeHAtjYhxx         END SRC COMMAND:     endTime=2017-02-15 14:00:09.637  requestID=XgKeHAtjYhxx.18       sourceCommandID=13      executionID=10758       txID=null       modelName=NumberingPlanMaterialized   translatorName=mysql-override   sessionID=XgKeHAtjYhxx  principal=manel finalRowCount=1 cpuTime(ns)=2190969
2017-02-15 14:00:09,637 DEBUG [org.teiid.BUFFER_MGR] (Worker179_QueryProcessorQueue87120) XgKeHAtjYhxx Removing TupleBuffer: 84989
2017-02-15 14:00:09,637 DEBUG [org.teiid.BUFFER_MGR] (Worker179_QueryProcessorQueue87120) XgKeHAtjYhxx Removing TupleBuffer: 84991
2017-02-15 14:00:09,637 DEBUG [org.teiid.PROCESSOR] (Worker179_QueryProcessorQueue87120) XgKeHAtjYhxx QueryProcessor: closing processor
2017-02-15 14:00:09,637 TRACE [org.teiid.BUFFER_MGR] (Worker179_QueryProcessorQueue87120) XgKeHAtjYhxx Releasing buffer space 114688
2017-02-15 14:00:09,637 DEBUG [org.teiid.PROCESSOR] (Worker179_QueryProcessorQueue87120) XgKeHAtjYhxx XgKeHAtjYhxx.18 Finished Processing
2017-02-15 14:00:09,637 DEBUG [org.teiid.PROCESSOR] (Worker179_QueryProcessorQueue87120) XgKeHAtjYhxx [RequestWorkItem.sendResultsIfNeeded] requestID: XgKeHAtjYhxx.18 resultsID: 84988 done: true
2017-02-15 14:00:09,638 DEBUG [org.teiid.TRANSPORT] (Worker179_QueryProcessorQueue87120) XgKeHAtjYhxx send message: MessageHolder: key=2532 contents=ResultsMessage rowCount=1 finalRow=1
2017-02-15 14:00:09,638 TRACE [org.teiid.PROCESSOR] (Worker179_QueryProcessorQueue87120) XgKeHAtjYhxx XgKeHAtjYhxx.18 end processing WORKING
2017-02-15 14:00:09,640 DEBUG [org.teiid.TRANSPORT] (NIO5)  processing message:MessageHolder: key=2533 contents=Invoke interface org.teiid.client.DQP.getMetadata
2017-02-15 14:00:09,641 TRACE [org.teiid.PROCESSOR] (NIO5) XgKeHAtjYhxx before getMetadata:org.teiid.dqp.internal.process.DQPCore@67f89af4(18)
2017-02-15 14:00:09,641 TRACE [org.teiid.PROCESSOR] (NIO5) XgKeHAtjYhxx after getMetadata : org.teiid.client.metadata.MetadataResult@2d7cc551
2017-02-15 14:00:09,641 DEBUG [org.teiid.TRANSPORT] (NIO5) XgKeHAtjYhxx send message: MessageHolder: key=2533 contents=org.teiid.client.metadata.MetadataResult@2d7cc551
2017-02-15 14:00:09,643 DEBUG [org.teiid.TRANSPORT] (NIO5)  processing message:MessageHolder: key=2534 contents=Invoke interface org.teiid.client.DQP.closeRequest
2017-02-15 14:00:09,643 TRACE [org.teiid.PROCESSOR] (NIO5) XgKeHAtjYhxx before closeRequest:org.teiid.dqp.internal.process.DQPCore@67f89af4(18)
2017-02-15 14:00:09,644 DEBUG [org.teiid.PROCESSOR] (NIO5) XgKeHAtjYhxx closeQuery for requestID=XgKeHAtjYhxx.18
2017-02-15 14:00:09,644 TRACE [org.teiid.PROCESSOR] (NIO5) XgKeHAtjYhxx XgKeHAtjYhxx.18 more work IDLE
2017-02-15 14:00:09,644 TRACE [org.teiid.PROCESSOR] (NIO5) XgKeHAtjYhxx after closeRequest : org.teiid.client.util.ResultsFuture@4b211123
2017-02-15 14:00:09,644 TRACE [org.teiid.RUNTIME] (Worker179_QueryProcessorQueue87121)  Beginning work with virtual worker Worker179_QueryProcessorQueue87121
2017-02-15 14:00:09,644 DEBUG [org.teiid.TRANSPORT] (NIO5) XgKeHAtjYhxx send message: MessageHolder: key=2534 contents=null
2017-02-15 14:00:09,644 TRACE [org.teiid.PROCESSOR] (Worker179_QueryProcessorQueue87121) XgKeHAtjYhxx XgKeHAtjYhxx.18 start processing MORE_WORK
2017-02-15 14:00:09,644 DEBUG [org.teiid.PROCESSOR] (Worker179_QueryProcessorQueue87121) XgKeHAtjYhxx Request Thread XgKeHAtjYhxx.18 with state CLOSE
2017-02-15 14:00:09,644 DEBUG [org.teiid.PROCESSOR] (Worker179_QueryProcessorQueue87121) XgKeHAtjYhxx Removing tuplesource for the request XgKeHAtjYhxx.18
2017-02-15 14:00:09,644 DEBUG [org.teiid.BUFFER_MGR] (Worker179_QueryProcessorQueue87121) XgKeHAtjYhxx Removing TupleBuffer: 84988

==> teiid-command.log <==
14:00:09,644 INFO  [org.teiid.COMMAND_LOG] (Worker179_QueryProcessorQueue87121) XgKeHAtjYhxx    END USER COMMAND:       endTime=2017-02-15 14:00:09.644       requestID=XgKeHAtjYhxx.18       txID=null       sessionID=XgKeHAtjYhxx  principal=manel vdbName=CountryServiceListVDB vdbVersion=1    finalRowCount=1

==> server.log <==
2017-02-15 14:00:09,644 INFO  [org.teiid.COMMAND_LOG] (Worker179_QueryProcessorQueue87121) XgKeHAtjYhxx         END USER COMMAND:    endTime=2017-02-15 14:00:09.644  requestID=XgKeHAtjYhxx.18       txID=null       sessionID=XgKeHAtjYhxx  principal=manel vdbName=CountryServiceListVDB vdbVersion=1    finalRowCount=1
2017-02-15 14:00:09,644 TRACE [org.teiid.PROCESSOR] (Worker179_QueryProcessorQueue87121) XgKeHAtjYhxx XgKeHAtjYhxx.18 end processing WORKING
2017-02-15 14:00:09,645 TRACE [org.teiid.PROCESSOR] (Worker179_QueryProcessorQueue87121) XgKeHAtjYhxx XgKeHAtjYhxx.18 done processing WORKING
2017-02-15 14:00:22,736 DEBUG [org.teiid.TRANSPORT] (NIO5)  processing message:MessageHolder: key=2535 contents=Invoke interface org.teiid.client.security.ILogon.ping
2017-02-15 14:00:22,737 TRACE [org.teiid.SECURITY] (NIO5)  Ping null
2017-02-15 14:00:22,737 DEBUG [org.teiid.TRANSPORT] (NIO5)  send message: MessageHolder: key=2535 contents=null
2017-02-15 14:00:22,739 DEBUG [org.teiid.TRANSPORT] (NIO5)  processing message:MessageHolder: key=2536 contents=Invoke interface org.teiid.client.security.ILogon.ping
2017-02-15 14:00:22,739 DEBUG [org.teiid.SECURITY] (NIO5)  Keep-alive ping received for session: XgKeHAtjYhxx
2017-02-15 14:00:22,739 DEBUG [org.teiid.SECURITY] (NIO5)  Keep-alive ping received for session: t1sHxoM3FjUP
2017-02-15 14:00:22,739 DEBUG [org.teiid.TRANSPORT] (NIO5)  send message: MessageHolder: key=2536 contents=null