Looks like the issue is with the property jsonPath which gets added by the AWS glue crawler to the table properties when you attach a custom JSON classifier. When you query this table using AWS Athena with the JSON serde org.openx.data.jsonserde.JsonSerDe , it is not able to understand this property and hence it might not be able to parse the JSON data resulting in empty rows.
I would suggest you to check on this blog for querying nested JSON data using AWS Athena.
However, a Glue ETL job is able to read the table and display the output successfully !!
AWS Athena JSON serde reference
Converting JSON string to table/ojbect in Luaasked 5 years ago
AWS Glue crawler exclude patterns not workingAccepted Answerasked 6 months ago
Loading json string data as super from Glue job in to Redshiftasked 8 months ago
flatten deeply nested JSON with CrawlerAccepted Answerasked 2 years ago
JSON Custom Classifier not parsing dataasked 25 days ago
Glue crawler json parsingasked 25 days ago
[Pandas] [Glue] ResolveChoice cannot cast to JSONasked 9 days ago
How to ensure that ALL json object fields are imported into QuickSight?asked a day ago
AWS Glue crawler detecting a .(dot) before header of a csv fileasked 4 years ago
Importing json that has a nested arrayAccepted Answerasked 3 years ago