Help Center/ Data Warehouse Service/ Standard Data Warehouse (9.1.0.x)/ DWS Performance Tuning/ SQL Tuning Examples/ Cases: Modifying Statements That Cannot Be Pushed Down/ Case: Type of Record in Non-real Table Can Not Be Shipped
Updated on 2026-05-29 GMT+08:00
View PDF

Case: Type of Record in Non-real Table Can Not Be Shipped

Possible Cause

In 8.2.1.x, the UPDATE statements + WITH statements cannot be pushed down.

Case 1: UPDATE Statements Are Not Pushed Down

  1. Set the GUC parameter enable_stream_ctescan to disable ctescan in the stream plan before statement execution. 
    1
    		 
    SET enable_stream_ctescan = off
  2. Reset the parameter after the service statement is executed. 
    1
    		 
    SET enable_stream_ctescan = on
  3. Add a hint after the UPDATE keyword in the statement. The specific method is UPDATE /*+ set global(enable_stream_ctescan off) */.
Parent Topic: Cases: Modifying Statements That Cannot Be Pushed Down