KNOWLEDGE BASE

Data Connection Error: "B19090E0: Presto Query Error: Loaded block positions count(0) doesn't match lazy block positions count"


Published: 04 Jan 2023
Last Modified Date: 04 Jan 2023

Issue

A query with the Presto connector using the function CAST(JSON_EXTRACT(XXX)) is not working in Tableau Desktop and it is throwing the error:

 B19090E0: Presto Query Error: Loaded block positions count(0) doesn't match lazy block positions count 

Environment

  • Tableau Desktop 
  • Presto

Resolution

Work with the database administrator to solve the data format issue as follows:

The incorrect JSON format: {"A" = "B", "C" = "D"} 

The correct JSON format: {"A": "B", "C": "D"}

 

Cause

The data source JSON format is incorrect.
 
Did this article resolve the issue?