Help Center/ Data Warehouse Service/ Developer Guide/ Developer Guide (9.1.0.x)/ DWS Performance Tuning/ SQL Tuning Examples/ Cases: Modifying Statements That Cannot Be Pushed Down/ Case: Table in TargetList Can Not Be Shipped
Updated on 2026-01-04 GMT+08:00
View PDF
Share

Case: Table in TargetList Can Not Be Shipped

Possible Cause

The table name or alias is in the targetlist (between SELECT and FROM).

Solution: Rewrite the SQL statement to eliminate the direct reference to the table name or alias.

Case 1: Using the Alias t of the Test Table in the targetlist

Original statement

1
 
SELECT t, 1 FROM test t;

Rewritten statement: Convert the table name or alias to the text type, or optimize the SQL statement to remove the table name or alias from the output column.

1
 
SELECT t::text, 1 FROM test t;

Parent Topic: Cases: Modifying Statements That Cannot Be Pushed Down