Athena is throwing DM_GWPipeline_Gateway_MashupDataAccessError. Please find the details below.

0

Hi, We are experiencing the below error from Athena. We don’t understand what is this. Kindly help us to resolve it. Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"ODBC: ERROR [HY000] [Simba][Athena] (1040) An error has been thrown from the AWS Athena client. Error Message: HIVE_CURSOR_ERROR: Unexpected end of input stream [Execution ID: f12fbd2d-2a3d-4733-8fbf-d08cba034b2d]"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Odbc"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"dsn=Simba Athena"}},{"code":"Microsoft.Data.Mashup.ValueError.OdbcErrors","detail":{"type":1,"value":"#table({"SQLState", "NativeError", "Message"}, {})"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Cluster URI: WABI-AUSTRALIA-SOUTHEAST-redirect.analysis.windows.net Activity ID: 384566a5-57db-49e4-bf46-76ef6ba5eb57 Request ID: 34416ea9-e4e4-114b-8343-f3231319a688 Time: 2023-03-10 08:17:11Z

asked a year ago478 views
1 Answer
0

The actual error seems to be "HIVE_CURSOR_ERROR: Unexpected end of input stream". This message indicates the file is either corrupted or empty. Check the integrity of the file and rerun the query. It might be malformed JSON. Please check the data you are trying to parse. There must be a formatting issue with the data that you are parsing or empty data

profile pictureAWS
answered a year ago

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