Athena HIVE_METASTORE_ERROR

0

I am new to AWS and exploring Athena for querying S3 objects. I am using AWS Glue Crawler for data catalog.

I have successfully created table using Crawler for my JSON files available on the S3 location. The JSON file is having a complex structure with nested JSON objects. The created schema for the table is - Schema for the table

While I am querying the table with query -

SELECT * FROM "mydatabase"."brulocale" limit 10;

I am getting the error as below -

HIVE_METASTORE_ERROR: Error: : expected at the position 1161 of 'struct<loading:string,launch:struct<pageTitle:string,model:string,serial:string,problemCategory:string,problemType:string,launchButton:string,applianceType:string,manufacturer:string,serviceRecord:string,issueNotes:string>,home:struct<pageTitle:string,loginButton:string,helpText:string>,nope:struct<pageTitle:string,loginButton:string,helpText:string>,widgets:struct<issueHistory:string,faqs:string,topIssues:string,manuals:string,videos:string,noFAQs:string,noTopIssues:string,noVideos:string,noManuals:string,parts:string,partsRecommed:string,warrantyInfo:struct<registrationDate:string,installationDate:string,fullWarrantyDate:string,ssWarantyDate:string,partsOnlyDate:string,serialNumber:string,modelNumber:string,warrantyType:string,warrantyDescription:string>,FAQ:string,vidéos:string>,mediaWidget:struct<issueHistory:string,faqs:string,topIssues:string,manuals:string,videos:string,noFAQs:string,noTopIssues:string,noVideos:string,noManuals:string,partsRecommed:string>,chatbot:struct<title:string,solution:struct<moreInfo:string,lessInfo:string,moreSolution:string,lessSolution:string>,attachment:struct<moreSolution:string,lessSolution:string>,options/select_one:struct<lessOption:string,moreOption:string>>,applianceInfo:string,topLoadWashers:string,type:string,model#:string,serial#:string,top5Issues:string,noRecords:string,date:string,problem:string,jobDesc:string,parts:string,submit:string,feedbackDrawer.title:string,stc:string,swp:string,ns:string,stcResponse:string,swpResponse:string,nsResponse:string,stcResponseFailed:string,swpResponseFailed:string,nsResponseFailed:string,landingPage.welcomeMessage:string,project:string,partsPredicton.noData:string,applianceInfo.notFound:string>' but '/' is found. (Service: null; Status Code: 0; Error Code: null; Request ID: null; Proxy: null)
This query ran against the "mydatabase" database, unless qualified by the query. Please post the error message on our forum  or contact customer support  with Query Id: 3ff36139-b116-41c1-be4a-f2f2872df446

Can anyone please help me out to understand what could be the issue? Thanks.

  • Could you provide a sample JSON? Also are there percentages or '/' in the content portion of the JSON? Sometimes certain charecters could be interpreted by the Hive catalog or by Presto as escape characters

asked 2 years ago120 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions