DATA_SHIP_MODE Values
DATA_SHIP_MODE is a SELECT option that controls automatic rework of federated queries across data sources. Reworked table selections can be shipped through an API to temporary tables so that query nodes can be joined with local tables.
DATA_SHIP_MODE modifies how the query engine handles queries that are candidates for data ship optimization.
When any of these DATA_SHIP_MODE options is specified in a query, it overrides the value specified in the TDV Server > SQL Engine > Optimizations > Data Ship Query > Execution Mode configuration parameter.
DATA_SHIP_MODE
DATA_SHIP_MODE Syntax | Example |
DATA_SHIP_MODE="DISABLED" | SELECT {OPTION DATA_SHIP_MODE="DISABLED"} foo FROM... |
DATA_SHIP_MODE="EXECUTE_FULL_SHIP_ONLY" | SELECT {OPTION DATA_SHIP_MODE="EXECUTE_FULL_SHIP_ONLY"} foo FROM ... |
DATA_SHIP_MODE="EXECUTE_ORIGINAL" | SELECT {OPTION DATA_SHIP_MODE="EXECUTE_ORIGINAL"} foo FROM... |
DATA_SHIP_MODE="EXECUTE_PARTIAL_SHIP" | SELECT {OPTION DATA_SHIP_MODE="EXECUTE_PARTIAL_SHIP"} foo FROM ... |