SQL enhanced operations

Feature

Is Supported

Limitations

MaxCompute Cloud-native Big Data Computing Service - EXPLAIN

Yes

None

MaxCompute Cloud-native Big Data Computing Service - CLONE TABLE

Yes

None

MaxCompute Cloud-native Big Data Computing Service - Parameterized View

Yes

• Creating a Parameterized View

  • Table-valued parameters are not supported.

  • Supports all MaxCompute data types.

  • Supports select_statement but does not support begin {statements} end.

    Note

    select_statement is limited to queries on physical tables or views and does not extend to logical tables or views.

• Querying a Parameterized View

  • Supported scenarios include ad hoc queries, SQL tasks, computation logic for logical objects, and parameter filtering in integrated source and target tables.

  • Querying parameterized views with table-valued parameters is not supported (authentication for the corresponding table is not possible).

    Note

    If the error message Parameterized view with table parameter is not supported yet appears, verify the presence of parameterized views with table-valued parameters in the current statement.

MaxCompute Cloud-native Big Data Computing Service - LOAD

Yes

None