DQL operations

Feature

Supported

Yes

• Supports *

• Supports distinct

• Does not support regular expressions

Dataphin 2.9.2 and later versions support partition pruning for user-defined functions (UDFs).

When the GROUP BY property is set, i.e., set odps.sql.groupby.position.alias=true;, integer constants in the GROUP BY clause are treated as the ordinal numbers of columns in the SELECT list. For more information, see

Yes

• Supports select {select_expr} from ({select_statement}) {sq_alias_name};

• Does not support select ({select_statement}) from {table_name};

Yes

Yes

Yes

• Supports intersect

• Does not support intersect all

• Does not support intersect distinct

• Supports union all

• Supports union [distinct]

• Supports except

• Supports except all

• Supports minus

• Does not support except distinct

• Does not support minus distinct

• Does not support minus distinct

Yes

Yes

Yes

Yes

Yes

Yes

No

No

No

No

Yes

Yes

Yes

PIVOT and UNPIVOT

Yes