Known issue - SQL analytics endpoint table queries fail due to RLE
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.