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
Last Modified Date: 04 Jan 2023
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.Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials