Skip to content

Instantly share code, notes, and snippets.

@tejones

tejones/gist:6250290

Created August 16, 2013 14:14
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tejones/6250290 to your computer and use it in GitHub Desktop.
Save tejones/6250290 to your computer and use it in GitHub Desktop.
Download ZIP
Teiid StackOverflow
Raw
gistfile1.txt
08:14:35,369 INFO [org.teiid.PLANNER] (Worker4_QueryProcessorQueue33) UaJGf50FZmif
============================================================================
USER COMMAND:
SELECT * FROM sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView
----------------------------------------------------------------------------
OPTIMIZE:
SELECT * FROM sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView
----------------------------------------------------------------------------
GENERATE CANONICAL:
SELECT * FROM sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView
CANONICAL PLAN:
Project(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView], props={PROJECT_COLS=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:countryFrom", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:cityFrom", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:airportFrom", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:countryTo", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:cityTo", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:airportTo", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:flightTime", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:departureTime", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:arrivalTime", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:distance", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:distanceUnit", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:flightType", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:period", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:carrid", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:connid", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:fldate", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:PRICE", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:CURRENCY", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:PLANETYPE", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:SEATSMAX", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:SEATSOCC"]})
Source(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView], props={NESTED_COMMAND=SELECT A."d:countryFrom" AS "d:countryFrom", A."d:cityFrom" AS "d:cityFrom", A."d:airportFrom" AS "d:airportFrom", A."d:countryTo" AS "d:countryTo", A."d:cityTo" AS "d:cityTo", A."d:airportTo" AS "d:airportTo", A."d:flightTime" AS "d:flightTime", A."d:departureTime" AS "d:departureTime", A."d:arrivalTime" AS "d:arrivalTime", A."d:distance" AS "d:distance", A."d:distanceUnit" AS "d:distanceUnit", A."d:flightType" AS "d:flightType", A."d:period" AS "d:period", A."d:carrid" AS "d:carrid", A."d:connid" AS "d:connid", A."d:fldate" AS "d:fldate", A."d:PRICE" AS "d:PRICE", A."d:CURRENCY" AS "d:CURRENCY", A."d:PLANETYPE" AS "d:PLANETYPE", A."d:SEATSMAX" AS "d:SEATSMAX", A."d:SEATSOCC" AS "d:SEATSOCC" FROM (EXEC sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp('GET', null, 'https://sapes1.sapdevcenter.com/sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection', TRUE)) AS f CROSS JOIN XMLTABLE(XMLNAMESPACES(DEFAULT 'http://www.w3.org/2005/Atom', 'http://schemas.microsoft.com/ado/2007/08/dataservices' AS d, 'http://schemas.microsoft.com/ado/2007/08/dataservices/metadata' AS m), '/feed/entry/content/m:properties' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS "d:countryFrom" string PATH 'd:flightDetails/d:countryFrom/text()', "d:cityFrom" string PATH 'd:flightDetails/d:cityFrom/text()', "d:airportFrom" string PATH 'd:flightDetails/d:airportFrom/text()', "d:countryTo" string PATH 'd:flightDetails/d:countryTo/text()', "d:cityTo" string PATH 'd:flightDetails/d:cityTo/text()', "d:airportTo" string PATH 'd:flightDetails/d:airportTo/text()', "d:flightTime" string PATH 'd:flightDetails/d:flightTime/text()', "d:departureTime" string PATH 'd:flightDetails/d:departureTime/text()', "d:arrivalTime" string PATH 'd:flightDetails/d:arrivalTime/text()', "d:distance" string PATH 'd:flightDetails/d:distance/text()', "d:distanceUnit" string PATH 'd:flightDetails/d:distanceUnit/text()', "d:flightType" string PATH 'd:flightDetails/d:flightType/text()', "d:period" string PATH 'd:flightDetails/d:period/text()', "d:carrid" string PATH 'd:carrid/text()', "d:connid" string PATH 'd:connid/text()', "d:fldate" string PATH 'd:fldate/text()', "d:PRICE" string PATH 'd:PRICE/text()', "d:CURRENCY" string PATH 'd:CURRENCY/text()', "d:PLANETYPE" string PATH 'd:PLANETYPE/text()', "d:SEATSMAX" string PATH 'd:SEATSMAX/text()', "d:SEATSOCC" string PATH 'd:SEATSOCC/text()') AS A, SYMBOL_MAP={sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:countryFrom"=A."d:countryFrom", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:cityFrom"=A."d:cityFrom", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:airportFrom"=A."d:airportFrom", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:countryTo"=A."d:countryTo", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:cityTo"=A."d:cityTo", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:airportTo"=A."d:airportTo", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:flightTime"=A."d:flightTime", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:departureTime"=A."d:departureTime", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:arrivalTime"=A."d:arrivalTime", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:distance"=A."d:distance", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:distanceUnit"=A."d:distanceUnit", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:flightType"=A."d:flightType", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:period"=A."d:period", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:carrid"=A."d:carrid", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:connid"=A."d:connid", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:fldate"=A."d:fldate", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:PRICE"=A."d:PRICE", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:CURRENCY"=A."d:CURRENCY", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:PLANETYPE"=A."d:PLANETYPE", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:SEATSMAX"=A."d:SEATSMAX", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:SEATSOCC"=A."d:SEATSOCC"}})
Project(groups=[A], props={PROJECT_COLS=[A."d:countryFrom" AS "d:countryFrom", A."d:cityFrom" AS "d:cityFrom", A."d:airportFrom" AS "d:airportFrom", A."d:countryTo" AS "d:countryTo", A."d:cityTo" AS "d:cityTo", A."d:airportTo" AS "d:airportTo", A."d:flightTime" AS "d:flightTime", A."d:departureTime" AS "d:departureTime", A."d:arrivalTime" AS "d:arrivalTime", A."d:distance" AS "d:distance", A."d:distanceUnit" AS "d:distanceUnit", A."d:flightType" AS "d:flightType", A."d:period" AS "d:period", A."d:carrid" AS "d:carrid", A."d:connid" AS "d:connid", A."d:fldate" AS "d:fldate", A."d:PRICE" AS "d:PRICE", A."d:CURRENCY" AS "d:CURRENCY", A."d:PLANETYPE" AS "d:PLANETYPE", A."d:SEATSMAX" AS "d:SEATSMAX", A."d:SEATSOCC" AS "d:SEATSOCC"]})
Join(groups=[f, A], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[]})
Source(groups=[f], props={NESTED_COMMAND=EXEC sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp('GET', null, 'https://sapes1.sapdevcenter.com/sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection', TRUE), SYMBOL_MAP={f.result=sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.result, f.contentType=sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.contentType}})
Project(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp], props={PROJECT_COLS=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.result, sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.contentType]})
Source(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp], props={VIRTUAL_COMMAND=EXEC sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp('GET', null, 'https://sapes1.sapdevcenter.com/sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection', TRUE)})
Source(groups=[A], props={TABLE_FUNCTION=XMLTABLE(XMLNAMESPACES(DEFAULT 'http://www.w3.org/2005/Atom', 'http://schemas.microsoft.com/ado/2007/08/dataservices' AS d, 'http://schemas.microsoft.com/ado/2007/08/dataservices/metadata' AS m), '/feed/entry/content/m:properties' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS "d:countryFrom" string PATH 'd:flightDetails/d:countryFrom/text()', "d:cityFrom" string PATH 'd:flightDetails/d:cityFrom/text()', "d:airportFrom" string PATH 'd:flightDetails/d:airportFrom/text()', "d:countryTo" string PATH 'd:flightDetails/d:countryTo/text()', "d:cityTo" string PATH 'd:flightDetails/d:cityTo/text()', "d:airportTo" string PATH 'd:flightDetails/d:airportTo/text()', "d:flightTime" string PATH 'd:flightDetails/d:flightTime/text()', "d:departureTime" string PATH 'd:flightDetails/d:departureTime/text()', "d:arrivalTime" string PATH 'd:flightDetails/d:arrivalTime/text()', "d:distance" string PATH 'd:flightDetails/d:distance/text()', "d:distanceUnit" string PATH 'd:flightDetails/d:distanceUnit/text()', "d:flightType" string PATH 'd:flightDetails/d:flightType/text()', "d:period" string PATH 'd:flightDetails/d:period/text()', "d:carrid" string PATH 'd:carrid/text()', "d:connid" string PATH 'd:connid/text()', "d:fldate" string PATH 'd:fldate/text()', "d:PRICE" string PATH 'd:PRICE/text()', "d:CURRENCY" string PATH 'd:CURRENCY/text()', "d:PLANETYPE" string PATH 'd:PLANETYPE/text()', "d:SEATSMAX" string PATH 'd:SEATSMAX/text()', "d:SEATSOCC" string PATH 'd:SEATSOCC/text()') AS A, CORRELATED_REFERENCES={f.result=f.result}})
============================================================================
EXECUTING PlaceAccess
AFTER:
Project(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView], props={PROJECT_COLS=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:countryFrom", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:cityFrom", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:airportFrom", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:countryTo", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:cityTo", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:airportTo", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:flightTime", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:departureTime", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:arrivalTime", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:distance", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:distanceUnit", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:flightType", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:period", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:carrid", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:connid", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:fldate", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:PRICE", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:CURRENCY", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:PLANETYPE", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:SEATSMAX", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:SEATSOCC"]})
Source(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView], props={NESTED_COMMAND=SELECT A."d:countryFrom" AS "d:countryFrom", A."d:cityFrom" AS "d:cityFrom", A."d:airportFrom" AS "d:airportFrom", A."d:countryTo" AS "d:countryTo", A."d:cityTo" AS "d:cityTo", A."d:airportTo" AS "d:airportTo", A."d:flightTime" AS "d:flightTime", A."d:departureTime" AS "d:departureTime", A."d:arrivalTime" AS "d:arrivalTime", A."d:distance" AS "d:distance", A."d:distanceUnit" AS "d:distanceUnit", A."d:flightType" AS "d:flightType", A."d:period" AS "d:period", A."d:carrid" AS "d:carrid", A."d:connid" AS "d:connid", A."d:fldate" AS "d:fldate", A."d:PRICE" AS "d:PRICE", A."d:CURRENCY" AS "d:CURRENCY", A."d:PLANETYPE" AS "d:PLANETYPE", A."d:SEATSMAX" AS "d:SEATSMAX", A."d:SEATSOCC" AS "d:SEATSOCC" FROM (EXEC sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp('GET', null, 'https://sapes1.sapdevcenter.com/sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection', TRUE)) AS f CROSS JOIN XMLTABLE(XMLNAMESPACES(DEFAULT 'http://www.w3.org/2005/Atom', 'http://schemas.microsoft.com/ado/2007/08/dataservices' AS d, 'http://schemas.microsoft.com/ado/2007/08/dataservices/metadata' AS m), '/feed/entry/content/m:properties' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS "d:countryFrom" string PATH 'd:flightDetails/d:countryFrom/text()', "d:cityFrom" string PATH 'd:flightDetails/d:cityFrom/text()', "d:airportFrom" string PATH 'd:flightDetails/d:airportFrom/text()', "d:countryTo" string PATH 'd:flightDetails/d:countryTo/text()', "d:cityTo" string PATH 'd:flightDetails/d:cityTo/text()', "d:airportTo" string PATH 'd:flightDetails/d:airportTo/text()', "d:flightTime" string PATH 'd:flightDetails/d:flightTime/text()', "d:departureTime" string PATH 'd:flightDetails/d:departureTime/text()', "d:arrivalTime" string PATH 'd:flightDetails/d:arrivalTime/text()', "d:distance" string PATH 'd:flightDetails/d:distance/text()', "d:distanceUnit" string PATH 'd:flightDetails/d:distanceUnit/text()', "d:flightType" string PATH 'd:flightDetails/d:flightType/text()', "d:period" string PATH 'd:flightDetails/d:period/text()', "d:carrid" string PATH 'd:carrid/text()', "d:connid" string PATH 'd:connid/text()', "d:fldate" string PATH 'd:fldate/text()', "d:PRICE" string PATH 'd:PRICE/text()', "d:CURRENCY" string PATH 'd:CURRENCY/text()', "d:PLANETYPE" string PATH 'd:PLANETYPE/text()', "d:SEATSMAX" string PATH 'd:SEATSMAX/text()', "d:SEATSOCC" string PATH 'd:SEATSOCC/text()') AS A, SYMBOL_MAP={sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:countryFrom"=A."d:countryFrom", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:cityFrom"=A."d:cityFrom", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:airportFrom"=A."d:airportFrom", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:countryTo"=A."d:countryTo", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:cityTo"=A."d:cityTo", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:airportTo"=A."d:airportTo", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:flightTime"=A."d:flightTime", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:departureTime"=A."d:departureTime", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:arrivalTime"=A."d:arrivalTime", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:distance"=A."d:distance", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:distanceUnit"=A."d:distanceUnit", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:flightType"=A."d:flightType", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:period"=A."d:period", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:carrid"=A."d:carrid", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:connid"=A."d:connid", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:fldate"=A."d:fldate", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:PRICE"=A."d:PRICE", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:CURRENCY"=A."d:CURRENCY", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:PLANETYPE"=A."d:PLANETYPE", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:SEATSMAX"=A."d:SEATSMAX", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:SEATSOCC"=A."d:SEATSOCC"}})
Project(groups=[A], props={PROJECT_COLS=[A."d:countryFrom" AS "d:countryFrom", A."d:cityFrom" AS "d:cityFrom", A."d:airportFrom" AS "d:airportFrom", A."d:countryTo" AS "d:countryTo", A."d:cityTo" AS "d:cityTo", A."d:airportTo" AS "d:airportTo", A."d:flightTime" AS "d:flightTime", A."d:departureTime" AS "d:departureTime", A."d:arrivalTime" AS "d:arrivalTime", A."d:distance" AS "d:distance", A."d:distanceUnit" AS "d:distanceUnit", A."d:flightType" AS "d:flightType", A."d:period" AS "d:period", A."d:carrid" AS "d:carrid", A."d:connid" AS "d:connid", A."d:fldate" AS "d:fldate", A."d:PRICE" AS "d:PRICE", A."d:CURRENCY" AS "d:CURRENCY", A."d:PLANETYPE" AS "d:PLANETYPE", A."d:SEATSMAX" AS "d:SEATSMAX", A."d:SEATSOCC" AS "d:SEATSOCC"]})
Join(groups=[f, A], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[]})
Source(groups=[f], props={NESTED_COMMAND=EXEC sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp('GET', null, 'https://sapes1.sapdevcenter.com/sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection', TRUE), SYMBOL_MAP={f.result=sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.result, f.contentType=sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.contentType}})
Project(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp], props={PROJECT_COLS=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.result, sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.contentType]})
Access(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp], props={MODEL_ID=Schema name=sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source, nameInSource=null, uuid=mmuuid:5cb75162-7a9d-4361-b35e-4463f5676a83})
Source(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp], props={VIRTUAL_COMMAND=EXEC sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp('GET', null, 'https://sapes1.sapdevcenter.com/sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection', TRUE)})
Source(groups=[A], props={TABLE_FUNCTION=XMLTABLE(XMLNAMESPACES(DEFAULT 'http://www.w3.org/2005/Atom', 'http://schemas.microsoft.com/ado/2007/08/dataservices' AS d, 'http://schemas.microsoft.com/ado/2007/08/dataservices/metadata' AS m), '/feed/entry/content/m:properties' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS "d:countryFrom" string PATH 'd:flightDetails/d:countryFrom/text()', "d:cityFrom" string PATH 'd:flightDetails/d:cityFrom/text()', "d:airportFrom" string PATH 'd:flightDetails/d:airportFrom/text()', "d:countryTo" string PATH 'd:flightDetails/d:countryTo/text()', "d:cityTo" string PATH 'd:flightDetails/d:cityTo/text()', "d:airportTo" string PATH 'd:flightDetails/d:airportTo/text()', "d:flightTime" string PATH 'd:flightDetails/d:flightTime/text()', "d:departureTime" string PATH 'd:flightDetails/d:departureTime/text()', "d:arrivalTime" string PATH 'd:flightDetails/d:arrivalTime/text()', "d:distance" string PATH 'd:flightDetails/d:distance/text()', "d:distanceUnit" string PATH 'd:flightDetails/d:distanceUnit/text()', "d:flightType" string PATH 'd:flightDetails/d:flightType/text()', "d:period" string PATH 'd:flightDetails/d:period/text()', "d:carrid" string PATH 'd:carrid/text()', "d:connid" string PATH 'd:connid/text()', "d:fldate" string PATH 'd:fldate/text()', "d:PRICE" string PATH 'd:PRICE/text()', "d:CURRENCY" string PATH 'd:CURRENCY/text()', "d:PLANETYPE" string PATH 'd:PLANETYPE/text()', "d:SEATSMAX" string PATH 'd:SEATSMAX/text()', "d:SEATSOCC" string PATH 'd:SEATSOCC/text()') AS A, CORRELATED_REFERENCES={f.result=f.result}})
============================================================================
EXECUTING AssignOutputElements
AFTER:
Project(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView], props={PROJECT_COLS=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:countryFrom", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:cityFrom", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:airportFrom", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:countryTo", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:cityTo", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:airportTo", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:flightTime", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:departureTime", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:arrivalTime", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:distance", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:distanceUnit", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:flightType", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:period", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:carrid", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:connid", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:fldate", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:PRICE", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:CURRENCY", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:PLANETYPE", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:SEATSMAX", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:SEATSOCC"], OUTPUT_COLS=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:countryFrom", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:cityFrom", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:airportFrom", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:countryTo", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:cityTo", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:airportTo", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:flightTime", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:departureTime", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:arrivalTime", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:distance", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:distanceUnit", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:flightType", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:period", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:carrid", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:connid", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:fldate", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:PRICE", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:CURRENCY", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:PLANETYPE", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:SEATSMAX", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:SEATSOCC"]})
Source(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView], props={NESTED_COMMAND=SELECT A."d:countryFrom" AS "d:countryFrom", A."d:cityFrom" AS "d:cityFrom", A."d:airportFrom" AS "d:airportFrom", A."d:countryTo" AS "d:countryTo", A."d:cityTo" AS "d:cityTo", A."d:airportTo" AS "d:airportTo", A."d:flightTime" AS "d:flightTime", A."d:departureTime" AS "d:departureTime", A."d:arrivalTime" AS "d:arrivalTime", A."d:distance" AS "d:distance", A."d:distanceUnit" AS "d:distanceUnit", A."d:flightType" AS "d:flightType", A."d:period" AS "d:period", A."d:carrid" AS "d:carrid", A."d:connid" AS "d:connid", A."d:fldate" AS "d:fldate", A."d:PRICE" AS "d:PRICE", A."d:CURRENCY" AS "d:CURRENCY", A."d:PLANETYPE" AS "d:PLANETYPE", A."d:SEATSMAX" AS "d:SEATSMAX", A."d:SEATSOCC" AS "d:SEATSOCC" FROM (EXEC sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp('GET', null, 'https://sapes1.sapdevcenter.com/sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection', TRUE)) AS f CROSS JOIN XMLTABLE(XMLNAMESPACES(DEFAULT 'http://www.w3.org/2005/Atom', 'http://schemas.microsoft.com/ado/2007/08/dataservices' AS d, 'http://schemas.microsoft.com/ado/2007/08/dataservices/metadata' AS m), '/feed/entry/content/m:properties' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS "d:countryFrom" string PATH 'd:flightDetails/d:countryFrom/text()', "d:cityFrom" string PATH 'd:flightDetails/d:cityFrom/text()', "d:airportFrom" string PATH 'd:flightDetails/d:airportFrom/text()', "d:countryTo" string PATH 'd:flightDetails/d:countryTo/text()', "d:cityTo" string PATH 'd:flightDetails/d:cityTo/text()', "d:airportTo" string PATH 'd:flightDetails/d:airportTo/text()', "d:flightTime" string PATH 'd:flightDetails/d:flightTime/text()', "d:departureTime" string PATH 'd:flightDetails/d:departureTime/text()', "d:arrivalTime" string PATH 'd:flightDetails/d:arrivalTime/text()', "d:distance" string PATH 'd:flightDetails/d:distance/text()', "d:distanceUnit" string PATH 'd:flightDetails/d:distanceUnit/text()', "d:flightType" string PATH 'd:flightDetails/d:flightType/text()', "d:period" string PATH 'd:flightDetails/d:period/text()', "d:carrid" string PATH 'd:carrid/text()', "d:connid" string PATH 'd:connid/text()', "d:fldate" string PATH 'd:fldate/text()', "d:PRICE" string PATH 'd:PRICE/text()', "d:CURRENCY" string PATH 'd:CURRENCY/text()', "d:PLANETYPE" string PATH 'd:PLANETYPE/text()', "d:SEATSMAX" string PATH 'd:SEATSMAX/text()', "d:SEATSOCC" string PATH 'd:SEATSOCC/text()') AS A, SYMBOL_MAP={sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:countryFrom"=A."d:countryFrom", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:cityFrom"=A."d:cityFrom", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:airportFrom"=A."d:airportFrom", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:countryTo"=A."d:countryTo", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:cityTo"=A."d:cityTo", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:airportTo"=A."d:airportTo", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:flightTime"=A."d:flightTime", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:departureTime"=A."d:departureTime", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:arrivalTime"=A."d:arrivalTime", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:distance"=A."d:distance", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:distanceUnit"=A."d:distanceUnit", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:flightType"=A."d:flightType", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:period"=A."d:period", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:carrid"=A."d:carrid", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:connid"=A."d:connid", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:fldate"=A."d:fldate", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:PRICE"=A."d:PRICE", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:CURRENCY"=A."d:CURRENCY", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:PLANETYPE"=A."d:PLANETYPE", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:SEATSMAX"=A."d:SEATSMAX", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:SEATSOCC"=A."d:SEATSOCC"}, OUTPUT_COLS=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:countryFrom", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:cityFrom", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:airportFrom", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:countryTo", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:cityTo", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:airportTo", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:flightTime", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:departureTime", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:arrivalTime", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:distance", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:distanceUnit", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:flightType", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:period", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:carrid", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:connid", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:fldate", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:PRICE", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:CURRENCY", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:PLANETYPE", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:SEATSMAX", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:SEATSOCC"]})
Project(groups=[A], props={PROJECT_COLS=[A."d:countryFrom" AS "d:countryFrom", A."d:cityFrom" AS "d:cityFrom", A."d:airportFrom" AS "d:airportFrom", A."d:countryTo" AS "d:countryTo", A."d:cityTo" AS "d:cityTo", A."d:airportTo" AS "d:airportTo", A."d:flightTime" AS "d:flightTime", A."d:departureTime" AS "d:departureTime", A."d:arrivalTime" AS "d:arrivalTime", A."d:distance" AS "d:distance", A."d:distanceUnit" AS "d:distanceUnit", A."d:flightType" AS "d:flightType", A."d:period" AS "d:period", A."d:carrid" AS "d:carrid", A."d:connid" AS "d:connid", A."d:fldate" AS "d:fldate", A."d:PRICE" AS "d:PRICE", A."d:CURRENCY" AS "d:CURRENCY", A."d:PLANETYPE" AS "d:PLANETYPE", A."d:SEATSMAX" AS "d:SEATSMAX", A."d:SEATSOCC" AS "d:SEATSOCC"], OUTPUT_COLS=[A."d:countryFrom" AS "d:countryFrom", A."d:cityFrom" AS "d:cityFrom", A."d:airportFrom" AS "d:airportFrom", A."d:countryTo" AS "d:countryTo", A."d:cityTo" AS "d:cityTo", A."d:airportTo" AS "d:airportTo", A."d:flightTime" AS "d:flightTime", A."d:departureTime" AS "d:departureTime", A."d:arrivalTime" AS "d:arrivalTime", A."d:distance" AS "d:distance", A."d:distanceUnit" AS "d:distanceUnit", A."d:flightType" AS "d:flightType", A."d:period" AS "d:period", A."d:carrid" AS "d:carrid", A."d:connid" AS "d:connid", A."d:fldate" AS "d:fldate", A."d:PRICE" AS "d:PRICE", A."d:CURRENCY" AS "d:CURRENCY", A."d:PLANETYPE" AS "d:PLANETYPE", A."d:SEATSMAX" AS "d:SEATSMAX", A."d:SEATSOCC" AS "d:SEATSOCC"]})
Join(groups=[f, A], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=[A."d:countryFrom", A."d:cityFrom", A."d:airportFrom", A."d:countryTo", A."d:cityTo", A."d:airportTo", A."d:flightTime", A."d:departureTime", A."d:arrivalTime", A."d:distance", A."d:distanceUnit", A."d:flightType", A."d:period", A."d:carrid", A."d:connid", A."d:fldate", A."d:PRICE", A."d:CURRENCY", A."d:PLANETYPE", A."d:SEATSMAX", A."d:SEATSOCC"]})
Source(groups=[f], props={NESTED_COMMAND=EXEC sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp('GET', null, 'https://sapes1.sapdevcenter.com/sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection', TRUE), SYMBOL_MAP={f.result=sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.result}, OUTPUT_COLS=[f.result]})
Project(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp], props={PROJECT_COLS=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.result], OUTPUT_COLS=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.result]})
Access(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp], props={MODEL_ID=Schema name=sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source, nameInSource=null, uuid=mmuuid:5cb75162-7a9d-4361-b35e-4463f5676a83, OUTPUT_COLS=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.result, sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.contentType]})
Source(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp], props={VIRTUAL_COMMAND=EXEC sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp('GET', null, 'https://sapes1.sapdevcenter.com/sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection', TRUE), OUTPUT_COLS=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.result]})
Source(groups=[A], props={TABLE_FUNCTION=XMLTABLE(XMLNAMESPACES(DEFAULT 'http://www.w3.org/2005/Atom', 'http://schemas.microsoft.com/ado/2007/08/dataservices' AS d, 'http://schemas.microsoft.com/ado/2007/08/dataservices/metadata' AS m), '/feed/entry/content/m:properties' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS "d:countryFrom" string PATH 'd:flightDetails/d:countryFrom/text()', "d:cityFrom" string PATH 'd:flightDetails/d:cityFrom/text()', "d:airportFrom" string PATH 'd:flightDetails/d:airportFrom/text()', "d:countryTo" string PATH 'd:flightDetails/d:countryTo/text()', "d:cityTo" string PATH 'd:flightDetails/d:cityTo/text()', "d:airportTo" string PATH 'd:flightDetails/d:airportTo/text()', "d:flightTime" string PATH 'd:flightDetails/d:flightTime/text()', "d:departureTime" string PATH 'd:flightDetails/d:departureTime/text()', "d:arrivalTime" string PATH 'd:flightDetails/d:arrivalTime/text()', "d:distance" string PATH 'd:flightDetails/d:distance/text()', "d:distanceUnit" string PATH 'd:flightDetails/d:distanceUnit/text()', "d:flightType" string PATH 'd:flightDetails/d:flightType/text()', "d:period" string PATH 'd:flightDetails/d:period/text()', "d:carrid" string PATH 'd:carrid/text()', "d:connid" string PATH 'd:connid/text()', "d:fldate" string PATH 'd:fldate/text()', "d:PRICE" string PATH 'd:PRICE/text()', "d:CURRENCY" string PATH 'd:CURRENCY/text()', "d:PLANETYPE" string PATH 'd:PLANETYPE/text()', "d:SEATSMAX" string PATH 'd:SEATSMAX/text()', "d:SEATSOCC" string PATH 'd:SEATSOCC/text()') AS A, CORRELATED_REFERENCES={f.result=f.result}, OUTPUT_COLS=[A."d:countryFrom", A."d:cityFrom", A."d:airportFrom", A."d:countryTo", A."d:cityTo", A."d:airportTo", A."d:flightTime", A."d:departureTime", A."d:arrivalTime", A."d:distance", A."d:distanceUnit", A."d:flightType", A."d:period", A."d:carrid", A."d:connid", A."d:fldate", A."d:PRICE", A."d:CURRENCY", A."d:PLANETYPE", A."d:SEATSMAX", A."d:SEATSOCC"]})
============================================================================
EXECUTING MergeVirtual
AFTER:
Project(groups=[A], props={PROJECT_COLS=[A."d:countryFrom", A."d:cityFrom", A."d:airportFrom", A."d:countryTo", A."d:cityTo", A."d:airportTo", A."d:flightTime", A."d:departureTime", A."d:arrivalTime", A."d:distance", A."d:distanceUnit", A."d:flightType", A."d:period", A."d:carrid", A."d:connid", A."d:fldate", A."d:PRICE", A."d:CURRENCY", A."d:PLANETYPE", A."d:SEATSMAX", A."d:SEATSOCC"], OUTPUT_COLS=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:countryFrom", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:cityFrom", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:airportFrom", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:countryTo", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:cityTo", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:airportTo", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:flightTime", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:departureTime", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:arrivalTime", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:distance", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:distanceUnit", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:flightType", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:period", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:carrid", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:connid", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:fldate", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:PRICE", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:CURRENCY", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:PLANETYPE", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:SEATSMAX", sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_View.sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollectionView."d:SEATSOCC"]})
Join(groups=[f, A], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=[A."d:countryFrom", A."d:cityFrom", A."d:airportFrom", A."d:countryTo", A."d:cityTo", A."d:airportTo", A."d:flightTime", A."d:departureTime", A."d:arrivalTime", A."d:distance", A."d:distanceUnit", A."d:flightType", A."d:period", A."d:carrid", A."d:connid", A."d:fldate", A."d:PRICE", A."d:CURRENCY", A."d:PLANETYPE", A."d:SEATSMAX", A."d:SEATSOCC"]})
Source(groups=[f])
Project(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp])
Access(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp])
Source(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp], props={VIRTUAL_COMMAND=EXEC sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp('GET', null, 'https://sapes1.sapdevcenter.com/sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection', TRUE), OUTPUT_COLS=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.result]})
Source(groups=[A])
============================================================================
EXECUTING PushNonJoinCriteria
AFTER:
Project(groups=[A])
Join(groups=[f, A], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=[A."d:countryFrom", A."d:cityFrom", A."d:airportFrom", A."d:countryTo", A."d:cityTo", A."d:airportTo", A."d:flightTime", A."d:departureTime", A."d:arrivalTime", A."d:distance", A."d:distanceUnit", A."d:flightType", A."d:period", A."d:carrid", A."d:connid", A."d:fldate", A."d:PRICE", A."d:CURRENCY", A."d:PLANETYPE", A."d:SEATSMAX", A."d:SEATSOCC"]})
Source(groups=[f])
Project(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp])
Access(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp])
Source(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp])
Source(groups=[A])
============================================================================
EXECUTING CopyCriteria
AFTER:
Project(groups=[A])
Join(groups=[f, A], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=[A."d:countryFrom", A."d:cityFrom", A."d:airportFrom", A."d:countryTo", A."d:cityTo", A."d:airportTo", A."d:flightTime", A."d:departureTime", A."d:arrivalTime", A."d:distance", A."d:distanceUnit", A."d:flightType", A."d:period", A."d:carrid", A."d:connid", A."d:fldate", A."d:PRICE", A."d:CURRENCY", A."d:PLANETYPE", A."d:SEATSMAX", A."d:SEATSOCC"], IS_COPIED=true})
Source(groups=[f])
Project(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp])
Access(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp])
Source(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp])
Source(groups=[A])
============================================================================
EXECUTING CleanCriteria
AFTER:
Project(groups=[A], props={PROJECT_COLS=[A."d:countryFrom", A."d:cityFrom", A."d:airportFrom", A."d:countryTo", A."d:cityTo", A."d:airportTo", A."d:flightTime", A."d:departureTime", A."d:arrivalTime", A."d:distance", A."d:distanceUnit", A."d:flightType", A."d:period", A."d:carrid", A."d:connid", A."d:fldate", A."d:PRICE", A."d:CURRENCY", A."d:PLANETYPE", A."d:SEATSMAX", A."d:SEATSOCC"], OUTPUT_COLS=null})
Join(groups=[f, A], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=null, IS_COPIED=true})
Source(groups=[f], props={NESTED_COMMAND=EXEC sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp('GET', null, 'https://sapes1.sapdevcenter.com/sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection', TRUE), SYMBOL_MAP={f.result=sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.result}, OUTPUT_COLS=null})
Project(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp], props={PROJECT_COLS=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.result], OUTPUT_COLS=null})
Access(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp], props={MODEL_ID=Schema name=sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source, nameInSource=null, uuid=mmuuid:5cb75162-7a9d-4361-b35e-4463f5676a83, OUTPUT_COLS=null})
Source(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp], props={VIRTUAL_COMMAND=EXEC sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp('GET', null, 'https://sapes1.sapdevcenter.com/sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection', TRUE), OUTPUT_COLS=null})
Source(groups=[A], props={TABLE_FUNCTION=XMLTABLE(XMLNAMESPACES(DEFAULT 'http://www.w3.org/2005/Atom', 'http://schemas.microsoft.com/ado/2007/08/dataservices' AS d, 'http://schemas.microsoft.com/ado/2007/08/dataservices/metadata' AS m), '/feed/entry/content/m:properties' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS "d:countryFrom" string PATH 'd:flightDetails/d:countryFrom/text()', "d:cityFrom" string PATH 'd:flightDetails/d:cityFrom/text()', "d:airportFrom" string PATH 'd:flightDetails/d:airportFrom/text()', "d:countryTo" string PATH 'd:flightDetails/d:countryTo/text()', "d:cityTo" string PATH 'd:flightDetails/d:cityTo/text()', "d:airportTo" string PATH 'd:flightDetails/d:airportTo/text()', "d:flightTime" string PATH 'd:flightDetails/d:flightTime/text()', "d:departureTime" string PATH 'd:flightDetails/d:departureTime/text()', "d:arrivalTime" string PATH 'd:flightDetails/d:arrivalTime/text()', "d:distance" string PATH 'd:flightDetails/d:distance/text()', "d:distanceUnit" string PATH 'd:flightDetails/d:distanceUnit/text()', "d:flightType" string PATH 'd:flightDetails/d:flightType/text()', "d:period" string PATH 'd:flightDetails/d:period/text()', "d:carrid" string PATH 'd:carrid/text()', "d:connid" string PATH 'd:connid/text()', "d:fldate" string PATH 'd:fldate/text()', "d:PRICE" string PATH 'd:PRICE/text()', "d:CURRENCY" string PATH 'd:CURRENCY/text()', "d:PLANETYPE" string PATH 'd:PLANETYPE/text()', "d:SEATSMAX" string PATH 'd:SEATSMAX/text()', "d:SEATSOCC" string PATH 'd:SEATSOCC/text()') AS A, CORRELATED_REFERENCES={f.result=f.result}, OUTPUT_COLS=null})
============================================================================
EXECUTING RaiseAccess
AFTER:
Project(groups=[A])
Join(groups=[f, A])
Source(groups=[f])
Project(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp], props={PROJECT_COLS=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.result], OUTPUT_COLS=null})
Access(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp], props={MODEL_ID=Schema name=sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source, nameInSource=null, uuid=mmuuid:5cb75162-7a9d-4361-b35e-4463f5676a83, OUTPUT_COLS=null})
Source(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp], props={VIRTUAL_COMMAND=EXEC sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp('GET', null, 'https://sapes1.sapdevcenter.com/sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection', TRUE), OUTPUT_COLS=null})
Source(groups=[A])
============================================================================
EXECUTING PlanJoins
AFTER:
Project(groups=[A])
Join(groups=[f, A], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=null, IS_COPIED=true})
Source(groups=[f])
Project(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp])
Access(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp])
Source(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp])
Source(groups=[A], props={TABLE_FUNCTION=XMLTABLE(XMLNAMESPACES(DEFAULT 'http://www.w3.org/2005/Atom', 'http://schemas.microsoft.com/ado/2007/08/dataservices' AS d, 'http://schemas.microsoft.com/ado/2007/08/dataservices/metadata' AS m), '/feed/entry/content/m:properties' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS "d:countryFrom" string PATH 'd:flightDetails/d:countryFrom/text()', "d:cityFrom" string PATH 'd:flightDetails/d:cityFrom/text()', "d:airportFrom" string PATH 'd:flightDetails/d:airportFrom/text()', "d:countryTo" string PATH 'd:flightDetails/d:countryTo/text()', "d:cityTo" string PATH 'd:flightDetails/d:cityTo/text()', "d:airportTo" string PATH 'd:flightDetails/d:airportTo/text()', "d:flightTime" string PATH 'd:flightDetails/d:flightTime/text()', "d:departureTime" string PATH 'd:flightDetails/d:departureTime/text()', "d:arrivalTime" string PATH 'd:flightDetails/d:arrivalTime/text()', "d:distance" string PATH 'd:flightDetails/d:distance/text()', "d:distanceUnit" string PATH 'd:flightDetails/d:distanceUnit/text()', "d:flightType" string PATH 'd:flightDetails/d:flightType/text()', "d:period" string PATH 'd:flightDetails/d:period/text()', "d:carrid" string PATH 'd:carrid/text()', "d:connid" string PATH 'd:connid/text()', "d:fldate" string PATH 'd:fldate/text()', "d:PRICE" string PATH 'd:PRICE/text()', "d:CURRENCY" string PATH 'd:CURRENCY/text()', "d:PLANETYPE" string PATH 'd:PLANETYPE/text()', "d:SEATSMAX" string PATH 'd:SEATSMAX/text()', "d:SEATSOCC" string PATH 'd:SEATSOCC/text()') AS A, CORRELATED_REFERENCES={f.result=f.result}, OUTPUT_COLS=null})
============================================================================
EXECUTING PushSelectCriteria
AFTER:
Project(groups=[A])
Join(groups=[f, A])
Source(groups=[f])
Project(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp])
Access(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp])
Source(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp])
Source(groups=[A])
============================================================================
EXECUTING RaiseAccess
AFTER:
Project(groups=[A])
Join(groups=[f, A])
Source(groups=[f])
Project(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp], props={PROJECT_COLS=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.result], OUTPUT_COLS=null})
Access(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp], props={MODEL_ID=Schema name=sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source, nameInSource=null, uuid=mmuuid:5cb75162-7a9d-4361-b35e-4463f5676a83, OUTPUT_COLS=null})
Source(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp], props={VIRTUAL_COMMAND=EXEC sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp('GET', null, 'https://sapes1.sapdevcenter.com/sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection', TRUE), OUTPUT_COLS=null})
Source(groups=[A])
============================================================================
EXECUTING ChooseJoinStrategy
AFTER:
Project(groups=[A])
Join(groups=[f, A], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=null, IS_COPIED=true})
Source(groups=[f])
Project(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp])
Access(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp])
Source(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp])
Source(groups=[A])
============================================================================
EXECUTING ChooseDependent
LOW Relational Planner parent join is CROSS or FULL OUTER - Rejecting dependent join Source(groups=[f], props={NESTED_COMMAND=EXEC sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp('GET', null, 'https://sapes1.sapdevcenter.com/sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection', TRUE), SYMBOL_MAP={f.result=sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.result}, OUTPUT_COLS=null}
LOW Relational Planner parent join is CROSS or FULL OUTER - Rejecting dependent join Source(groups=[A], props={TABLE_FUNCTION=XMLTABLE(XMLNAMESPACES(DEFAULT 'http://www.w3.org/2005/Atom', 'http://schemas.microsoft.com/ado/2007/08/dataservices' AS d, 'http://schemas.microsoft.com/ado/2007/08/dataservices/metadata' AS m), '/feed/entry/content/m:properties' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS "d:countryFrom" string PATH 'd:flightDetails/d:countryFrom/text()', "d:cityFrom" string PATH 'd:flightDetails/d:cityFrom/text()', "d:airportFrom" string PATH 'd:flightDetails/d:airportFrom/text()', "d:countryTo" string PATH 'd:flightDetails/d:countryTo/text()', "d:cityTo" string PATH 'd:flightDetails/d:cityTo/text()', "d:airportTo" string PATH 'd:flightDetails/d:airportTo/text()', "d:flightTime" string PATH 'd:flightDetails/d:flightTime/text()', "d:departureTime" string PATH 'd:flightDetails/d:departureTime/text()', "d:arrivalTime" string PATH 'd:flightDetails/d:arrivalTime/text()', "d:distance" string PATH 'd:flightDetails/d:distance/text()', "d:distanceUnit" string PATH 'd:flightDetails/d:distanceUnit/text()', "d:flightType" string PATH 'd:flightDetails/d:flightType/text()', "d:period" string PATH 'd:flightDetails/d:period/text()', "d:carrid" string PATH 'd:carrid/text()', "d:connid" string PATH 'd:connid/text()', "d:fldate" string PATH 'd:fldate/text()', "d:PRICE" string PATH 'd:PRICE/text()', "d:CURRENCY" string PATH 'd:CURRENCY/text()', "d:PLANETYPE" string PATH 'd:PLANETYPE/text()', "d:SEATSMAX" string PATH 'd:SEATSMAX/text()', "d:SEATSOCC" string PATH 'd:SEATSOCC/text()') AS A, CORRELATED_REFERENCES={f.result=f.result}, OUTPUT_COLS=null}
AFTER:
Project(groups=[A])
Join(groups=[f, A], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=null, IS_COPIED=true})
Source(groups=[f])
Project(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp])
Access(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp])
Source(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp])
Source(groups=[A])
============================================================================
EXECUTING AssignOutputElements
AFTER:
Project(groups=[A], props={PROJECT_COLS=[A."d:countryFrom", A."d:cityFrom", A."d:airportFrom", A."d:countryTo", A."d:cityTo", A."d:airportTo", A."d:flightTime", A."d:departureTime", A."d:arrivalTime", A."d:distance", A."d:distanceUnit", A."d:flightType", A."d:period", A."d:carrid", A."d:connid", A."d:fldate", A."d:PRICE", A."d:CURRENCY", A."d:PLANETYPE", A."d:SEATSMAX", A."d:SEATSOCC"], OUTPUT_COLS=[A."d:countryFrom", A."d:cityFrom", A."d:airportFrom", A."d:countryTo", A."d:cityTo", A."d:airportTo", A."d:flightTime", A."d:departureTime", A."d:arrivalTime", A."d:distance", A."d:distanceUnit", A."d:flightType", A."d:period", A."d:carrid", A."d:connid", A."d:fldate", A."d:PRICE", A."d:CURRENCY", A."d:PLANETYPE", A."d:SEATSMAX", A."d:SEATSOCC"]})
Join(groups=[f, A], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=[A."d:countryFrom", A."d:cityFrom", A."d:airportFrom", A."d:countryTo", A."d:cityTo", A."d:airportTo", A."d:flightTime", A."d:departureTime", A."d:arrivalTime", A."d:distance", A."d:distanceUnit", A."d:flightType", A."d:period", A."d:carrid", A."d:connid", A."d:fldate", A."d:PRICE", A."d:CURRENCY", A."d:PLANETYPE", A."d:SEATSMAX", A."d:SEATSOCC"], IS_COPIED=true})
Source(groups=[f], props={NESTED_COMMAND=EXEC sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp('GET', null, 'https://sapes1.sapdevcenter.com/sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection', TRUE), SYMBOL_MAP={f.result=sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.result}, OUTPUT_COLS=[f.result]})
Project(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp], props={PROJECT_COLS=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.result], OUTPUT_COLS=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.result]})
Access(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp], props={MODEL_ID=Schema name=sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source, nameInSource=null, uuid=mmuuid:5cb75162-7a9d-4361-b35e-4463f5676a83, OUTPUT_COLS=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.result, sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.contentType]})
Source(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp], props={VIRTUAL_COMMAND=EXEC sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp('GET', null, 'https://sapes1.sapdevcenter.com/sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection', TRUE), OUTPUT_COLS=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.result]})
Source(groups=[A], props={TABLE_FUNCTION=XMLTABLE(XMLNAMESPACES(DEFAULT 'http://www.w3.org/2005/Atom', 'http://schemas.microsoft.com/ado/2007/08/dataservices' AS d, 'http://schemas.microsoft.com/ado/2007/08/dataservices/metadata' AS m), '/feed/entry/content/m:properties' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS "d:countryFrom" string PATH 'd:flightDetails/d:countryFrom/text()', "d:cityFrom" string PATH 'd:flightDetails/d:cityFrom/text()', "d:airportFrom" string PATH 'd:flightDetails/d:airportFrom/text()', "d:countryTo" string PATH 'd:flightDetails/d:countryTo/text()', "d:cityTo" string PATH 'd:flightDetails/d:cityTo/text()', "d:airportTo" string PATH 'd:flightDetails/d:airportTo/text()', "d:flightTime" string PATH 'd:flightDetails/d:flightTime/text()', "d:departureTime" string PATH 'd:flightDetails/d:departureTime/text()', "d:arrivalTime" string PATH 'd:flightDetails/d:arrivalTime/text()', "d:distance" string PATH 'd:flightDetails/d:distance/text()', "d:distanceUnit" string PATH 'd:flightDetails/d:distanceUnit/text()', "d:flightType" string PATH 'd:flightDetails/d:flightType/text()', "d:period" string PATH 'd:flightDetails/d:period/text()', "d:carrid" string PATH 'd:carrid/text()', "d:connid" string PATH 'd:connid/text()', "d:fldate" string PATH 'd:fldate/text()', "d:PRICE" string PATH 'd:PRICE/text()', "d:CURRENCY" string PATH 'd:CURRENCY/text()', "d:PLANETYPE" string PATH 'd:PLANETYPE/text()', "d:SEATSMAX" string PATH 'd:SEATSMAX/text()', "d:SEATSOCC" string PATH 'd:SEATSOCC/text()') AS A, CORRELATED_REFERENCES={f.result=f.result}, OUTPUT_COLS=[A."d:countryFrom", A."d:cityFrom", A."d:airportFrom", A."d:countryTo", A."d:cityTo", A."d:airportTo", A."d:flightTime", A."d:departureTime", A."d:arrivalTime", A."d:distance", A."d:distanceUnit", A."d:flightType", A."d:period", A."d:carrid", A."d:connid", A."d:fldate", A."d:PRICE", A."d:CURRENCY", A."d:PLANETYPE", A."d:SEATSMAX", A."d:SEATSOCC"]})
============================================================================
EXECUTING CalculateCost
AFTER:
Project(groups=[A], props={PROJECT_COLS=[A."d:countryFrom", A."d:cityFrom", A."d:airportFrom", A."d:countryTo", A."d:cityTo", A."d:airportTo", A."d:flightTime", A."d:departureTime", A."d:arrivalTime", A."d:distance", A."d:distanceUnit", A."d:flightType", A."d:period", A."d:carrid", A."d:connid", A."d:fldate", A."d:PRICE", A."d:CURRENCY", A."d:PLANETYPE", A."d:SEATSMAX", A."d:SEATSOCC"], OUTPUT_COLS=[A."d:countryFrom", A."d:cityFrom", A."d:airportFrom", A."d:countryTo", A."d:cityTo", A."d:airportTo", A."d:flightTime", A."d:departureTime", A."d:arrivalTime", A."d:distance", A."d:distanceUnit", A."d:flightType", A."d:period", A."d:carrid", A."d:connid", A."d:fldate", A."d:PRICE", A."d:CURRENCY", A."d:PLANETYPE", A."d:SEATSMAX", A."d:SEATSOCC"], EST_CARDINALITY=-1.0})
Join(groups=[f, A], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[], OUTPUT_COLS=[A."d:countryFrom", A."d:cityFrom", A."d:airportFrom", A."d:countryTo", A."d:cityTo", A."d:airportTo", A."d:flightTime", A."d:departureTime", A."d:arrivalTime", A."d:distance", A."d:distanceUnit", A."d:flightType", A."d:period", A."d:carrid", A."d:connid", A."d:fldate", A."d:PRICE", A."d:CURRENCY", A."d:PLANETYPE", A."d:SEATSMAX", A."d:SEATSOCC"], IS_COPIED=true, EST_CARDINALITY=-1.0})
Source(groups=[f], props={NESTED_COMMAND=EXEC sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp('GET', null, 'https://sapes1.sapdevcenter.com/sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection', TRUE), SYMBOL_MAP={f.result=sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.result}, OUTPUT_COLS=[f.result], EST_CARDINALITY=-1.0, EST_COL_STATS={f.result=[-1.0, -1.0]}})
Project(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp], props={PROJECT_COLS=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.result], OUTPUT_COLS=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.result], EST_CARDINALITY=-1.0})
Access(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp], props={MODEL_ID=Schema name=sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source, nameInSource=null, uuid=mmuuid:5cb75162-7a9d-4361-b35e-4463f5676a83, OUTPUT_COLS=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.result, sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.contentType], EST_CARDINALITY=-1.0})
Source(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp], props={VIRTUAL_COMMAND=EXEC sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp('GET', null, 'https://sapes1.sapdevcenter.com/sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection', TRUE), OUTPUT_COLS=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.result], EST_COL_STATS={sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.result=[-1.0, -1.0]}, EST_CARDINALITY=-1.0})
Source(groups=[A], props={TABLE_FUNCTION=XMLTABLE(XMLNAMESPACES(DEFAULT 'http://www.w3.org/2005/Atom', 'http://schemas.microsoft.com/ado/2007/08/dataservices' AS d, 'http://schemas.microsoft.com/ado/2007/08/dataservices/metadata' AS m), '/feed/entry/content/m:properties' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS "d:countryFrom" string PATH 'd:flightDetails/d:countryFrom/text()', "d:cityFrom" string PATH 'd:flightDetails/d:cityFrom/text()', "d:airportFrom" string PATH 'd:flightDetails/d:airportFrom/text()', "d:countryTo" string PATH 'd:flightDetails/d:countryTo/text()', "d:cityTo" string PATH 'd:flightDetails/d:cityTo/text()', "d:airportTo" string PATH 'd:flightDetails/d:airportTo/text()', "d:flightTime" string PATH 'd:flightDetails/d:flightTime/text()', "d:departureTime" string PATH 'd:flightDetails/d:departureTime/text()', "d:arrivalTime" string PATH 'd:flightDetails/d:arrivalTime/text()', "d:distance" string PATH 'd:flightDetails/d:distance/text()', "d:distanceUnit" string PATH 'd:flightDetails/d:distanceUnit/text()', "d:flightType" string PATH 'd:flightDetails/d:flightType/text()', "d:period" string PATH 'd:flightDetails/d:period/text()', "d:carrid" string PATH 'd:carrid/text()', "d:connid" string PATH 'd:connid/text()', "d:fldate" string PATH 'd:fldate/text()', "d:PRICE" string PATH 'd:PRICE/text()', "d:CURRENCY" string PATH 'd:CURRENCY/text()', "d:PLANETYPE" string PATH 'd:PLANETYPE/text()', "d:SEATSMAX" string PATH 'd:SEATSMAX/text()', "d:SEATSOCC" string PATH 'd:SEATSOCC/text()') AS A, CORRELATED_REFERENCES={f.result=f.result}, OUTPUT_COLS=[A."d:countryFrom", A."d:cityFrom", A."d:airportFrom", A."d:countryTo", A."d:cityTo", A."d:airportTo", A."d:flightTime", A."d:departureTime", A."d:arrivalTime", A."d:distance", A."d:distanceUnit", A."d:flightType", A."d:period", A."d:carrid", A."d:connid", A."d:fldate", A."d:PRICE", A."d:CURRENCY", A."d:PLANETYPE", A."d:SEATSMAX", A."d:SEATSOCC"], EST_COL_STATS={A."d:countryFrom"=[-1.0, -1.0], A."d:cityFrom"=[-1.0, -1.0], A."d:airportFrom"=[-1.0, -1.0], A."d:countryTo"=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0})
============================================================================
EXECUTING ImplementJoinStrategy
AFTER:
Project(groups=[A])
Join(groups=[f, A], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_TABLE, JOIN_CRITERIA=[], OUTPUT_COLS=[A."d:countryFrom", A."d:cityFrom", A."d:airportFrom", A."d:countryTo", A."d:cityTo", A."d:airportTo", A."d:flightTime", A."d:departureTime", A."d:arrivalTime", A."d:distance", A."d:distanceUnit", A."d:flightType", A."d:period", A."d:carrid", A."d:connid", A."d:fldate", A."d:PRICE", A."d:CURRENCY", A."d:PLANETYPE", A."d:SEATSMAX", A."d:SEATSOCC"], IS_COPIED=true, EST_CARDINALITY=-1.0})
Source(groups=[f])
Project(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp])
Access(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp])
Source(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp])
Source(groups=[A], props={TABLE_FUNCTION=XMLTABLE(XMLNAMESPACES(DEFAULT 'http://www.w3.org/2005/Atom', 'http://schemas.microsoft.com/ado/2007/08/dataservices' AS d, 'http://schemas.microsoft.com/ado/2007/08/dataservices/metadata' AS m), '/feed/entry/content/m:properties' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS "d:countryFrom" string PATH 'd:flightDetails/d:countryFrom/text()', "d:cityFrom" string PATH 'd:flightDetails/d:cityFrom/text()', "d:airportFrom" string PATH 'd:flightDetails/d:airportFrom/text()', "d:countryTo" string PATH 'd:flightDetails/d:countryTo/text()', "d:cityTo" string PATH 'd:flightDetails/d:cityTo/text()', "d:airportTo" string PATH 'd:flightDetails/d:airportTo/text()', "d:flightTime" string PATH 'd:flightDetails/d:flightTime/text()', "d:departureTime" string PATH 'd:flightDetails/d:departureTime/text()', "d:arrivalTime" string PATH 'd:flightDetails/d:arrivalTime/text()', "d:distance" string PATH 'd:flightDetails/d:distance/text()', "d:distanceUnit" string PATH 'd:flightDetails/d:distanceUnit/text()', "d:flightType" string PATH 'd:flightDetails/d:flightType/text()', "d:period" string PATH 'd:flightDetails/d:period/text()', "d:carrid" string PATH 'd:carrid/text()', "d:connid" string PATH 'd:connid/text()', "d:fldate" string PATH 'd:fldate/text()', "d:PRICE" string PATH 'd:PRICE/text()', "d:CURRENCY" string PATH 'd:CURRENCY/text()', "d:PLANETYPE" string PATH 'd:PLANETYPE/text()', "d:SEATSMAX" string PATH 'd:SEATSMAX/text()', "d:SEATSOCC" string PATH 'd:SEATSOCC/text()') AS A, CORRELATED_REFERENCES={f.result=f.result}, OUTPUT_COLS=[A."d:countryFrom", A."d:cityFrom", A."d:airportFrom", A."d:countryTo", A."d:cityTo", A."d:airportTo", A."d:flightTime", A."d:departureTime", A."d:arrivalTime", A."d:distance", A."d:distanceUnit", A."d:flightType", A."d:period", A."d:carrid", A."d:connid", A."d:fldate", A."d:PRICE", A."d:CURRENCY", A."d:PLANETYPE", A."d:SEATSMAX", A."d:SEATSOCC"], EST_COL_STATS={A."d:countryFrom"=[-1.0, -1.0], A."d:cityFrom"=[-1.0, -1.0], A."d:airportFrom"=[-1.0, -1.0], A."d:countryTo"=[-1.0, -1.0], ...}, EST_CARDINALITY=-1.0})
============================================================================
EXECUTING MergeCriteria
AFTER:
Project(groups=[A])
Join(groups=[f, A])
Source(groups=[f])
Project(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp])
Access(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp])
Source(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp])
Source(groups=[A])
============================================================================
EXECUTING PlanSorts
AFTER:
Project(groups=[A])
Join(groups=[f, A], props={JOIN_TYPE=CROSS JOIN, JOIN_STRATEGY=NESTED_TABLE, JOIN_CRITERIA=[], OUTPUT_COLS=[A."d:countryFrom", A."d:cityFrom", A."d:airportFrom", A."d:countryTo", A."d:cityTo", A."d:airportTo", A."d:flightTime", A."d:departureTime", A."d:arrivalTime", A."d:distance", A."d:distanceUnit", A."d:flightType", A."d:period", A."d:carrid", A."d:connid", A."d:fldate", A."d:PRICE", A."d:CURRENCY", A."d:PLANETYPE", A."d:SEATSMAX", A."d:SEATSOCC"], IS_COPIED=true, EST_CARDINALITY=-1.0})
Source(groups=[f])
Project(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp])
Access(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp])
Source(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp])
Source(groups=[A])
============================================================================
EXECUTING CollapseSource
AFTER:
Project(groups=[A])
Join(groups=[f, A])
Source(groups=[f])
Project(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp])
Access(groups=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp], props={MODEL_ID=Schema name=sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source, nameInSource=null, uuid=mmuuid:5cb75162-7a9d-4361-b35e-4463f5676a83, OUTPUT_COLS=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.result, sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.contentType], EST_CARDINALITY=-1.0, ATOMIC_REQUEST=EXEC sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp('GET', null, 'https://sapes1.sapdevcenter.com/sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection', TRUE)})
Source(groups=[A])
============================================================================
CONVERTING PLAN TREE TO PROCESS TREE
MEDIUM XQuery Planning Projection conditions met for /feed/entry/content/m:properties - Document projection will be used
child::element({http://www.w3.org/2005/Atom}feed, xs:anyType)
child::element({http://www.w3.org/2005/Atom}entry, xs:anyType)
child::element({http://www.w3.org/2005/Atom}content, xs:anyType)
child::element({http://schemas.microsoft.com/ado/2007/08/dataservices/metadata}properties, xs:anyType)
child::element({http://schemas.microsoft.com/ado/2007/08/dataservices}flightDetails, xs:anyType)
child::element({http://schemas.microsoft.com/ado/2007/08/dataservices}countryFrom, xs:anyType)
child::text()
child::text()
child::element({http://schemas.microsoft.com/ado/2007/08/dataservices}flightDetails, xs:anyType)
child::element({http://schemas.microsoft.com/ado/2007/08/dataservices}cityFrom, xs:anyType)
child::text()
child::text()
child::element({http://schemas.microsoft.com/ado/2007/08/dataservices}flightDetails, xs:anyType)
child::element({http://schemas.microsoft.com/ado/2007/08/dataservices}airportFrom, xs:anyType)
child::text()
child::text()
child::element({http://schemas.microsoft.com/ado/2007/08/dataservices}flightDetails, xs:anyType)
child::element({http://schemas.microsoft.com/ado/2007/08/dataservices}countryTo, xs:anyType)
child::text()
child::text()
child::element({http://schemas.microsoft.com/ado/2007/08/dataservices}flightDetails, xs:anyType)
child::element({http://schemas.microsoft.com/ado/2007/08/dataservices}cityTo, xs:anyType)
child::text()
child::text()
child::element({http://schemas.microsoft.com/ado/2007/08/dataservices}flightDetails, xs:anyType)
child::element({http://schemas.microsoft.com/ado/2007/08/dataservices}airportTo, xs:anyType)
child::text()
child::text()
child::element({http://schemas.microsoft.com/ado/2007/08/dataservices}flightDetails, xs:anyType)
child::element({http://schemas.microsoft.com/ado/2007/08/dataservices}flightTime, xs:anyType)
child::text()
child::text()
child::element({http://schemas.microsoft.com/ado/2007/08/dataservices}flightDetails, xs:anyType)
child::element({http://schemas.microsoft.com/ado/2007/08/dataservices}departureTime, xs:anyType)
child::text()
child::text()
child::element({http://schemas.microsoft.com/ado/2007/08/dataservices}flightDetails, xs:anyType)
child::element({http://schemas.microsoft.com/ado/2007/08/dataservices}arrivalTime, xs:anyType)
child::text()
child::text()
child::element({http://schemas.microsoft.com/ado/2007/08/dataservices}flightDetails, xs:anyType)
child::element({http://schemas.microsoft.com/ado/2007/08/dataservices}distance, xs:anyType)
child::text()
child::text()
child::element({http://schemas.microsoft.com/ado/2007/08/dataservices}flightDetails, xs:anyType)
child::element({http://schemas.microsoft.com/ado/2007/08/dataservices}distanceUnit, xs:anyType)
child::text()
child::text()
child::element({http://schemas.microsoft.com/ado/2007/08/dataservices}flightDetails, xs:anyType)
child::element({http://schemas.microsoft.com/ado/2007/08/dataservices}flightType, xs:anyType)
child::text()
child::text()
child::element({http://schemas.microsoft.com/ado/2007/08/dataservices}flightDetails, xs:anyType)
child::element({http://schemas.microsoft.com/ado/2007/08/dataservices}period, xs:anyType)
child::text()
child::text()
child::element({http://schemas.microsoft.com/ado/2007/08/dataservices}carrid, xs:anyType)
child::text()
child::text()
child::element({http://schemas.microsoft.com/ado/2007/08/dataservices}connid, xs:anyType)
child::text()
child::text()
child::element({http://schemas.microsoft.com/ado/2007/08/dataservices}fldate, xs:anyType)
child::text()
child::text()
child::element({http://schemas.microsoft.com/ado/2007/08/dataservices}PRICE, xs:anyType)
child::text()
child::text()
child::element({http://schemas.microsoft.com/ado/2007/08/dataservices}CURRENCY, xs:anyType)
child::text()
child::text()
child::element({http://schemas.microsoft.com/ado/2007/08/dataservices}PLANETYPE, xs:anyType)
child::text()
child::text()
child::element({http://schemas.microsoft.com/ado/2007/08/dataservices}SEATSMAX, xs:anyType)
child::text()
child::text()
child::element({http://schemas.microsoft.com/ado/2007/08/dataservices}SEATSOCC, xs:anyType)
child::text()
child::text()
PROCESS PLAN =
ProjectNode(0) output=[A."d:countryFrom", A."d:cityFrom", A."d:airportFrom", A."d:countryTo", A."d:cityTo", A."d:airportTo", A."d:flightTime", A."d:departureTime", A."d:arrivalTime", A."d:distance", A."d:distanceUnit", A."d:flightType", A."d:period", A."d:carrid", A."d:connid", A."d:fldate", A."d:PRICE", A."d:CURRENCY", A."d:PLANETYPE", A."d:SEATSMAX", A."d:SEATSOCC"] [A."d:countryFrom", A."d:cityFrom", A."d:airportFrom", A."d:countryTo", A."d:cityTo", A."d:airportTo", A."d:flightTime", A."d:departureTime", A."d:arrivalTime", A."d:distance", A."d:distanceUnit", A."d:flightType", A."d:period", A."d:carrid", A."d:connid", A."d:fldate", A."d:PRICE", A."d:CURRENCY", A."d:PLANETYPE", A."d:SEATSMAX", A."d:SEATSOCC"]
JoinNode(1) [NESTED TABLE JOIN] [CROSS JOIN] output=[A."d:countryFrom", A."d:cityFrom", A."d:airportFrom", A."d:countryTo", A."d:cityTo", A."d:airportTo", A."d:flightTime", A."d:departureTime", A."d:arrivalTime", A."d:distance", A."d:distanceUnit", A."d:flightType", A."d:period", A."d:carrid", A."d:connid", A."d:fldate", A."d:PRICE", A."d:CURRENCY", A."d:PLANETYPE", A."d:SEATSMAX", A."d:SEATSOCC"]
ProjectNode(2) output=[f.result] [sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.result]
AccessNode(3) output=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.result, sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.contentType] EXEC sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp('GET', null, 'https://sapes1.sapdevcenter.com/sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection', TRUE)
XMLTableNode(4) output=[A."d:countryFrom", A."d:cityFrom", A."d:airportFrom", A."d:countryTo", A."d:cityTo", A."d:airportTo", A."d:flightTime", A."d:departureTime", A."d:arrivalTime", A."d:distance", A."d:distanceUnit", A."d:flightType", A."d:period", A."d:carrid", A."d:connid", A."d:fldate", A."d:PRICE", A."d:CURRENCY", A."d:PLANETYPE", A."d:SEATSMAX", A."d:SEATSOCC"]
============================================================================
----------------------------------------------------------------------------
OPTIMIZATION COMPLETE:
PROCESSOR PLAN:
ProjectNode(0) output=[A."d:countryFrom", A."d:cityFrom", A."d:airportFrom", A."d:countryTo", A."d:cityTo", A."d:airportTo", A."d:flightTime", A."d:departureTime", A."d:arrivalTime", A."d:distance", A."d:distanceUnit", A."d:flightType", A."d:period", A."d:carrid", A."d:connid", A."d:fldate", A."d:PRICE", A."d:CURRENCY", A."d:PLANETYPE", A."d:SEATSMAX", A."d:SEATSOCC"] [A."d:countryFrom", A."d:cityFrom", A."d:airportFrom", A."d:countryTo", A."d:cityTo", A."d:airportTo", A."d:flightTime", A."d:departureTime", A."d:arrivalTime", A."d:distance", A."d:distanceUnit", A."d:flightType", A."d:period", A."d:carrid", A."d:connid", A."d:fldate", A."d:PRICE", A."d:CURRENCY", A."d:PLANETYPE", A."d:SEATSMAX", A."d:SEATSOCC"]
JoinNode(1) [NESTED TABLE JOIN] [CROSS JOIN] output=[A."d:countryFrom", A."d:cityFrom", A."d:airportFrom", A."d:countryTo", A."d:cityTo", A."d:airportTo", A."d:flightTime", A."d:departureTime", A."d:arrivalTime", A."d:distance", A."d:distanceUnit", A."d:flightType", A."d:period", A."d:carrid", A."d:connid", A."d:fldate", A."d:PRICE", A."d:CURRENCY", A."d:PLANETYPE", A."d:SEATSMAX", A."d:SEATSOCC"]
ProjectNode(2) output=[f.result] [sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.result]
AccessNode(3) output=[sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.result, sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp.contentType] EXEC sap_opu_odata_IWFND_RMTSAMPLEFLIGHT_FlightCollection_Source.invokeHttp('GET', null, 'https://sapes1.sapdevcenter.com/sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection', TRUE)
XMLTableNode(4) output=[A."d:countryFrom", A."d:cityFrom", A."d:airportFrom", A."d:countryTo", A."d:cityTo", A."d:airportTo", A."d:flightTime", A."d:departureTime", A."d:arrivalTime", A."d:distance", A."d:distanceUnit", A."d:flightType", A."d:period", A."d:carrid", A."d:connid", A."d:fldate", A."d:PRICE", A."d:CURRENCY", A."d:PLANETYPE", A."d:SEATSMAX", A."d:SEATSOCC"]
============================================================================
08:14:38,111 ERROR [org.teiid.PROCESSOR] (Worker4_QueryProcessorQueue35) UaJGf50FZmif TEIID30019 Unexpected exception for request UaJGf50FZmif.0: java.lang.StackOverflowError
at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:58) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.common.buffer.TupleBuffer$TupleBufferTupleSource.finalRow(TupleBuffer.java:71) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.common.buffer.TupleBuffer$TupleBufferTupleSource.finalRow(TupleBuffer.java:71) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.common.buffer.TupleBuffer$TupleBufferTupleSource.finalRow(TupleBuffer.java:71) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.common.buffer.TupleBuffer$TupleBufferTupleSource.finalRow(TupleBuffer.java:71) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.common.buffer.TupleBuffer$TupleBufferTupleSource.finalRow(TupleBuffer.java:71) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.common.buffer.TupleBuffer$TupleBufferTupleSource.finalRow(TupleBuffer.java:71) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.common.buffer.TupleBuffer$TupleBufferTupleSource.finalRow(TupleBuffer.java:71) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.common.buffer.TupleBuffer$TupleBufferTupleSource.finalRow(TupleBuffer.java:71) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.common.buffer.TupleBuffer$TupleBufferTupleSource.finalRow(TupleBuffer.java:71) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.common.buffer.TupleBuffer$TupleBufferTupleSource.finalRow(TupleBuffer.java:71) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.common.buffer.TupleBuffer$TupleBufferTupleSource.finalRow(TupleBuffer.java:71) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.common.buffer.TupleBuffer$TupleBufferTupleSource.finalRow(TupleBuffer.java:71) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.common.buffer.TupleBuffer$TupleBufferTupleSource.finalRow(TupleBuffer.java:71) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.common.buffer.TupleBuffer$TupleBufferTupleSource.finalRow(TupleBuffer.java:71) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.common.buffer.TupleBuffer$TupleBufferTupleSource.finalRow(TupleBuffer.java:71) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.4.0.Final.jar:8.4.0.Final]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment