SAP Knowledge Base Article - Preview

3789239 - Remote Table preview, for a Data Product shared from Databricks, fails with "encoding type is not supported in parquet: encoding_type=5"

Symptom

  • Data Product shared from Enterprise Databricks and installed as a remote table is not readable in the target.
  • Data preview and views on top of the remote table return: "SQL processing error: Encoding type is not supported in parquet: encoding_type=5".
  • Additional log messages observed: "SQL Error 129 - transaction rolled back by an internal error: Encoding type is not supported in parquet: encoding_type=5".
  • Additional log messages observed: "SQL Error 8 - invalid argument: ALTER REMOTE SUBSCRIPTION INITIAL LOAD EXECUTE is not possible for the specified chunk id(s): 1; id does not exist or already processed".
  • Source column type: INT; target column type: INTEGER.


Read more...

Environment

  • SAP Business Data Cloud
  • SAP Business Data Cloud Connect
  • Enterprise Databricks

Product

SAP Business Data Cloud all versions

Keywords

databricks, delta sharing, parquet encoding type 5, encoding_type=5, delta_binary_packed, parquet v2, remote table, preview, sql processing error , KBA , DS-DI-RT , Remote Tables , BDC-CON , SAP Business Data Cloud Connect , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.