Edit

Share via

Known issue - SQL analytics endpoint table queries fail due to RLE

  • Article

When creating a delta table, you can use run length encoding (RLE). If the delta writer uses RLE on the table you try to query in the SQL analytics endpoint, you receive an error.

Status: Open

Product Experience: Data Engineering

Symptoms

When you query a table in the SQL analytics endpoint, you receive an error. The error message is similar to: Error handing external file: 'Unknown encoding type.'

Solutions and workarounds

To resolve the issue, you can disable RLE in the delta writer and recreate the delta table. You can then query the table in the SQL analytics endpoint.

Next steps