Created
August 16, 2013 14:14
-
-
Save tejones/6250290 to your computer and use it in GitHub Desktop.
Teiid StackOverflow
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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