Search code examples
azure-data-lakeu-sql

Optimizer internal error while loading data from U-SQL table


Is there a way to get around this error.

"CQO: Internal Error - Optimizer internal error. Assert: a_drgcidChild->CLength() == UlSafeCLength(popMS->Pdrgcid()) in rlstreamset.cpp:499"

Facing this issue while loading data from partitioned U-SQL table.

@myData =
    SELECT *
    FROM dbo.MyTable;

Solution

  • If you encounter any system error message (or something that says Internal Error), please open a support ticket with us and/or send me your job link (if it happens on the cluster) or a self-contained smallest repro (if it is happening with local run) to usql at microsoft dot com.

    Thanks Michael

    UPDATE: This issue has been fixed and will be made available in the next refresh. If you are blocked, please contact me for a private runtime.